Dears, Iam loading the data from Oracle db to Sqlserver db in the ssis package. In the package itself....the following error is coming..Could you please any one help on this OnProgress,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,0,0x,Validating OnProgress,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,50,0x,Validating OnError,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,-1071611876,0x,SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Safe_Oracle_Conn" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. OnError,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,-1073450985,0x,component "SFE Prod Source - SFE_PROD_LOG 1" (25) failed validation and returned error code 0xC020801C. OnProgress,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,100,0x,Validating OnError,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,-1073450996,0x,One or more component failed validation. OnError,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:24:32,23/03/2011 14:24:32,-1073594105,0x,There were errors during task validation. OnInformation,BGC-BE-5CC34E7E,BELGACOM\id821593,Dbsfe_SFE_Load,{1219070B-3B49-4C7C-935F-1FC19862E4FF},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:26:21,23/03/2011 14:26:21,1073832000,0x,The package is attempting to configure from SQL Server using the configuration string ""SAFE_SQLDB";"[SFE_Schema].[SSIS_Configurations]";"Safe-DataImport_Daily";". OnInformation,BGC-BE-5CC34E7E,BELGACOM\id821593,Import Product Table,{92345BBA-11DB-48A4-8BB5-890D5B92375B},{35E7399A-B4EA-4E09-A557-0C8E09651349},23/03/2011 14:26:21,23/03/2011 14:26:21,1074016266,0x,Validation phase is beginning.Thanks & Regards, Anil

The problem is related to the connection manager Safe_Oracle_Conn. Apparently it failed the validation. Are you sure all the objects that you reference in OLE DB Sources/Destinations, Execute SQL Tasks exist? Do you have the necessary permissions to connect to Oracle? Is that server up and running?

Hi Verbeeck, Thanks for your answer. Iam sure about that have necessary permissions to connect Oracle db and server is up and running. Thanks & Regards, Anil

Is the connection manager configured through an expression or a configuration? Or did you configure it manually? If you go to the connection manager and click "Test connection", does it succeed? Where do you use the connection for?