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 |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2009-03-30 : 08:15:36
|
| Hi,I'm trying to dynamically build a csv file, at start I delete the file. Then Create using a Data Flow task with a Ole DB Source writing to Flat File Destination. the source being: Select '' as 'Error Task'and it writes the file but when the Csv files is viewed in notepad it adds extra commas. Should have been: Error Task but outputs: Error Task , , ,or how can i create the file using the script taskPlease Assist,Regards |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2009-03-30 : 08:41:46
|
| Created a template file and then have a File Copy task which just copies it to the required destination. |
 |
|
|
|
|
|
Create Csv File from DF adds additional commas