July 13, 2007 at 11:46 am
I have used migrated wizard from SQL 2005 to migrate DTS from 2000. Now, How should I schedule this DTS on SQL 2005?
I can open this in SSIS CAN I schdeule from there if yes HOW?
Nita
July 13, 2007 at 1:19 pm
If it's migrated the DTS packages to SSIS packages, you can schedule these to be run by a SQL Server job.
Here's a nice overview to upgrading DTS to SSIS: http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp
-- http://dbachman.blogspot.com
July 16, 2007 at 2:01 am
SSIS packages can be scheduled as a job step in SQL Agent you have a option for that there.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply