DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.
2003-09-09
12,177 reads
2003-09-04
1,763 reads
2003-09-02
2,136 reads
2003-08-11
2,099 reads
2003-07-01
2,442 reads
This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.
2003-06-24
4,068 reads
2003-06-17
3,064 reads
Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.
2003-05-27
2,490 reads
Have you ever faced the situation where you have needed to move a DTS package you needed to move a DTS package from one server to another, say from development to production? In this article by Kevin Feit, he shows you how to make a DTS package portable and save time.
2017-08-23 (first published: 2003-05-09)
33,982 reads
Ever tried to open 1 Gig ASCII file with Notepad? WordPad? Do you remember ASCII codes of Tab and Carriage Return? Enter Terminator; huge ASCII file viewer and BCP helper. Terminator reads top 10 (and more if asked) records of ASCII file of any size. It detects record terminators and calculates current cursor position (field offset) and length of selected area (field length). Best of all, it's free!
2003-01-29
109 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
Comments posted to this topic are about the item Multiple Display Productivity
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers