Hi Parkin,

Definitely I will be using SQL Agent / Control M to automate the Job. At present these Production environments ( SQL , SSIS , Shared drive) are new severs...

Unfortunately, the above solution with escape using another double quotes like "" Well "" didn't help.
For  ow what I did is, in the advanced property of the flat...

Thanks for clarifying it. So that means this escape sequence needs to be done at the source end while generating the file itself, and no other solution to laod it...

Sorry, I didnt get when you said file format is incorrect... Are you saying the source file should have created without double quotes for the columns, i.e with no text...

Thanks for the respose. However, here this is not a problem with file generation, this is valid text. i.e we can expect double quotes in the text which is coming...

Ya I thought about that but unfortunately in my case the column list are different. But yes I can play around it.

Thanks , yes I can use it as different data results , but I will end up in executing the Same Stored Procesure multiple times.

I'm using this stored procedure as data source in the DFT of SSIS. This Stored procedure has got two result set.. so just trying to see if I can map...

For example, I have one Stored Procedure that gives me two result sets... and I wan to use this Stored Procedure as Data source in DFT of SSIS.

So checking...

Nice.. that worked thanks for your help.

I have one more question.. if there are two result sets like below, is there any way map them in SSIS?

EXEC dbo.GetOrderInfo @orderid...

Nice.. that worked thanks for your help.

I have one more question.. if there are two result sets like below, is there any way map them in SSIS?

EXEC dbo.GetOrderInfo @orderid...

I was trying to use it in SSIS , OLEDB Source and data access more as SQL command and I tried as bellow but wanted to know how to pass...

This is case can some one tell me what would be the syntax if the Stored Procedure has got some input / put put parameter?

Thanks for all your response.

I have done it using For Each Loop Container , Execute SQL Task, File System task combination... I have retrieved the folder names from file names...

Thanks for the response. Can any of you please elaborate the solution using script task?