a couple weeks late, but this is a great resource http://www.sqldts.com/

We had this problem when we upgraded our dev server to sp 3a and the client machines with earlier versions could no longer debug. We upgraded our client machine to...

We have used Enterprise Architect from Sparx Systems http://www.sparxsystems.com.au/ with good results. Check it out.

Another option is to set up a SQL Agent job (schedule it to run or not at all) then call the stored proc sp_Start_Job. I am using that to allow...

I should have mentioned this catch, you need to set up a sql server agent job that executes the dts package. I also created a sql task in the dtspackage...

I have used exec sp_start_job @Job_Name ='dtspackagename', it works.