halifaxdal (7/23/2014)
Alvin Ramard (7/23/2014)
Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or C#, or at least fix the format using VB or C#.I just can't believe this: it looks like a normal task, doesn't it? bcp should be able to handle this back to SQL2005 :angry:
Using program to import data would be unrealistic to GB size file.
Thanks.
Actually, a "normal task" would be to have properly formatted data in the file. 😉 See my comments in my most recent post above.
--Jeff Moden
Change is inevitable... Change for the better is not.