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,219 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,236 reads
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.
2007-10-02 (first published: 2002-10-25)
92,463 reads
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
430 reads
Brian Knight recently had the opportunity to look at a very unique product in the industry. MYdbPAL automates many of the tasks that database professionals perform on a day-to-day basis. Read his review here.
2002-07-16
4,344 reads
This article shows how to use a DTS package to detect a file. After the detection of the file the processing of the file can be completed. This code in the .DONE processing section uses the Wscript.Shell command to unzip a file.
2002-07-09
11,285 reads
SQLServerCentral.com this week launched its second Resource Centers. This time, focusing on DTS. The DTS Resource Center focuses on tracking bugs, articles and books from throughout the Internet.
2002-05-29
61 reads
A list of DTS resources, including bugs, issues, books, and some good programming resources.
2002-04-18
13,768 reads
One of the common questions you see in the newsgroups is where should you save your DTS packages. This article covers the most optimal way to save your packages as well as version controlling DTS.
2001-11-15
9,782 reads
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.
2001-10-25
5,000 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers