April 29, 2014 at 7:58 am
I have an integration server where I can connect to in SSMS without any problem. But when I try to add an existing package on the same integration server to a solution in VS 2008 I get a login time out. Error follows. Does anyone know what the issue may be?
TITLE: Add Copy of Existing Package
------------------------------
An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed.
------------------------------
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed.
------------------------------
BUTTONS:
OK
------------------------------
April 29, 2014 at 8:31 am
Ok, I found a way to access the server. Somehow I needed to add /UAT to the end of the servername when selecting the server to look for the package on.
Now Im getting the following error when I have selected the ssis pkg to add to the solution:
TITLE: Microsoft Visual Studio
------------------------------
Failed to save package file "C:\Users\dan.daughtery\Desktop\HSC_PreCertRule_Upload\HSC_PreCertRule_Upload\HSC_PreCertRule_Upload.dtsx" with error 0xC0010026 "The task has failed to load. The contact information for this task is "%1".".
------------------------------
ADDITIONAL INFORMATION:
Failed to save package file "C:\Users\dan.daughtery\Desktop\HSC_PreCertRule_Upload\HSC_PreCertRule_Upload\HSC_PreCertRule_Upload.dtsx" with error 0xC0010026 "The task has failed to load. The contact information for this task is "%1".".
------------------------------
BUTTONS:
OK
------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply