I have recieved some CSV files that I need to simply import into SQL 2005 tables. These files open cleanly in Excel 2007 and import cleanly into Acess 2007. But for some reason a simple import into SQL Server table using SSIS and flat-file source doesn't
place the data in the correct columns. I need to automate this for nightly updates.
I have tried using just the defaults and then setting " as a text delimiter, but the import fails.
I had a similar project a couple years ago when I ended up using Bulk Insert with Format files that I created. But SSIS should make life easier...correct? One thing I noticed is that the first row contains column names. Some of the names are surrounded
by double-quotes and others aren't. Excel seems to like this just fine.
Thanks for any help.
View Complete Post