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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2008-10-27 : 06:43:08
|
| I want to dynamically create a destination csv file to export data to. I know I can do this using a script task. However, I don't know VB.NET and therefore, don't know how to write the script.Has anyone got a sample that I can cut and paste and place into a script task please (and I'll change file name/path, etc)ThanksHearty head pats |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 06:49:30
|
| I think you can create a csv using DataFlow task with flat file destination task.Coose between OLEDB source of flat file source depending on whether source data is coming from table or file. |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2008-10-27 : 06:56:39
|
| You're right. I can just specify a filename, and it will automatically be created in the data flow task.ThanksHearty head pats |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 07:17:25
|
quote:
Originally posted by Bex
You're right. I can just specify a filename, and it will automatically be created in the data flow task.ThanksHearty head pats
cheers  |
|
|
|
|
|
|
Dynamically create destination file