Post reply

OLE DB data access from a variable

  • December 15, 2008 at 8:57 am

    #202897

    Is it possible to change the source table, with may contain different columns at runtime with SSIS?

  • December 15, 2008 at 9:50 am

    #912597

    Yes and no.

    SSIS is tied heavily to the meta-data. So, if you design your package through the GUI and select a table as a data source, the components in your data flow will include inputs and outputs that have all of the meta-data defined in them. This means a schema change will break your package.

    SSIS is designed to allow you to dynamically build packages through code. MS has a bunch of information and here is an article from this site:

    http://www.sqlservercentral.com/articles/Integration+Services/64572/[/url]

  • December 15, 2008 at 10:06 am

    #912622

    Thanks for your response. I will check out that link.

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

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