SSIS Connection - Data Source Designer (unable to create dynamic conn)

• raj bassi

  SSC Journeyman

  Points: 89

  More actions

  July 27, 2007 at 9:01 am

  #117966

  Hi,

  I've been struggling to create a dynamic connection within my SSIS package, I already have one dynamic connection (stage) which is functioning and I am able to go to Edit > Data Source Designer window...However, my other connection (ETL) is not dynamic - I have both cong files enabled within SSIS package configs and the property settings for both seem to be the similar with the exception of servernames etc - but still the ETL connection does not appear with the 'blue arrows' around it like the Stage connection...

  any ideas....please help?

• raj bassi

  SSC Journeyman

  Points: 89

  More actions

  July 27, 2007 at 9:07 am

  #722915

  IGNORE THE QUESTION ABOVE....I'VE JUST FIGURED IT OUT...

  I need to use a connection from data source - its got nothing to do with dynamic configuration....

  you'll be seeing more of me here....

  Raj