Query a flat file to eliminate records with a blank account number
I am using a CSV file as my input and uploading this data to a SQL table. I only want to upload records that have an account number. How do I query the input to only write records to the SQL with an account number in the file. Thanks, Amy
November 16th, 2010 11:08am

Hi Amy, Could you please let us know how you are uploading your CSV file to the SQL table? In case you are doing it using an SSIS package, you can use a conditional split task to eliminate the records where the account number is empty. Cheers, ShalinShalin P. Kapadia
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 11:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics