CODEWITHSUNDEEP
sql-servervisual-studiossis
zening.chen
zening.chen

Reputation: 127

How could I generate SSIS package

The situation is that I have two DB servers with SQL Server, I need to transfer the data from Server A to Server B automatically every night.

So according to sql server data transfer from one server to another server, I created an SSIS project. And it manage to transfer data with good performance. But the question is, how do I export the project into SSIS package and run it every night?

Upvotes: 0

Views: 262

Answers (2)

holder
holder

Reputation: 585

You can either store the package as in the file system or in the SSIS catalog. I would say that storing it in the SSIS catalog is the best way to go here.

Before you deploy your package to the SSIS catalog you need to make sure that integration services is installed on your server as well as that the SSIS catalog has been created.

How to create ssis catalog

If all above is OK then proceed and deploy your package and create an agent job. Please notice that you need to set up permissions for the sql agent account so it can access your databases.

Upvotes: 1

Alex Rajan Samuel
Alex Rajan Samuel

Reputation: 144

I assume you are still running it from Visual Studio. To schedule it daily you will need to do the below,

  1. Deploy your project to a SQL Server
  2. Create an Agent job and schedule it.

Found a good article, sharing that with you here. https://www.mssqltips.com/sqlservertutorial/9069/deploy-and-schedule-an-sql-server-integration-services-ssis-package-step-by-step/

Upvotes: 2

Related Questions