Post reply

Dynamic file file connection manager based on values

  • January 7, 2011 at 1:23 pm

    #141992

    OK - I know I can do this in a repetitive manner but if I could find a way to select which connection manager to use for a data flow then I could have half the number of data flows and half the number of tasks to maintain.

    The data can come from 2 different file types of differing structures. Once either file runs through the connection manager the data fields are the same and are processed almost identically. The differences come in through variables and can be split out quite easily in the transformations.

    So is there a way to tell the OLE DB data source which connection manager to use? I'm not seeing anywhere to set that in expressions.

    Is this a pipe dream and I'll have to duplicate code across the data flows?

  • January 14, 2011 at 12:24 pm

    #1273730

    Hi,

    You cannot change the OLEDB Source connection dynamically at runtime. However you can change the OLEDB Connection Manager parameters dynamically using expressions. Have you tried this?

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

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

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