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:2602 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
