Database Transformation Services (DTS) in SQL Server 200 was a breakthrough tool, really paving the way for a low-cost, easy to use, ETL tool. However, it was not a true robust programming environment and contains quite a few quirks that are apparent as you get into more detailed packages. New author Gus Carnu addresses one of those issues with a look at the ExecutePackage task.
2005-03-24
10,395 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Hi, Azure SQL DB doesn't support CLR, if we have an application with CLR...
We have a Setup where replication and AG is configured as below. Servers:Node1,Node2 ==>Node1...
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers