James Greaves

  • Interests: Motorcycles, SQL Server

Handling Zero Byte Files in DTS

SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.

3 (2)

2006-03-27

6,788 reads

Blogs

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Daily Coping 2 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Function not returning all data.

By David C Young

I inherited this code. Written by a 3rd party. I have 3 servers, 1...

Need to change RS Execution Acct PWD, automatically w/ T-SQL

By Express12

We use a 3rd party vendor to administer our SQL Server service account PWDS....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers