SSIS stored proc output to csv file

Last Post 11 Nov 2008 01:20 PM by Worldnow1. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy