2012-01-25 (first published: 2011-12-15)
1,166 reads
DTS
2012-02-07 (first published: 2011-12-15)
1,014 reads
2010-02-15
10,522 reads
Migrating DTS Packages to Integration Services
In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
2008-11-07
5,110 reads
Yet another way to include portability on DTS packages
An proposal about using simple server name resolution and INI files to make a DTS package portable.
2008-04-10
4,189 reads
Migrating SQL Server 2000 DTS Packages Across Environments
Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.
2007-10-09
6,151 reads
Maintain DTS packages in SQL Server 2005
Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.
2007-07-05
4,915 reads
Conditional Flow in DTS
While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.
2008-03-19 (first published: 2007-06-07)
10,063 reads
Five Realtime DTS Examples
SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server
2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.
2008-02-08 (first published: 2007-03-22)
16,962 reads
The Dynamic Process of Loading Data
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
2007-12-31 (first published: 2007-01-23)
9,912 reads
Blogs
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least,...
SQLSaturday Orlando Notes – Large Printed Schedules
By Andy Warren
One of the things we’ve done most years in Orlando is to print poster...
Upgrading Windows 10 Home to Pro
By Steve Jones
I use Hyper-V and a few other things that require Windows 10 Pro. When...
Forums
RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted
what are their differences among EventClass of RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted under SQL Profiler...
Deploying Data and Schema Together with SQL Compare or SQL Change Automation
Comments posted to this topic are about the item Deploying Data and Schema Together...
SQL Server Name Convention and T-SQL Programming Style
Comments posted to this topic are about the item SQL Server Name Convention and...
Ask SSC