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 |
|
vl
Starting Member
14 Posts |
 Posted - 2008-03-27 : 11:50:13
|
| I am new to the SSIS. For DTS package of sql server 2000, I can call a DTS package from stored procedure. The command is:dtsrun /E /SMyServer /NMyDTS /Wtrue /A Parameter1:3= 'Test'Does anyone know, how do I do the similar thing from SSIS environment.1) How to call a SSIS package from Stored Procedure? 2) How do I pass parameter to the SSIS package?Thanks everyone. |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-03-27 : 15:01:23
|
| SQL Books on line .. dtutil or dtexec |
 |
|
|
|
|
|
How to pass parameter to DTS package