Post reply

Create Table 'ABC' -->Flat File --> Insert INTO Table 'ABC'

  • April 27, 2009 at 4:20 am

    #203344

    Im getting a bit lost here!

    I want to:

    1 - Create a Table

    2 - Load a flat file (csv)

    3- Insert the columns from the flat file into the table

    So far I have used a:

    1 - Execute SQL Task to create the table

    2 - Data Flow take to Point to the Flat file

    3 - This is where im stuck!

    If i use a OLE DB Destination i cannot select the table to insert into as the table has not been created yet.

    How can i create this transition of CREATE - LOAD - INSERT?

  • April 27, 2009 at 4:51 am

    #984252

    To use the graphical mapping tools in SSIS, it needs to extract the source and target metadata from an existing table/file ... hence your problem.

    Can you explain why you cannot create the table in advance of performing the import? Is it because the columns and datatypes in the table are varying? If that is the case, your source metadata will fail validation when the format of the source changes and you're snookered anyway.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply