divyanth (3/29/2010)
you add the ForEach Loop to the package do you drag it on to the work area and then drop the connection inside of the loop or do you drop the ForEach Loop on top of the Connection ?
Good to hear that you got it working.. Well both ways work, but i would prefer adding the ForEach and then drop the connection inside.. Assuming that you are referring to a Data FLow Task or control Flow task item by saying "Connection". Am i right?
Yes you are correct in yoru assumptions. I still have a ways to go with the terminology. I hate that SSIS is so counter intuitive because it was one of the more 'most anticipated' things on my SQL Server 2005 fun list and when it came out and I found out what SSIS was like I found myself putting it off again and again, choosing alternate solutions whcih took less time to do even when doing tehm with SSIS woudl be faster once you mastered how to use SSIS. Its just a big learning curve with SSIS. I wish I had weeks of paid time off to learn it right but I don't.
Thanks
Kindest Regards,
Just say No to Facebook!