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

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

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.