• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

SSIS Sechdule Packages to run

Hello Experts Exchange
I have developed a SSIS in Visual Studio it has 12 packages, all pointing to the same Excel spread sheet as the source and all pointing to the same table as the destination.

What are the steps I need to complete to get my development to run at 11pm so that all packages run at the same time?

Regards

SQLSearcher
0
SQLSearcher
Asked:
SQLSearcher
1 Solution
 
colly92002Commented:
In theory you could create a master package that runs all 12 packages concurrently, however using a single Excel file as a source is likely going to cause file lock issues.  Therefore if this is essential the first step of your "master" package should read the Excel file into a DB table, and your 12 packages should use this as the source rather than the Excel file.


If you just want to know how to deply/schedule then the simple way to deploy is to create a new job in SQL Server Agent and configure it as a SQL Server Integration Services Package. For the Package source select File system and configure where the file should be stored. Copying the .dtsx file to that location.

For more information see below:
Written tutorials:
http://www.mssqltips.com/sqlservertutorial/213/deploying-ssis-packages/
http://www.mssqltips.com/sqlservertutorial/220/scheduling-ssis-packages-with-sql-server-agent/

Video tutorials:
https://www.youtube.com/watch?v=zdxOxHM5Ijw
https://www.youtube.com/watch?v=JbC_ronWGXo
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now