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,786 reads

Blogs

Encryption in SQL Server #1 – Column Level Encryption

By

For one reason or another data security and encryption has been coming up quite...

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Read the latest Blogs

Forums

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Query store index rebuilds

By Rasmus Remmer Bielidt

Recently we experienced a sudden surge in disk I/O every twenty minutes or so....

Group Managed Service Accounts for SQL Server 2017/2019

By @@caffeine_level

We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers