SQLServerCentral Article

Automate DTS Logging

  • Article

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.

5 (1)


12,143 reads

Technical Article

SQL Server DTS Best Practices

  • Article

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.


4,068 reads

SQLServerCentral Article

Portable DTS Packages

  • Article

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.

4.67 (3)

2017-08-23 (first published: )

33,960 reads

SQLServerCentral Article

Freeware: Terminator Opens Gigabyte Files Easily

  • Article

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!


107 reads


Being a script magpie


Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools


The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Storytelling with Data – Enertia User Conference 2022


Thank you to everyone who attended my session at the Enertia User Conference in...

Read the latest Blogs


Missing weekend data to Zero

By LearnSQL

Hi All, I have a requirement that if there is no weekend data then...

Alight Motion is safe for users?

By Zara Alight1

Description: Alight Motion edits application that allows you to edit videos in the Android smartphone....

How to calculate orders historically, during month

By Zond Sita

Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers