DTS

SQLServerCentral Article

Case Study: Importing New Data Without Emptying Existing Tables

  • Article

The challenge for Robert Marda was to devise a way to keep the data available at all times while importing the new data, detect if a full or daily update was received and run appropriate data pumps, put in sufficient fail safes to ensure bad data would not get imported, and to make the process automatic including notification to pagers upon failure. Robert shows you how he did it here.

2003-01-09

8,197 reads

SQLServerCentral Article

Data Import Functionality Using SQL Server

  • Article

Building robust functionality with maximum re-use of existing infrastructure and investment with little or no development is the goal for many businesses. This article is about using SQL Server DTS packages to achieve this goal. With minimum development, all the functionality required for data imports can be achieved with DTS programming in SQL Server.

4.33 (3)

2007-10-02 (first published: )

92,228 reads

SQLServerCentral Article

Migrating from Oracle to SQL Server

  • Article

Are you migrating your database and applications from Oracle to SQL Server and having trouble converting your code from PL/SQL to T-SQL? Then this article might help, though it doesn't cover all aspects. It provides you with answers to most commonly asked migration relasted questions. You will also find links to additional resources and books.

2002-10-02

413 reads

SQLServerCentral Article

Scrubbing Data With DTS : Part 2

  • Article

Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.

5 (1)

2001-10-25

4,976 reads

Blogs

T-SQL Tuesday 153: The conference that changed everything

By

This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...

T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily

By

Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...

Power BI guidance documentation

By

Recently there has been a number of great articles published on Power BI that...

Read the latest Blogs

Forums

Help with Copying backup files and capture results in output file with details

By SQLisAwe5oMe

Hi Team - I have the below PowerShell script which is working for me...

Any way to scale MS Vulnerability Assessment Tool

By webrunner

Hello experts, It seems like MS Vulnerability Assessment Tool is available only on a...

TDE setup during DB migration

By SQL_Hunt

Hello Experts I need to migrate a few DBS from one environment to another....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers