CODEWITHSUNDEEP
sql-servert-sqlssiscopypackage
SQLPadawan
SQLPadawan

Reputation: 31

Add copy of Existing Package using File System

I'm copying packages from one server to another. When the package is of the type Integration Services Package it's easy to move but when it is T-SQL, I don't know how to move it.

I've moved all packages of the type Integration Services Package now, I'm left with the T-SQL type.

I'm not using a code based method, I'm using the SSIS interface to move the packages over.

I have 15 jobs that use T-SQL within them and no packages. I want to move them all over.

Upvotes: 1

Views: 57

Answers (1)

Hadi
Hadi

Reputation: 37313

Transfer Job Task

You can use Transfer Job Task to copy SQL agent Job from a server to another one

The Transfer Jobs task transfers one or more SQL Server Agent jobs between instances of SQL Server.

The Transfer Jobs task can be configured to transfer all jobs, or only specified jobs. You can also indicate whether the transferred jobs are enabled at the destination.

There are plenty of articles found online, as example:

Generate Scripts via SSMS

You can simply generate SQL scripts and execute them on the other server:

Upvotes: 1

Related Questions