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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy