SQL_Kills (12/16/2013)
1. I need to create a ssis package2. I want it to query the orders table for each orderid then for each result set it returns for each orderid to create a text file.
3. Each text file I would like the name of the orderid it has queried.
I understand your requirement, but you have not told us which part you need help with. At the moment, I am therefore suspecting the following:
"Please write this entire package for me, for free, so that I can take all the credit and pretend that I know what I am doing."
--Edit: fix typo
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.