Post reply

Dynamic OLEDB destinations

  • April 13, 2009 at 11:12 am

    #136570

    I have a task at hand of migrating 1000 tables from AS400 to SQL Server. I automated the part of bringing the data into a Raw area, but now there are a few transformations i wish to run on the Raw to Staging tables before i make a final dump into the warehouse table. My question is - has anyone here been able to dynamically run different targets in OLEDB destination adapters (NOT THE SOURCE CONNECTION - i am able to set the SQL Command from variable).

    Has anyone been able to dynamically change metadata in the Data Flow Task??

    Thanks.

  • April 13, 2009 at 11:50 am

    #976773

    Anyone....?

  • April 22, 2009 at 12:46 pm

    #982430

    vishal.gamji (4/13/2009)

    I have a task at hand of migrating 1000 tables from AS400 to SQL Server. I automated the part of bringing the data into a Raw area, but now there are a few transformations i wish to run on the Raw to Staging tables before i make a final dump into the warehouse table. My question is - has anyone here been able to dynamically run different targets in OLEDB destination adapters (NOT THE SOURCE CONNECTION - i am able to set the SQL Command from variable).

    Has anyone been able to dynamically change metadata in the Data Flow Task??

    Thanks.

    Which metadata in particular you want changed? The data flow task is quite static in nature.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • April 22, 2009 at 12:50 pm

    #982432

    Thanks, but i figured it out.

  • April 22, 2009 at 12:58 pm

    #982441

    Did you have to do programmatic building of data flows? What is the solution you have come up?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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