It might be really stupid question but as i dont know how to do it its really difficult for me.
Here's what i need to do
I need to create a dts package to get data from tables using query and write it to a file (.csv file).
I am able to do till here and now struggling with
1. how can i make sure that everytime the file is written to the folder its named "Test" + datetimestamp + ".CSV" eg
Test12012005054530.csv
Dont know how can i do this
Here's what i need to do
I need to create a dts package to get data from tables using query and write it to a file (.csv file).
I am able to do till here and now struggling with
1. how can i make sure that everytime the file is written to the folder its named "Test" + datetimestamp + ".CSV" eg
Test12012005054530.csv
Dont know how can i do this