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 |
|
juvethski
Starting Member
46 Posts |
 Posted - 2005-09-28 : 18:42:32
|
| is this possiblem executing it from a sql statement?thanks |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-09-30 : 10:47:38
|
| yes its possible by running profiler... all dts packages statements can be captured in the profiler, hence, the sql equivalent can be extracted... this is what my friend told me, but we did not finish it last night. is there anybody here who knows how to do this? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-09-30 : 16:18:42
|
| You can use dtsrun from xp_cmdshell (which is what the agent does).Or use the com SPs to load and run the package.This is for the com version - see bol for dtsrunhttp://www.mindsdoor.net/DTS/sp_oacreateLoadDTSpackage.html==========================================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. |
|
|
|
Jman82
Starting Member
3 Posts |
Posted - 2005-10-04 : 16:03:03
|
| you may also click on start in windows, then run, the type dtsrunui.from there you will then be able to generate the exact line of code you will need to put in your stored procedure. Note: if your running SQL 2000 on your desktop, and SQL 7 on your server then you must select the encrypt box when you generate it as well. |
|
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-10-05 : 14:55:04
|
| thanks for the inputs... i got it working. |
|
|
|
|
|
|
executing dts package