DTS Package

I know you can save a DTS file off as a vb file. I've used that quite often.
But is there any way to run a DTS package from T-SQL code?
Btw, I've been playing around with dtsrun for the last half hour and can't
get it to work. I keep getting the following error msg whether I run it
under the domain service account, my own account or the sa password:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
"CLM" wrote:

> I know you can save a DTS file off as a vb file. I've used that quite often.
> But is there any way to run a DTS package from T-SQL code?
|||Post your code and maybe we'll see the problem. I use xp_cmdshell with dtsrun
and it works.
TIA,
ChrisR
"CLM" wrote:
[vbcol=seagreen]
> Btw, I've been playing around with dtsrun for the last half hour and can't
> get it to work. I keep getting the following error msg whether I run it
> under the domain service account, my own account or the sa password:
> [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
>
> "CLM" wrote:
|||Thx. I just got it to work!
"ChrisR" wrote:
[vbcol=seagreen]
> Post your code and maybe we'll see the problem. I use xp_cmdshell with dtsrun
> and it works.
> --
> TIA,
> ChrisR
>
> "CLM" wrote: