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 |
|
splogsp
Starting Member
1 Post |
 Posted - 2009-01-27 : 18:49:53
|
| I want to create a job, which runs on each month 10th day. this job runs stored procedure and creates .CSV file with result. Also job should push this generated .csv file to FTP server. and this file should have different name each time(like datetime in file name).Please help me, how can I accomplish this. Also the sql server is 2000 but we are accessing those under MS SQL server management studio. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-28 : 09:04:31
|
| just create a SSIS package which executes the procedure by means of Execute sql job. then use ftp task to push the csv file to server. For giving dynamic filename, just add a new variable in package and set evaluate as expression true for it. then use expression builder to set name to something like'yourfilename_'+ @[System::StartTime]and use a parameter in procedurte to get this value and make it filename. rememeber to map parameter to variable in execute sql parameter mapping window |
 |
|
|
|
|
|
which one is better and how to do it DTS or SSIS?