You can open it, but the validation of the package complained. Could be for example when it validates, it does not get connected to the OLEDB source, but when you run it takes the conn string from the config file no problem.Arthur My Blog

When opening my SSIS package, got Error message like below. But i can execute the package. I am using tmplate for the SSIS package. why i am getting this error? Please tell me the reason Error 4 Error loading Tandem_System_ Stats.dtsx: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ". J:\VssWorkingFolder\Integartion Services\TandemSystemStats\ TandemSystemStats\Tandem_System_ Stats.dtsx 1 1

You can open it, but the validation of the package complained. Could be for example when it validates, it does not get connected to the OLEDB source, but when you run it takes the conn string from the config file no problem.Arthur My Blog

Arthur is right, you can open the package only the Validation phase is failing what you need to do is Set the DelayValidation Property at the package level to True, its set to FALSE as of now by the looks of it as a result SSIS tries to validate the connections THough this will resolve your basic problem but you still need to ensure that connections are set correctly at runtime via the config files so that you can connect once the package starts runningAbhinav

Arthur is right, you can open the package only the Validation phase is failing what you need to do is Set the DelayValidation Property at the package level to True, its set to FALSE as of now by the looks of it as a result SSIS tries to validate the connections THough this will resolve your basic problem but you still need to ensure that connections are set correctly at runtime via the config files so that you can connect once the package starts runningAbhinav

1- Check your connections in the "Connection Managers" and related properties, 2- Check the package configuration, try to set the right connection or disable the config In the menu --> SSIS --> Package Configuration... --> uncheck the "Enable Package configuration" Sincerely SH -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).