You have to deploy the package to a SQL server. Then you can schedule, execute and otherwise manage the packages on the server.
There is a deployment packager in VS that will wrap up the project for you: http://msdn2.microsoft.com/en-US/library/ms137900.aspx ___________________________________ Dave Konopka Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] Phone: (215) 898-2685 -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 10:14 PM To: SQL Subject: How do you run an SSIS package without using Visual Studio? I've been using Microsoft Visual Studio to build SSIS packages, and gradually I'm coming to understand how that all works. I don't know if any of my packages are very sophisticated but they do what I want, which is publish databases to production sites, or copy production databases down to dev servers. But it doesn't seem like it's the correct way to be using SSIS to be opening Visual Studio, loading in all the SSIS package files, and then running debug mode. How do you run SSIS packages without using Visual Studio? Can you run them from Server2005 Management Studio? (if so, how?) Can they be run as scheduled tasks like I used to in the old SQLServer2000 with DTS? That way I can do routine jobs overnight while I'm fast asleep. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2603 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
