latest Post

SSIS Script Component Error - "Failed the post execute phase and returned error code 0xC0010009. COM Exception."

Yesterday I was working on an SSIS package which contained multiple "Script Components" which was doing some basic event logic of taking an input parameter and storing the output into a SQL database using the SQLConnection method.

The transform ran perfectly inside Visual Studio and SQL Server Data Tools however, the package had to be ran nightly so it was deployed to a server and scheduled to run using SQL Server Agent. Once it was deployed to the server and manually ran  I found the transform failed with the following error message.

"Failed the post execute phase and returned error code 0xC0010009. COM Exception."

I tried all most everything to fix the issue, rebuilding and deploying and commenting out each line until it worked however, I got to the point where everything was commented out and it still wouldn't run on the server. I had a look in the various community forums but there wasn't many users who were reporting similar issues.

Finally I decided to delete the script component all together and manually re-add the code back in. This time when I deployed to the server the package ran successfully

Now all I can think of is I had copied the script component and modified it slightly as I wanted to do something similar to my first script component, so I wonder if it didn't like the copy and paste?.  Although if that was the case I would of expected it not to run in BIDS either. 

Unfortunately I don't have an answer to why it didn't run in SQL Server Agent the first time but hopefully this might help someone out so don't spend ages looking into this just add another script component, re-add the code and move on.
Recommended Posts × +

5 comments:

  1. You helped me. You reminded me that when you copy and paste a script component, the pasted one gets the same GUID as the copied one, and this messes with SSIS' head. The solution is to cut the pasted script component, then paste it back in again and reconnect precedence constraints. You'll get a red x on it, just click Edit Script, save it in the editor, then close the editor, click ok on the script component. The red x will go away, along with your erros. Thank you.

    ReplyDelete
  2. I really want to thank Dr Emu for saving my marriage. My wife really treated me badly and left home for almost 3 month this got me sick and confused. Then I told my friend about how my wife has changed towards me. Then she told me to contact Dr Emu that he will help me bring back my wife and change her back to a good woman. I never believed in all this but I gave it a try. Dr Emu casted a spell of return of love on her, and my wife came back home for forgiveness and today we are happy again. If you are going through any relationship stress or you want back your Ex or Divorce husband you can contact his whatsapp +2347012841542 or email emutemple@gmail.com website: Https://emutemple.wordpress.com/ Https://web.facebook.com/Emu-Temple-104891335203341

    ReplyDelete
  3. SSIS script component error is presenting the failed post execute phase and returned error codes with the exceptions. The transform ran the perfection inside the visual nursing assignment help studios and SQL server’s data tool with the package to run at night with the error kind of message.

    ReplyDelete
  4. All their diligent effort, dependability and adaptability guarantee that both the gatherings partake in http://toweringmedia.com/ a superb connection between them.

    ReplyDelete
  5. It’s cool. People often think of stuff like this one scary and weird. But to me it’s so cool and amazing. I really am into such things and the https://suerte247.postach.io/post/que-se-debe-tomar-en-cuenta-en-un-casino-online-en-el-peru casino service also discusses about such stuff and its charm quite often as not many people are interested in such things.

    ReplyDelete