Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 modify dts package

Author  Topic 

sanand
Starting Member

1 Post

Posted - 2010-07-27 : 17:17:25
I have ms ssms2005 and 2008.
One of my sql job is running a DTS package that is failing due to
protected XML node
"DTS: Password with error... key not valid for use in
specified state..."

I don't have access to sql 2000. I am new and learning ssis.
Please help in resolving this error. I found some other articles on this but cannot figure these out. Please help.


TIA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-28 : 11:11:58
how are you executing the dts? exact command.

did u download SQL Server 2000 DTS Designer Components?

Saw this article? http://msdn.microsoft.com/en-us/library/bb500440.aspx

Go to Top of Page
   

- Advertisement -