March 8, 2007 at 3:46 pm
I'm trying to import a tab delimited file from our foxpro DB into SQL. Table structures are identical, but I'm getting truncation errors on columns that are filled out to their max length. I'm guessing this is because of the double quotes surrounding them being included.
Does anyone have any insight on how to get around this?
Thanks!!!!
March 9, 2007 at 9:58 am
This isn't a perfect solution but you could open the file in a text editor and search/replace the double quotes with ''.
March 13, 2007 at 6:43 am
How have you configured the connection manager?
Have you set the quoted identifier and specified the columns that have one?
If this isn't the issue and you want to automate nicks solution, this can be done in a script component. You would use the streamreader to read each line into a variable, then replace any unwanted characters before writing the variable to a new line in a separate file.
Kindest Regards,
Frank Bazan
March 13, 2007 at 8:06 am
We're just going to have foxpro do the inserts. SSIS is proving to be way too much trouble for this. I did have it configured in the connection manager.
Thanks for the input guys!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply