Post reply

Loading dirty data dynamically in different tables

  • March 30, 2010 at 6:07 am

    #139969

    Scenario: I'm loading data from 7 databases using dynamic connection string in for loop container. Database schema is same in all databases. At destination I have created 7 tables with 7 database names (data is loading from) to load dirty data in thier corresponding table.

    Question: How do I make sure that dirty data for a specific DB is loaded in its corresponding table at destination DB. I want to do this dynamically.

    Any help is appreciated.

  • March 30, 2010 at 6:37 am

    #1142122

    all you need to do is make the connection string to the destination dynamic like you did for the source connection string

  • March 30, 2010 at 11:36 am

    #1142500

    7 tables in one database to be loaded dynamically. Connection string should be static for DB.

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

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