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 oft
en.
> 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 dtsru
n
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 violatio
n
>
> "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 dts
run
> and it works.
> --
> TIA,
> ChrisR
>
> "CLM" wrote:
>