Skip to Content
0
Former Member
Dec 29, 2010 at 05:26 PM

Problem Importing Delimited Text into MDM Using Import Manager

157 Views

(this is my first post, so here goes...)

When attempting to import a set of data into MDM using import manager, I run into the following error:

"Error Connecting to Source

Logon Error:
(the file's location on a network drive): Line 2 (Pos: 1)."

This is what line 2 looks like in my text file:

112396087218;1" Square Drive Handles

I've figured out that the (") symbol is what is tripping import manager up and preventing it from loading the text file. If I take out that character from the above line, it loads the text file correctly into import manager. My guess is that this means that import manager doesn't play well with special characters. Unfortunately, there are quite a few terms with various special characters within my text file.

I have the text file saved as Unicode rather than ANSI, but that doesn't seem to help.

Any ideas? Your help would definitely be appreciated. 😊

Edited by: mathewc on Dec 29, 2010 6:58 PM