CSV OutPut in DTS

Last Post 14 Oct 2007 02:34 AM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ramprathap
New Member
New Member

--
10 Oct 2007 12:08 AM
Hi

I need to generate .csv file ouput for storeprocedure in scheduled manner . I used DTS to do this , the issue here is when the .CSV file is created , the data in the file goes into Single column

Could any one think of any work around for this ?
SQLUSA
New Member
New Member

--
14 Oct 2007 02:34 AM
Use DTS Import/Export wizard to set it up for you.

Kalman Toth
www.sqlusa.com
kpatnam
New Member
New Member

--
07 Feb 2008 02:56 AM

Hi Ramprathap,

could u pls xplain me hw to generate a .csv file using
dts package.
Its very essential for me.
Pls mail me to kpatnam@gmail.com

Thanks in advance

SQLUSA
New Member
New Member

--
07 Feb 2008 04:00 AM
You fire up the DTS import/export wizard.

1. You select database source like pubs

2. You select TEXT FILE destination (path)authors.csv

3. You set the destination file format (the default is usually ok)

4. You select the table (or query) as the source

5. Set first row has column name option

6. You can also do transfomation

7. Finish & run (optionally you can save the package)

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005ssis/ The Best SQL Server 2005 Training in the World!



Acceptable Use Policy
---