I've tried with this for over 48 hours and no luck. I then create a simple package, one FTP task to download text files. I deployed the package using the option "SQL Server Deployment". I see the package in SSIS but when I try to run from command line with the command
dtexec /ser svrprod05 /sq Package
I get the 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 passing a username and password of the following
1. Local Administrator
2. Domain Administrator
3. Ent Administrator
4. SQL Server SA
My original objective is mentioned here. I don't know what else to try.