Data Migration - Quickly Inserting New Data

Migrating data from one SQL Server database to another can be challenging. Steve Jones has a new series that looks at various techniques that he's used to move data into a new database. This one looks at how you can quickly take Excel based data and insert it into a new database without using DTS.

You are a DTS programmer who wishes to...

Using DTS to Generate and Email Excel Reports

Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.

You are creating a DTS package in SQL...

Restore a DTS package from a DTS Store

Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.

You are a DTS programmer who is trying...

You are a DTS programmer that is trying...

A DTS Data Store

Looks at some basic concepts of DTS and a couple ideas for putting it to work.

What is the difference between user and owner...