February 16, 2012 at 3:08 am
Koen Verbeeck (2/16/2012)
OK, that won't work in a dataflow with an OLE DB Command, as the sp can probably return more than one line. Next time be a little more specific in what you are trying to accomplish.In this case, the script task is indeed a good solution.
Read the text file (there's plenty of code on the net on how to read a text file using .NET) and store the results in a dataset. Loop over this dataset and for each iteration call the stored procedure and capture the results in another dataset. (again, enough code samples on the net for that). Write the those results to another text file.
Emphasis added.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 16, 2012 at 3:50 am
I don't know.net what is data-set i am fresh to SSIS i knew SQL
February 16, 2012 at 4:00 am
But you do know Google right?
Anyway, here's a link:
http://bytes.com/topic/c-sharp/answers/268038-write-text-file-into-dataset
(Googled for .NET store file into dataset)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply