March 12, 2009 at 9:22 pm
Hello,
I am trying to import a text file in DTS. Pretty simple. I am usintg SQL Server 2005. It is on Windows Server 2003.
The text file is showing an empty square as a row delimiter. I am getting an error. In the future, we plan to migrate all DTS packages to SSIS.
Now we are in a time crunch. I looked at the text file in notepad and I see the special character. I sent the file to my home pc (running Windows Vista Ultimate), and I don't see the characters and the rows line up perfectly.
Is there a "text driver" that SQL Server 2005 is using that is shared with Windows Server 2003? Is this driver updated in Windows Vista?
How can I get SQL Server to interpret this character as a row delimiter?
(If this is in the wrong topic, I apologize. I wasn't sure what topic to post to).
When I do a select @@version in query analyzer I am getting:
Microsoft SQL Server 2005 - 9.00.1399.06(X64)
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
March 13, 2009 at 9:37 am
Well...
I got it to work. I found someone that said make the text qualifier "none".
I was then able to parse the flat file.
It is still odd that on Windows Server 2003, I see special characters that I don't see on Windows Vista Ultimate.
Maybe Vista upgraded...something.
That is a problem for a later date. For now, setting the text qualifer to none has allowed me to import the text files and get back to work! 😀
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply