SSIS stored proc output to csv file

Last Post 11 Nov 2008 01:20 PM by Worldnow1. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Worldnow1
New Member
New Member

--
11 Nov 2008 07:43 AM
Hi
I am trying to save the output of a stored proc in a csv file using SSIS. I am new to SSIS, what is the best way to go about it? I tried using bcp, but the columns were not formatted properly.

Thanks for any help.
Worldnow1
New Member
New Member

--
11 Nov 2008 09:27 AM
Yeah
I tried that, the only problem is that there is a comma in one of the columns and the csv file is taking it as a delimiter. The row size is too large for an xls sheet. Thanks for the quick response.
Worldnow1
New Member
New Member

--
11 Nov 2008 01:20 PM
right, but when I try to export it to csv it still takes the comma as the delimiter and puts the data in seperate columns. I changed the logic in my proc and just replaced the comma by blank space.


Acceptable Use Policy
---