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,239 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,279 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.
2005-08-12 (first published: 2002-10-25)
92,528 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
444 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,363 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,327 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
77 reads
A list of DTS resources, including bugs, issues, books, and some good programming resources.
2002-04-18
13,789 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,824 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,022 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers