That is a story long time ago for me. So what's your problem when you create job for legacy DTS package?

Thank you, Greg.

Finally find out solution here: http://support.microsoft.com/kb/322746

So there two ways: one is plain text, one is encrypt:

dtsrun /S myServer\Myinstance /E /N Test

DTSRun /~Z0xB9A94C2AA29A29C9B....

I can run both of them in MS-DOS command line and success.

But if...

Hi Greg, Thank you very much.

I following your advice and got the command like

DTSRun /~Z0xB9A94C2AA29A29C9B....

Then I run it in MS-DOS command line on server, it works.

But when I...

Thanks.

On SQL server 2008, I run the dts package Test in command line as below and succeeded.

dtsrun /S myServer\Myinstance /E /N Test

Then I create a job and set...

Greg Charles (5/1/2009)

---

In SQL 2005 and 2008 Management Studio, you have to create the jobs in SQL Server Agent and add the DTSRUN statements to job steps.

If your...

Great! Thank you very much.

With your first suggestion:

In SQL 2005 and 2008 Management Studio, you have to create the jobs in SQL Server Agent and add the DTSRUN statements to...

Thanks, guys. I found the solution.

The solution is restart DTC service, not need to restart the engine.

But what I'm confused is: why Begin distributed transaction doesn't work with linked...