Have you mapped the derived column to a destination column?

Well this is an interesting one.

I was unable to get that damned delimiter working, even though all looks fine in 'Preview' mode, as you found.

If you do a 'replace all'...

Another quick thought - what is the codepage associated with the Flat File connection manager?

I would edit the file using a decent text editor - say Notepad++ - and confirm your row delimiter (in Np++ select View/Show Symbol/Show All Characters).

Have you tried

SELECT DISTINCT ID_ITEM, DATE, ID_USER

?

Try adding a dataviewer to check that your data is as it should be.

Not without a ton of code or the purchase of a third-party add-on.

I am very surprised that this works and don't recommend it.

I have never tried, but I don't see why there would be any problem connecting to a 2012 instance from...

You're not having a good day are you? 🙂

If you are converting your input string to...

ronan.healy (6/27/2014)

---

i have the following code in my conditional split

((TRIM(INV_SECTYPE_COD) == "70")) && ((TRIM(INV_SECTYPE_COD) == "71")) && ((TRIM(INV_SECTYPE_COD) == "72")) && ((TRIM(INV_SECTYPE_COD) == "73")) && ((TRIM(INV_SECTYPE_COD) == "74")) && ((TRIM(INV_SECTYPE_COD)...

antonio.estima 4150 (6/26/2014)

---

No, I can copy via windows explorer file from server A to server B in the DMZ. But when I run the SSIS package via SQL Agent, when...

Grrr!:angry:

Great, well done.

If you're using a SQL Agent job, you should have nothing to worry about. If the job is still running after two minutes, it will not be invoked again until...

antonio.estima 4150 (6/25/2014)

---

I understood what you said, but look, the target server is outside the network. The same is in the DMZ outside the domain to access it is through...