April 1, 2008 at 8:27 am
hi, all
i have a txt file - and i am trying to load data into sql destination table
text qualifier= none
header row delimeter = CR-LF
column delimeter = |
row delimeter = CR-LF
I get these error when i am trying to make my connections. on the column tab the columns are mismatched. However in DTS the same file works fine with same configurations---
TITLE: Microsoft Visual Studio
------------------------------
The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly.
------------------------------
Here is little sample from file
01|2341390|03/30/2008|ajmeayworga@comcast.net|Y|SFX2DP||0
05|98741H
01|2341458|03/30/2008|BJM023655@aol.com|Y|SFX3DP||0
05|LCS4800
05|HOL4900
01|2341478|03/30/2008|iarunanplegs@yahoo.com|N|SFX3DP||0
02|TKAHM10001
03|$40 Unlimited Text Talk and Unlimited Picture Talk
01|2341485|03/30/2008|hervbwedissg@earthlink.net|N|SFX3DP||0
02|CDM1450M
ANY HELP WILL BE HIGHLY APPRECIATDE!!!!!!!!!!! THANKS
April 1, 2008 at 8:38 am
gyanendra.khadka (4/1/2008)
hi, alli have a txt file -
text qualifier= none
Hello,
The information provided is not sufficient. You need to tell us what you are trying to do and what sort of error(s) encountered. If there is not much information you provide for someone to look into it then how can you expect a solution.
Thanks
Lucky
April 1, 2008 at 8:40 am
sorry, on first i mistakley press the button. u can goahead and see the details here now, since i have edited the postings, Thnaks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply