Post reply

SSIS with script

  • November 3, 2011 at 4:12 pm

    #247281

    Hi,

    I've a package that imports data from a flat file, does some conversion with C# and loads into a table. In case C# fails, the line that caused the issue gets stored in a variable and then written to another flat file. Is there a way to write that error line directly into a table instead of a file?

    Thanks

  • November 3, 2011 at 4:39 pm

    #1402982

    Yes you can.

    You would create a data connection to the database inside your script and then insert those records into the table.

    Here is an article on creating such a connection.

    http://msdn.microsoft.com/en-us/library/ms135939.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 3, 2011 at 7:24 pm

    #1403001

    SQLRNNR (11/3/2011)

    Yes you can.

    You would create a data connection to the database inside your script and then insert those records into the table.

    Here is an article on creating such a connection.

    http://msdn.microsoft.com/en-us/library/ms135939.aspx

    Thanks.

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

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