No ConnectionString Property in ForEach Loop Container

• rsayles7

  Newbie

  Points: 1

  More actions

  August 18, 2008 at 2:26 pm

  #123837

  I am following the Wrox book by Brian Knight and others. I am building a For Each Loop container for a data flow task. I am following the steps in the book but when I get to the step on page 140 that says assisgn my User variable to ConnectionString I dont have ConnectionString as one of my choices.

  I have added the loop container, dragged my task onto it, assigned the variable and location of files. I am no on propererties of my data flow task under Expressions and am in the Property Expressions Editor. This Property drop down box does not have ConnectionString. Did I miss a step???

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 18, 2008 at 3:31 pm

  #859705

  The property is on the connection manager, not dataflow.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!