Just trying to find out why the dts package is not running on the production server:
The package runs fine when I run the dtsrun.exe as below [using windows authentication]
"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe" /S "servername_testServer" /E /N "PKGName" /L "C:\Working\Test\Log.txt" /W "-1"
But when I run the same command line on server Production server with user name and password it gives an error
"c:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe" /S "Prod_Server" /U XXXXXX /P XXXXXX /N "PKGName" /L "C:\Working\Test\Log.txt" /W "-1"
THE ERROR IS:
Step Error Source: OraOLEDB Step Error Description:ORA-01017: invalid username/password; logon denied Step Error code: 80004005 Step Error Help File: Step Error Help Context ID:0
I think it is going to do with the permissions. I tried logging to the SQL server with the user and pwd used in the command line and I can login with that credentials.
In the package I am running a select query on oracle and putting it in the excel file.
