I tried with this for more than 48 hours and no luck. Then I create a simple package, one FTP task for uploading text files. I deployed the package using the option "Deploy SQL Server". I see a package in SSIS, but when I try to run from the command line using the command
dtexec /ser svrprod05 /sq Package
I get an error
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:56:39 PM
Could not load package "Package" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80
004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10:56:39 PM
Finished: 10:56:55 PM
Elapsed: 15.625 seconds
I tried to pass the username and password of the following
1. Local Administrator
2. Domain Administrator
3. Ent Administrator
4. SQL Server SA
My original purpose is mentioned here . I do not know what else to try.
source
share