Dynamic file file connection manager based on values

• JustMarie

  SSCertifiable

  Points: 7771

  More actions

  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?

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  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/