Thank you for the response. I know that you can schedule a package at creation, but how can I manually start one? I have it saved in the system as well as a .dts package. I just need to be able to kick it off at any time.
you can put this code in a stored procedure to have it run on an automated process...<BR><BR>Exec master..xp_cmdshell 'dtsrun /s SERVERNAME /e /n DTS_NAME'<BR><BR>or you can just right click on it and select execute... if it is a manual run...<BR><BR>sponge