Thanks Martin - but having looked there, I can't see any changes that affect how SSIS deals with the NUL device.

As you're now using a staging table, you could do all three ADD/DELETE/UPDATE operations at once with an SQL MERGE. Are you going to cover that in the next...

Hi Joe. I am honoured to receive one of your rants 🙂

"Remember the early versions of UNIX?" - sorry, I don't know what you're getting at here. I...

I have a similar problem - though with not so many different headers! - which I solve using SSIS. The standard Flat File data task is very inflexible and...

For the rate, either DECIMAL(8,4) or DECIMAL(25,13) is good in this case; both give exactly the same results. But they still don't match the original test data - about...

All these methods use CHARINDEX to efficiently see where the next delimiter is. But what about handling CSV strings with quoted text, e.g. where "John Smith","23, The High Street","Sometown"...

Er :ermm: ... does anyone remember when this forum was about SQL Server, and this thread about SQL Injection issues? :Whistling:

Talk of SQL Injection always reminds me of this xkcd comic, which should never be forgotten by database professionals - Little Bobby Tables[/url]

A useful article and discussion. However I do not understand the point of [font="Courier New"]ISNULL(@MyStatusList,'')[/font] in the method given in the article. As the first line of code...

Is deleting in batches likely to save elapsed time?

I frequently have to delete a million+ records from each of several many-million record tables, based on a short indexed field.

SS 2008,...

BTW Microsoft's documentation has an error too - it says "Accuracy 100 nanoseconds". This is of course the Resolution (or Precision) of the data.

The accuracy will depend on...

I agree with cdiebolt. While there was no such date in England's dating system at the time, it's a perfectly valid date in the Gregorian calendar, and corresponds to...

AIRWALKER, which version of SQL Server do you use? SQL Server 2008 SSIS supports both VB.NET and C#.NET, but earlier versions only supported VB.NET (or plain old VB...

It's only a 30 GByte database, so perhaps small beer for most of you, but as an indication of SSD impact my development machine - over-clocked Intel i5-760 (4 core),...

You can NEVER completely test software.

Think about testing a single expression, A * B for all possible 32-bit values; there are 2^64 possible results. ...