question

MarkCovian-9126 avatar image
0 Votes"
MarkCovian-9126 asked MarkCovian-9126 answered

SQL 2019 - x32 - SSIS package runs from Catalog (x32), but fails on Agent x32 - Help

Help any suggestions are appreciated

SQL 2019

Running SSIS package via the Catalog as x32 runs success
Running SSIS package via SSA with x32 checked, package fails

Job Step
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Test',
@step_id=1,
@cmdexec_success_code=0,
@on_success_action=1,
@on_success_step_id=0,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0, @subsystem=N'SSIS',
@command=N'/ISSERVER "\"\SSISDB\HTDM\HTDM\HT Daily - Load ClarityTokenX.dtsx\""
/SERVER "\"DisneyLand\"" /X86 /Par "\"$ServerOption::LOGGING_LEVEL(Int16)\"";1
/Par "\"$ServerOption::SYNCHRONIZED(Boolean)\"";True /CALLERINFO SQLAGENT /REPORTING E',
@database_name=N'master',
@flags=0

sql-server-generalsql-server-integration-services
· 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.

Running SSIS package via SSA with x32 checked, package fails

And with which error message does it faiL, we can not guess that?

1 Vote 1 ·
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @MarkCovian-9126,

Is there any error message for us to do further analysis?

In addition, for this type issue, you may refer this blog to do self troubleshooting.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.
Hot issues October



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.

MarkCovian-9126 avatar image
0 Votes"
MarkCovian-9126 answered MarkCovian-9126 edited

Thank you for the guidance,



Execution SSA Job with x32 'ON'


140903-image.png


Execution from Catalog with x32 'ON'

140845-image.png




image.png (67.1 KiB)
image.png (52.8 KiB)
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.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @MarkCovian-9126,

Please check if SQL Agent property 'Use 32 bit runtime' checked.

On the left side in the Menu click on "Steps". -> "New..." for a new step as "type" choose "SQL Server Integration Services Package". There you can select your SSIS-Catalog and your package. And another tab is the "configuration". Below this tab there are three other tabs. Click on "Advanced". There you find the checkbox to run the package in "32-bit runtime".

Also you need to make sure that the SQL Server Agent Services service account or your Proxy account has the permission to access your database.

create-a-sql-server-agent-proxy

If you run the job manually, will it thrown the error?

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.
Hot issues October




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.

MarkCovian-9126 avatar image
0 Votes"
MarkCovian-9126 answered

Good Morning Zoehui-MSFT,

Thank you for the reply,

I've tried many things including your guidance and simply cannot get the SSA Job x32 Steps to execute properly. However the SSIS packages execute from SSIS Cat.

The Host\SQL configuration is pretty much out of the box.

Today is another day :)

Thanks again and be well...

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.