Though its on old date.... would like to share as this is appropriate forum: http://www.microsoft.com/technet/tr...chnet/itcommunity/chats/trans/SQL/sql0227.asp KBA -http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 - How to Run a DTS Package as a Scheduled Job. Link -http://vyaskn.tripod.com/sql_server_dts_best_practices.htm - DTS Best practices. Technet -http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/next/SQLSBDTS.asp - Practical Guide to SQL Server Yukon Beta 1 DTS. Above all keep in touch withhttp://www.sqldts.com for DTS goodies. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Thanx Satya<br /><br /><img src='/community/emoticons/emotion-1.gif' alt='' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
I think the first link doesnt work. can you update accordingly? Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
I believe 1st link was archived, you might find about relevant information from Technet site and 4th link also have been changed, the alternatives arehttp://msdn2.microsoft.com/en-us/library/ms143706.aspx &http://msdn2.microsoft.com/en-us/library/ms345141.aspx. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.