Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: Create Table + Bulk Insert

    Hi guys,

    I have a .csv file wich has the following information (exactly like this):

    List Name: User
    Format Version:
    Date:12/11/2012 12:00:34


    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:". I need to create a collumn called "Equipment", other collumn called "IP" and insert this information (repeat "L6867000214" and "" in all records bulk inserted). The result must be like this:

    IP,Equipment.,User,Name,Total,B&W, Color,L6867000214,[1600],[technical],76,76,L6867000214,[6611],[Daise],559,559,L6867000214,[900301],[Richard],0,0

    I have no ideia how to do that. Could anyone here help me out on this issue?

    Thanks a lot!

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    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.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts