DTS

SQLServerCentral Article

Data Migration - Quickly Inserting New Data

  • Article

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.

2004-07-08

10,530 reads

SQLServerCentral Article

Using DTS to Generate and Email Excel Reports

  • Article

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.

5 (7)

2005-09-23 (first published: )

40,145 reads

Blogs

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Storytelling with Data – Enertia User Conference 2022

By

Thank you to everyone who attended my session at the Enertia User Conference in...

Read the latest Blogs

Forums

How to calculate orders historically, during month

By Zond Sita

Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...

How Important is Software?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important is Software?

How and where did you learn SQL from?

By VladBar

Could you give me advice on where I should learn SQL and Python to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers