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
 SQL Server Administration (2000)
 DST and SQL server job

Author  Topic 

matt69
Starting Member

2 Posts

Posted - 2007-01-29 : 04:11:04
Hy everybody,

It's my first post on this forum because I'm just begin with SQL server.

I have change the 'sa' password on my SQL server and since I have a job which does work.
This SQL job call a DTS (DTSRun /~Z ...) and now it doesn't work anymore (error with 'sa') but I'm not able to find the new code I have to put after /~Z (I know it the encrypt code but I don't know how it's possible to find it.

Can someone help me, please ?
Thanks in advance,
Matt

matt69
Starting Member

2 Posts

Posted - 2007-01-29 : 05:46:50
After 4 days of research I have found a solution by using this link :
http://www.novicksoftware.com/TipsAndTricks/sql-dst-dstrun-dstrunui.htm

Have a nice day
Matt
Go to Top of Page
   

- Advertisement -