SSIS Deploy Error - Integration Services

Question

Hello
I made a package in SSIS that convert from a DBF file to the SQL server. Well in visual studio it works perfectly, but after i deployed my project in sql server it doesn't work. See the images:

Someone know what is wrong?

tks for the attention

Answer 1

Hello,

SSDT / Visual Studio is a 32 bit application using 32 bit data provider and if the package runs in SSDT, but not as job, then I guess it's a 32/64 bit issue.
Have you install the data provider only as 32 bit or also as 64 bit provider?
If not force the job to run as 32 bit process, see SQL Server Agent Jobs for Packages => 32-bit runtime

Answer 2

I made a package in SSIS that convert from a DBF file

OLE DB Source - Could you please clarify what the source is? And what driver/provider is in use.

Also, I see that the package is using Microsoft Jet OLEDB Provider.
It was deprecated in favor of Microsoft ACE OLEDB Provider a decade or so ago.

Answer 3

Hi @Vitor Mendes ,

You can find the cause of the error first, and then solve the problem according to the detailed and error message:

1.Identify the problem
2.Login to the sql server instance
3.Navigate to the Integration Service directory
4.Right click on your SSISDB catalog and select All Reports -> Standard Reports -> All Execution
5.For your folder, click "All messages to perform failed tasks"
6.Here you will see your error

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.