 | |
Re: Running DTS Package
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Running DTS Package -
04-02-2004
, 01:50 PM
|
The OLE errors are not very intuitive Are you simply firing the package? What about using xp_cmdshell and DTSRUN -- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote in message news:OjNLM4KFEHA.696 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Thankes allan I can't belive the there is no sp_ that do this I've tried the OLE way but it don't work and it doesn't tell me way The name i give to my package is: Load From Import what can be the problem? "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:Oj#v8CnEEHA.3788 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Have a look through here Execute a package from T-SQL (http://www.sqldts.com/default.aspx?210) -- ---------------------------- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Roy Goldhammer" <roygoldh (AT) hotmail (DOT) com> wrote in message news:%23uvURbmEEHA.3788 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hello there Is there a way to run DTS Packege via sql code? on the query anlyser? any help would be useful |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.