1. password problem with DTS package
In creating a DTS package, we use either DTS wizard or the Design
Package visual tool.
Example of a simple package is:
1. Deleting from existing table in SQL7 database,
2. Upon success of step 1, transfer the data from Text file to the empty
table.
The connection is done through Microsoft OLE DB provider for SQL server,
using SQL authentication with a valid username and corresponding
password.
The Problem is; whenever the password of that user is changed, we get
errors (invalid log in for the said user) once you would like to execute
the package, and also when we try to open the destination tab and / or
the transformation tabs.
Is there any way to overcome this problem?
3. DTS VB and a password problem
5. DTS password problem no one seems able to solve
6. How to SendKeys in Delphi 1.0
7. SQL 7.0 ODBC DTS password problem???
8. Processing Some by Not All records
9. DTS problem SQL7->DTS->Excel->DTS->SQL7
10. How to change automatically DTS Password
11. DTS Passwords
12. Forgot DTS Package Owner Password
13. dts - forgot owner password