Jayram Tallamraju


SQLServerCentral Article

Data Import Functionality Using SQL Server

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)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

92,448 reads

Blogs

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

Read the latest Blogs

Forums

Transactional Replication from Read replica

By cooldude001

If I have Read replica (in Azure SQL MI), can it be used as...

SQL availability group and file server role answering from the same name

By bill-humphrey

Hello, I'm tasked with setting up a 2 node server cluster that will host...

Visit the forum

Question of the Day

Replacing a Null

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;

See possible answers