Post reply

SSIS Questions.

  • July 28, 2006 at 6:18 am

    #118892

    Hello,

     I have written an SSIS package to transfer a flat file into an Oracle database using the MS OLE DB provider for Oracle.  Works like a charm.  I want to add a Derived Column Transformation to it that will insert an identity type value in the first column of the database table.  Each value needs to be sequential like 1, 2, 3 …

    Also

    Is there a way to truncate the destination database table prior to importing from the source flat file all with in my SSIS package?  Thank you.

    David

    Best Regards,

    ~David

  • July 31, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 31, 2006 at 1:39 pm

    #652458

    Before the data flow step you can add an Execute SQL step with a DELETE or TRUNCATE TABLE command.

    I'm not sure how you could define an identity column with the Derived Column transform, but it would be trivial to do in a script component.

  • July 31, 2006 at 1:59 pm

    #652460

    The execute SQL step worked great.  I will look into doint the identity value using vb script.  Do you have an idea on how to do that?  Thank you very much for your help.

     

    David

    Best Regards,

    ~David

  • July 31, 2006 at 2:28 pm

    #652461

    Here's an example: http://www.sqlis.com/default.aspx?37

     

  • July 31, 2006 at 2:31 pm

    #652462

    Awsome!!!  Thank you.

     

    David

     

    Best Regards,

    ~David

Viewing 6 posts - 1 through 5 (of 5 total)

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