I am having the same problem. In the extended properties of your connection you can specify that there is no header row.. HDR=No;
This doesn't resolve the problem for me, but it might be the problem for some with missing data. I've tried converting the datatypes to strings in the SELECT statement to no avail. Anyone?
Ahh I just found it. In the extended properties if I set IMEX=1 then it works. I have no idea why, but I saw it mentioned somewhere else on this forum and it fixed it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.