SSIS

T-SQL Bulk Insert

T-SQL that allows you to import tab delimited text file into correct table based on file name.

RE: DTS Packages on 64 Bit

We were hit with the same rude surprise when we migrated.  Short version - keep DTS on 32-bit.  It might run, but you are on your own if you do - untried, unsupported, etc.We kept our old 32-bit boxes as the DTS clients, then quickly made some of our packages dynamic so logging and connections […]

RE: How to speed up DELETE queries on MSSQL v7.0?

Okay; it's probably the foreign keys.  What indexes exist for the eight tables with foreign keys referencing the RetailMember table?  What DRI options (e.g. CASCADE DELETE) exist for those constraints?