December 15, 2008 at 1:51 pm
ERROR : 1
TITLE: Package Installation Wizard
------------------------------
Could not save the package "C:\Vinod\WeeklyReport.dtsx" to SQL Server "(local)".
------------------------------
ADDITIONAL INFORMATION:
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
BUTTONS:
OK
------------------------------
SOLUTION :
Make sure the complete server name is provided in the wizard (i.e SERVERNAME\INSTANCENAME) against the target SQL server name.
ERROR : 2
TITLE: Package Installation Wizard
------------------------------
Could not save the package "C:\Vinod\WeeklyReport.dtsx" to SQL Server "MYSERVER\MYINSTANCE".
------------------------------
ADDITIONAL INFORMATION:
No description found
------------------------------
BUTTONS:
OK
------------------------------
SOLUTION :
Try executing the below. (might be because of MSXML registration is corrupted)
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply