I was doing ETL to get data from staging area to Data warehouse and while runnig the data flow task it's shown the error : The AcquireConnection method call to the connection manager [DatabseName] failed with error code 0xC0202009.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHOJ860OEwLtfhoyW_srwHXTEE8GUeu_LhqnBrdRk1UM8Z5ujEpLRsWr0qH_mtdvWq3luYNC9hh_yxwyHXTW0-7-Gpq2Kr6EffUFUn-NiSWVHr5eYpoBWNP9HLDEgdjLyxCdpB1nMxQjpF/s400/Step1_Error+you+found.PNG) |
Fig 1: Error code 0xC0202009 |
Interestingly, the same SSIS package is running without error in Test and Production. After a little bit of interenet search as found, a few people mentioned about changing the Debug options from 64bit to 32Bit, It means you set Run64BitRuntime=False, as like below:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRatMmSuVmg4hGvQZi867jAH-VQEkknWHvnikXNOQGDzA-QdbttwLT55soVg5NPLONt8XCN6CMzPWVJhGgC2b67j3LsKrSV-6E8W-aGdj0Y63jBB1edV2yFLJc4fDPDmSDIQ_-9hFdiBC2/s400/screenshot+debug+32.PNG) |
Fig 2: Change 64bitRuntime from debug options |
However, it did not work for me, then tried a attribute called 'Delay validation'. You need to click the Data Flow Task's property and change the 'Delay Validation' from TRUE to FALSE.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1HxKIPGaDhqIjg1TsSBFC8m37agssiYrGfBGDF_J_fqystXOBZYRjzxllGazLVvjB-Oa_6DXtwydkVKa648E0VClmX9Ox1hqRMCLzSGv_J6bKgSimvWUgk4owSCKNGRkvcHEc3VNQdr8W/s400/Cahnge_delay_validation.PNG) |
Fig 3: Change Delay Validation Property |
After changing the property you should able to run the package without error,
No comments:
Post a Comment