question

Gehima2016 avatar image
Gehima2016 asked

ActiveX Script errors in SSIS package

Hi everyone, I have a SSIS package that ia ran manually everything month end for reporting. It ran successfully in last month but this month it is giving an error message below; "Error: 0xC00291B1 at Populate And Copy Temp DB, ActiveX Script Task: User script threw an exception: "Error Code: 0 Error Source= ADODB.Connection Error Description: Provider cannot be found. It may not be properly installed " Please, can someone help to figure out how this error can be resolved. Thanks
ssisscriptpackagein
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
sounds like something changed. Package moved to another server? Package modified? SSIS server version upgrade? SQL Patch Applied? Driver uninstalled? OS Patching? DSN change?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.