I have a SQL server 2005 in server and 2000 locally. I want to transfer the records from the many table of many databases over night from server to local.
I want to create dtsx package saved in SQL server and run on the desired time. Advantage is i can stop any particular one when ever i want. The packages are executing by SQL Server Agent.
I am worried if it would slow down or cause any kind of problem/load on SQL server? Can i run many dtsx package at the same time? Also how can i delete the dtsx package that i already have created. I know it lives in msdb DB. how do i delete ? I am shaky to touch MSDB