How to execute SSIS packages on another SQL server's hardware?
0
votes
1
answer
933
views
I have 20 ssis packages deployed on SQLSvr1 in the SSIS catalog.
They are invoked via the SQL agent jobs on this server.
Suppose I re-create these agent jobs on another SQL Server (SQLSvr2), then will they on the hardware resources of SQLSvr2 (CPU, memory)?
Asked by variable
(3590 rep)
May 10, 2022, 03:15 AM
Last activity: Jul 5, 2025, 11:09 PM
Last activity: Jul 5, 2025, 11:09 PM