All right, I found the reason why the result seems wrong, sorry Mark, the original data is not well normalized, your code is good. 😉

[/quote]

Can you post some sample data[/quote]

all right, here is a snap:

AAAPOS2122941POS2065860

BBBPOS2081642POS2081641

BBBPOS2084810POS2114958

BBBPOS2092572POS2081642

BBBPOS2089937POS2114958

BBBPOS1008747POS2081642

BBBPOS2114958POS2081641

BBBPOS2095265POS2081641

BBBPOS2078295POS2114958

BBBPOS0025394POS2081642

BBBPOS2092567POS2081641

BBBPOS2081641POS2122941

BBBPOS2092575POS2081642

BBBPOS2068844POS2081642

BBBPOS2119706POS2114958

CCCPOS2112258POS2122966

CCCPOS2112257POS2122966

CCCPOS2069283POS2057262

CCCPOS2045766POS2112257

CCCPOS2125450POS2069381

CCCPOS2057262POS2122966

CCCPOS2115660POS2112257

CCCPOS2121531POS2089901

CCCPOS2069381POS2057262

CCCPOS2115661POS2112257

CCCPOS2050452POS2122966

CCCPOS2122966POS2122961

CCCPOS2045536POS2112257

CCCPOS2095347POS2083347

CCCPOS2090072POS2112257

CCCPOS0025705POS2112258

CCCPOS2089901POS2112258

CCCPOS2027898POS2050452

CCCPOS2044542POS2050452

CCCPOS2048225POS2112257

CCCPOS2095281POS2083347

CCCPOS2089922POS2112257

CCCPOS2063877POS2050452

CCCPOS2111343POS2057262

CCCPOS2083465POS2083347

CCCPOS2083347POS2122966

CCCPOS2102437POS2057262

DDDPOS2093894POS2125992

DDDPOS2125992POS2122957

EEEPOS2107331POS2122941

EEEPOS2110913POS2107331

EEEPOS2112351POS2107331

FFFPOS2050455POS2122941

FFFPOS0024972POS2050455

FFFPOS2109848POS2050455

FFFPOS2008805POS2050455

Neither of the code are working. :hehe:

1. to Wayne: what I gave in the sample data is really just an example, the order is not like that simple, I mean,...

Thanks Sam, it is working now.

Hi,

I think the problem is clear now: I need to make sure the account running the package has the same privilege as ABC\DEF, because that's the account set up...

OK, this is a little tricky:

My credential is ABC\DEF

The job (SSIS) needs to fetch a file on network, which ABC\DEF has access to.

Once ABC\EDF got the file, it will be...

Jeff Moden (3/20/2009)

---

halifaxdal (3/20/2009)

---

Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source file,...

Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source file, so please keep...

Thanks. That's exactly what I just found out. How about removing the last EOF?

OK, I am getting there, now I am able to import the data, except two issues here:

1. There is a EOF in my data source file, something like: EOF...

My mistake, the data source IS USING Tab as delimiter, but I am still failing here to import, the wizard always stop with error message like:

The data conversion for...

This simple job is driving me nut, can you provide any instruction on this particular case? I never use bcp before.

Thanks lots.

The funniest thing I saw here is SQL doesn't seem to handle this properly:

Here is my procedure in the import/export wizard:

1. Choose Flat file source

2. Set Column delimiter as "...

No, I don't have control on the data source.

I used " (double quote), which you can see in the text file, as the column delimiter, the problem is it creates empty column for every real column for me.

As...