Viewing 4 posts - 1 through 4 (of 4 total)
Thank you all for the replies...I'm seeming to have luck with importing the .CSV into OpenOffice Calc, then importing into a new SQL table, then using a web application to...
January 22, 2014 at 1:38 pm
Further of note: It seems to have worked (somewhat) in that of the 2081 records in the .CSV, 1349 were imported. But I'm still missing about 1/3 so this...
January 17, 2014 at 3:05 pm
Okay so I open the .CSV with OpenOffice Calc and all columns looked great. Tried to import into a new table in SSMS and got:
error 0xc020901c: Data flow task:...
January 17, 2014 at 3:02 pm
When you are running the import and you get to the 'Select source tables and views' screen have you tried to edit the mappings to match your existing table?
Not sure...
January 16, 2014 at 10:41 am
Viewing 4 posts - 1 through 4 (of 4 total)