September 19, 2007 at 8:21 pm
http://msdn2.microsoft.com/en-us/library/aa545518.aspx
Is the above link incorrect? It references: Expand Data Transformation Services, and then click Local Packages... Using SQL Management Studio, I don't see DTS as an option. If I right-click the package, there's no scheduling option. All I have is...
New Folder...
Import Package...
Export Package...
Package Roles...
Run Package...
Delete...
Rename...
Refresh...
How do I schedule an SSIS package?
thanks
September 19, 2007 at 9:16 pm
Open SQL Server Management Studio and browse down to SQL Server Agent in the Object Explorer. Expand Sql Server agent, right click the Jobs folder, and select New Job. A New Job dialog box will appear; select the Steps page and click New. You can now set up one or more steps for your job, and here is where you can select an SSIS package to run. The rest of the steps should be fairly intuitive (setting the schedule, etc.).
hth
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
September 22, 2007 at 1:53 pm
I finally got this figured out! I think I was trying too many solutions and mixing them altogether. The following page from the MS KB got me straight.
http://support.microsoft.com/kb/918760
1) Create package, debug, if everything works...
2) In Designer, Right-Click your package to get Properties
3) Set Protection Level to: EncryptSensitiveWithPassword
4) Click PackagePassword and enter your desired password
5) Build the package. MENU> Build> Build
6) I used Windows Explorer to navigate to the Deployment folder. Double-Click the manifest file: YourPackage.SSISDeploymentManifest. That opens the installation wizard. Opt to store in the File System and run through the wizard. You will need your password.
7)In MSSM, connect to Integration Services. If necessary, refresh Stored Packages and you should see your package. Right-Click and run the package to make sure it works.
8) Connect to the Database Engine. That will get you to the SQL Server Agent. Expand to see Jobs. Right-Click Jobs for New Jobs.
9) The scheduling is easy to get through. However, in the Steps dialog, click Command Line to make sure your password is embedded in the Command Line. Mine looks like...
/DTS "\File System\TransferData\TransfertoSI" /SERVER XXXX /DECRYPT MyPassword /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
10) ...and that worked for me!
Good Luck!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply