Looping in SQL Server 2000 DTS

Home » Blog » SQL Server » Looping in SQL Server 2000 DTS

Looping in SQL Server 2000 DTS

February 20th, 2006 // 5:24 pm @ Amar

While working on an assignment involving some complex data loading using DTS Packages, I came across the need to loop through all the files present in a directory and perform a set of tasks for each file and also handle errors on a per file basis.


I found this excellent article on sqldts.com which outlines a very simple yet effective way of condition based looping through dts tasks. Check it out here.


Category : SQL Server

Leave a Reply

Latest Posts

Testimonials

"Amar clearly has a thorough knowledge of Sharepoint, this knowledge, coupled with his professionalism and dedication made him a tremendous asset to the project. He was the key contributor to the later stages of the project delivery effort (the really difficult bit, long hours and hard work that puts huge demands on people), and I can state categorically that without his focussed dedication and hard work we would not have been able to meet the timescales imposed upon the project."

Tim Ellis , Sharepoint Project Manager , Royal Bank of Scotland

Subscribe Now