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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2006-06-01 : 06:08:23
|
| HiI have DTS package ,I have to run that package using ADO.connection from my frent end applicationis it possible |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-01 : 07:14:33
|
| Do you mean you have to connect using ado within the oackage or you have to execute the package on an ado connection (which doesn't really make sense).Where do you want the package to run? dts is a client application so can run on any machine.It will probably be executed via dtsrun which is a command line utility you just have to execute that statement on the machine you want the package to run on. If you need an ado connection to run it then you can use xp_cmdshell to execute the dtsrun statement - that will probably mean it's running on the datbase server though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2006-06-01 : 07:26:46
|
| I want execute package |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-01 : 07:57:41
|
| then use dtsrun==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
How to run DTS pagckage using ADO connection