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 |
|
shan1430
Yak Posting Veteran
86 Posts |
 Posted - 2008-07-03 : 03:09:05
|
| hi All, I have some weird problem need you guys to advise, I had created my DTS package with contain the SQL script. This DTS package running fine when i execute it in the Entreprise Manager, all my table can update with the expected value after running the SQL code. Those, I had save my .dts file to my C drive, and i created the .bat file to run my DTS, after the .bat file being creted, i try to double click on the .bat, but it cant work, the table never update per the SQL result. Anyone can advise, what going wrong here when i creating my .bat files. the contain of the .bat file is ( dts run C:/xxx.dts) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-03 : 03:26:13
|
| http://www.sqlteam.com/article/programmatically-save-dts-packages-to-files |
 |
|
|
|
|
|
DTS Package