question

ImranBuhary-0364 avatar image
0 Votes"
ImranBuhary-0364 asked Monalv-msft edited

Error running a Stored SSIS Process created by 64 bit import wizard

Hi All,

I am using SSMS (SQL Server 2019 Developer Edition - Latest Build)
Windows 10 & Office 2010 (64 Bit)

I have an existing Table (with historic data) in one of my server instances and I frequently need to add data to this table.
My new data is in Excel Files with same Columns structure as per my existing table in SQL.
So I used the 64 bit import wizard to add data into my existing Table in SSMS.
During the process I saved the wizard as SSIS Package to run again, as I had to manually edit over 50 columns for data types, and I don't want to repeat it every time I import.

When I try to run the wizard again using the SSIS Stored Package it throws back errors
76574-image.png


sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ImranBuhary-0364 avatar image
0 Votes"
ImranBuhary-0364 answered Monalv-msft commented

@Monalv-msft
I am running the SSIS as a Stored Package via Integration Services inside of SSMS
I don't have the screen you have shown me, my run package dialog is different and doesn't have the Configuration Properties same as per your screenshot.
I am attaching my run package dialog screenshot for your reference.
77326-image.png



image.png (167.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ImranBuhary-0364 ,

1.Please run the ssis packages stored in MSDB in SQL Agent job. We can uncheck Use 32 bit runtime in Job Step Properties.
77694-jobstepproperties.png
77763-jobstepproperties1.png

2.We can also deploy the ssis packages to SSISDB Catalog.
And then uncheck 32-bit runtime in the Advanced page while executing package.
77772-executepackageincatalog.png

Best regards,
Mona

0 Votes 0 ·
Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @ImranBuhary-0364 ,

May I know if you download Microsoft Access Database Engine provider?

Please refer to the following links:
1.Microsoft Access Database Engine 2010 Redistributable
2.Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

Best regards,
Mona


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.




· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Monalv-msft
I did have a look at the these links before posting the question here.
They didn't help me resolve the issue.
Is there anyway we can trigger the SSIS to run in 64 bit ?

0 Votes 0 ·

Hi @ImranBuhary-0364 ,

Please set Run64BitRuntime as True in the properties of Integration Services Project.
76636-run64bitruntime.png

Best regards,
Mona


0 Votes 0 ·
run64bitruntime.png (20.8 KiB)
ImranBuhary-0364 avatar image
0 Votes"
ImranBuhary-0364 answered

@Monalv-msft
Thank you for your feedback

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.