Recover Those Packages!
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,870 reads
DTS
Save Your Packages Locally
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,960 reads
Optimizing DTS Data Loads
In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,492 reads
Multiple paths in DTS Workflow
This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.
2001-06-28
990 reads
Professional SQL Server 2000 DTS Review
Steve Jones reviews the premier DTS reference for SQL Server 2000.
2001-06-06
12,581 reads
Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
2001-06-01
8,419 reads
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,359 reads
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,266 reads
Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
2001-05-16
14,842 reads
DTS Basics
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
2001-05-15
11,290 reads
Blogs
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers