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 |
|
nishi57
Starting Member
20 Posts |
 Posted - 2007-09-12 : 08:21:59
|
| I have couple of DTS Packages that I want to run on the server running SQL Server 2000, how do I go about running those? Any help will be greatly appreciated. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 08:26:47
|
| You can run manually by opening and pressing the green run icon.You can schedule the dts in a sql job by using the dtsrun command.You can schedule the dts in a windows job by using the dtsrun command.You can launch it from code there is OLE DTS object in you install the sql client tools on the development machine.DTSrun is installed if you have a minimum the SQL Client installed on the server which kicks off the package.PS: If anyone is interested in a SQL position in CT with excellent pay please send your resume to ValterBorges@msn.com |
 |
|
|
nishi57
Starting Member
20 Posts |
Posted - 2007-09-12 : 10:08:57
|
| Thanks ValterBorges for your help. |
|
|
|
|
|
|
Execute DTS Packages