Hi again,
I am not sure if I am in the right forum this time so please be patient with me.
I have a text file which is sent to me every day with roughly about 70 columns and about 300,000 rows which has columns delimited by commas and Text by quotations and Rows by LF.
and I run a DTS to import the file into a table everyday before I get to work, but it has crashed a few times and today I investigated why (I was getting an error saying "Column Delimiter not found") when I looked at the record where the problem was I noticed that if the street was only one letter the file which was sent to me has quotations aroun it to show it is supposed to be like that, but this is causing me havoc as my DTS thinks it is a Text field and is looking for a comma after the quotes close and hence "Column Delimiter not found" I hought of building a Replace statement into my DTS in VBscript but that is not helping I need to remove the quotes before I start the import.
PLEASEEEEEEEE can someone help. I am totally lost with this one.
I am not sure if I am in the right forum this time so please be patient with me.
I have a text file which is sent to me every day with roughly about 70 columns and about 300,000 rows which has columns delimited by commas and Text by quotations and Rows by LF.
and I run a DTS to import the file into a table everyday before I get to work, but it has crashed a few times and today I investigated why (I was getting an error saying "Column Delimiter not found") when I looked at the record where the problem was I noticed that if the street was only one letter the file which was sent to me has quotations aroun it to show it is supposed to be like that, but this is causing me havoc as my DTS thinks it is a Text field and is looking for a comma after the quotes close and hence "Column Delimiter not found" I hought of building a Replace statement into my DTS in VBscript but that is not helping I need to remove the quotes before I start the import.
PLEASEEEEEEEE can someone help. I am totally lost with this one.