1

I have text file something like this

col1þcol2þcol3þcol4
aaaþbbbþcccþddd
xxxþyyyþzzzþabs
123þtyehþyetþethrr

i tried loading into sql-server using ssis package after following steps from here but i couldn't find solution,could somebody guide me in my execution

The Package fails :

here's snap shot from program execution

[Flat File Source [8]] Error: Data conversion failed. The data conversion for column:<column namesss>

it outputs like this

enter image description here

the changes i tried making: like this

enter image description here

enter image description here

enter image description here

Community
  • 1
  • 1
vhadalgi
  • 7,027
  • 6
  • 38
  • 67
  • You say you tried using the steps from another answer, but you don't actually tell us what happened when you followed those steps. Did you get an error? If so, what was the error? Did the import happen but have incorrect data? – Damien_The_Unbeliever Dec 16 '13 at 07:39
  • @Damien_The_Unbeliever when i try on a sample file i get output like i shown in image but when executed on a large file (with 10 big column names+2000 rows) it gives error? – vhadalgi Dec 16 '13 at 07:51
  • Based on your column name, it appears you don't have the columns defined in the Connection Manager. Pop a screenshot of the tabs from the Flat File Connection Manager and a row or two of sample data and I can take a look – billinkc Dec 16 '13 at 17:13
  • @billinkc : iadded details from connection manager – vhadalgi Dec 17 '13 at 04:20
  • 1
    Ha. My favorite emoticon character. :-þ – RBarryYoung Dec 17 '13 at 04:24
  • @RBarryYoung: that's nice !! but could you help me fix this sir ? – vhadalgi Dec 17 '13 at 04:26
  • @VijaykumarHadalgi Sure, OK. – RBarryYoung Dec 17 '13 at 04:29
  • possible duplicate of [How to read a flatfile with lowercase thorn as the delimiter](http://stackoverflow.com/questions/20388031/how-to-read-a-flatfile-with-lowercase-thorn-as-the-delimiter) – billinkc Dec 17 '13 at 13:38
  • 1
    As @RBarryYoung has pointed out in his answer, you don't have columns defined because you don't have the thorn delimiter specified. It's reading your data as one big column. That said, this falls back to being a duplicate of the question you're working through – billinkc Dec 17 '13 at 13:51
  • thank you @billinkc i figured it out. – vhadalgi Dec 18 '13 at 10:56

1 Answers1

3

Change thorn to be your column delimiter, not your Row delimiter. Then change your row delimiter to be line break (presumably).

To do any more we'll need to see your table definitions and the rest of your package definition, particularly the column assignments.

RBarryYoung
  • 55,398
  • 14
  • 96
  • 137
  • thank you!! i'm working on it,sample text is nicely executed theres another big text file with "þ" delimiter i need to do that – vhadalgi Dec 17 '13 at 04:53