Can I run a DTS package from a stored procedure?
If so, How?
Execute a package from T-SQL
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Quote:> Hi Lou,
> Yes it should be possible by using xp_cmdshell within your stored
> and a command line calling the dtsrun utility, these are both documented
> really well in Books On Line for both SQL 7 and SQL2000.
> This posting is provided "AS IS" with no warranties, and confers no
Is there any way to import different file names using one DTS package
without having to script the package in VB?
FILE DTS PACKAGE
A.txt <----- dts_import
B.txt <----- dts_import
Thanks in advance.....