Thread: Create Table + Bulk Insert
12-16-12, 15:12 #1Registered User
- Join Date
- Dec 2012
Unanswered: Create Table + Bulk Insert
I have a .csv file wich has the following information (exactly like this):
List Name: User
I want to execute a create table and a bulk insert transaction but I don't know how to insert the information of the top lines of the .csv file like "Equipment.:L6867000214" and "IP:172.21.12.62". I need to create a collumn called "Equipment", other collumn called "IP" and insert this information (repeat "L6867000214" and "172.21.12.62" in all records bulk inserted). The result must be like this:
I have no ideia how to do that. Could anyone here help me out on this issue?
Thanks a lot!
12-16-12, 16:52 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
You could use an SSIS package to do this.
Depending on what rules you use to govern the transformation it could be just two steps. If the transformation is complex SSIS can still handle it, but it would require more code to handle a complex transformation.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.