http://www.sqlmag.com/authors/author/author/5080481/rss/5080481en-USFri, 25 May 2012 11:20:12 GMTFri, 25 May 2012 11:20:12 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks
By Brian Lawton
Put DTS through its paces by applying these common scripting patterns to package development, including invoking a package from within another package, accessing properties the Package Designer doesn’t directly expose, and more. ]]>Brian LawtonMon, 20 Dec 1999 11:22:42 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-trickshttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics
By Brian Lawton
Careful planning can make your data warehouse a success. Use these tips and tricks for planning a successful data-warehousing project.]]>Brian LawtonMon, 20 Dec 1999 11:06:28 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basicshttp://www.sqlmag.com/article/activex/dts-error-handling-revealed
By Brian Lawton
Find out how DTS deals with errors, and you’ll be on your way to building robust custom packages.]]>Brian LawtonMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/activex/dts-error-handling-revealedhttp://www.sqlmag.com/article/odbc/standalone-dts
By Brian Lawton
Discover how to leverage DTS’ power and flexibility in a non-SQL Server environment.]]>Brian LawtonSat, 23 Oct 1999 13:36:19 GMThttp://www.sqlmag.com/article/odbc/standalone-dtshttp://www.sqlmag.com/article/visual-basic-vb/creating-dts-custom-transformations
By Brian Lawton
Custom transformations in DTS offer powerful maintainability, functionality, and performance. Here’s an example showing how you can use a Visual C++ extension to build a custom transformation that generates XML documents from database tables.]]>Brian LawtonFri, 01 Oct 1999 00:00:00 GMThttp://www.sqlmag.com/article/visual-basic-vb/creating-dts-custom-transformationshttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks
By Brian Lawton
We explain how to use custom packages to leverage the DTS object model further by examining custom tasks, what they are, and why you might use them. We then detail how to build a custom task and how to use it both graphically and programmatically.]]>Brian LawtonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-taskshttp://www.sqlmag.com/article/dts/dts-development-handbook-part-2
By Brian Lawton
The DTS masters guide you through common development problems, including timestamp data types.]]>Brian LawtonWed, 01 Sep 1999 00:00:00 GMThttp://www.sqlmag.com/article/dts/dts-development-handbook-part-2http://www.sqlmag.com/article/migration/migrating-from-sql-server-6-5-to-7-0
By Brian Lawton
The SQL Server Magazine migration alerts you to compatibility conflicts you’ll encounter in migrating from SQL Sever 6.5 to 7.0]]>Brian LawtonSun, 01 Aug 1999 00:00:00 GMThttp://www.sqlmag.com/article/migration/migrating-from-sql-server-6-5-to-7-0http://www.sqlmag.com/article/odbc/the-dts-development-guide
By Brian Lawton
Do you have a DTS question about error handling, package execution, extensibility, or data-driven queries? You’re not alone. Let our experts help!]]>Brian LawtonThu, 01 Jul 1999 00:00:00 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guidehttp://www.sqlmag.com/article/dts/pump-up-the-power-of-dts
By Brian Lawton
Leverage the power of Data Transformation Services (DTS) by using its native COM interfaces.]]>Brian LawtonTue, 01 Jun 1999 00:00:00 GMThttp://www.sqlmag.com/article/dts/pump-up-the-power-of-dtshttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts
By Brian Lawton
Data Transformation Services (DTS) is a SQL Server 7.0 utility service that provides import, export, and data manipulation capabilities between OLE DB, ODBC, and ASCII data stores.]]>Brian LawtonSat, 01 May 1999 00:00:00 GMThttp://www.sqlmag.com/article/activex/unleash-the-power-of-dtshttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse
By Brian Lawton
Learn how DTS attacks two troublesome warehousing tasks, data acquisition and data transformation, and how easily you can use the DTS Package Designer to script a package.]]>Brian LawtonThu, 01 Apr 1999 00:00:00 GMThttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehousehttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services
By Brian Lawton
DTS provides a fast, robust, extensible architecture for moving data out of traditional relational databases and into Microsoft’s new SQL Server OLAP Services.]]>Brian LawtonMon, 01 Mar 1999 00:00:00 GMThttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services