I am trying to setup an automated routine that will import a csv file into SQL 2005 on a daily basis.
I get this csv file from our fedex shipping application.
I have tried several ways to import this file but I keep getting errors.
Basically I am chosing a flat file for the source, I go through and map the fields etc... then I keep getting errors on the conversion etc... My though would be to treat all of the fields as text except the two date fields.
This should not be this hard but I have spent the last 4 hours trying to make this work...
I also need this routine to pickup the file from lastnights run and import it each day.... the file is named different for each day...fedex1-10212009.csv is yesterdays fedex1-10222009.csv will be tomorrows
Here is a sample from the csv file I get each night...
118716 DA/NCR NICK W.,963499661563,0,0,1,6/16/2009,6/15/2009,
118727 DA/DA DAVID G,963499661655,12,11,1,6/18/2009,6/15/2009,