Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashishsaxena82
Starting Member
3 Posts |
 Posted - 2008-09-25 : 10:34:57
|
| Hi I need your's assistence ,,i am stuck in one step ,,,i want to copy data from csv file to excel file in dts Pacakage.i am using fso object to read the csv file but unable to move the data into excel file.can anyone send me Code if you have ??your help appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 10:54:18
|
| have you tried using flatfile source and excel destination tasks? |
 |
|
|
ashishsaxena82
Starting Member
3 Posts |
Posted - 2008-09-25 : 10:56:08
|
quote:
Originally posted by visakh16
have you tried using flatfile source and excel destination tasks?
Please Let me Know How to use this |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 11:00:48
|
quote:
Originally posted by ashishsaxena82
quote:
Originally posted by visakh16
have you tried using flatfile source and excel destination tasks?
Please Let me Know How to use this
You've different connections available in dts. just drag and drop a flat file source from your toolbox in dts and point it to csv file.Similarly, drag and drop excel file destination and point it to your destination file. now select transform data task from task menu on top. select flatfile task as source and excel task as destination. an arrosw joining two will appear. double click arrow and preview data and check transformation to see if they are correctly mapped. Now try running DTS. |
|
|
|
|
|
|
Copy data From Csv file to Excel file