Interview Question in SQL Server Integration Services
Interview Question :: How do you execute an SSIS package from SQL 2005 Management Studio
We're making the transition from 2000 to 2005 and we're trying to figure out how best to develop SSIS packages. We're used to DTS where you can design and execute from the old enterprise manager. But with 2005, we can't figure out how to design or execute from Management Studio, other than sceduling a SQL Server Agent job. Creating and executing from Visual Studio is a pain and doesn't really suit our needs. We need to be able to do it from Management Sudio.
Loading ...