Because once in a while, you get replies like these:

Koen,

You rock! It worked for me! The solution I have found by following the link you provided, http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/, totally worked for...

Stupeo (6/6/2012)

---

However, the performance isn't the best so i've been looking at upgrading to the following

OCZ Agility 3 240GB SSD (520mb/s read and 500mb/s write)

16 GB corsair memory

Would this...

Ragged right is essentially fixed column width with no specific length for the last column.

So you need to specify the length for each column with the markers.

http://msdn.microsoft.com/en-us/library/ms180239.aspx

The expressions should work, however don't seem to use the correct positions.

LTRIM(SUBSTRING(DATA_STR, 108,30)

This one will take data from position 108 till 138

LTRIM(SUBSTRING(DATA_STR, 132,30)

Thhis one will take data from position 132...

Ragged right. So you defined the length for each column?

How does the package design look like?

Any blocking transformations?

If for some reason there isn't enough memory and SSIS has to spool data to disk, performance drastically degrades.

Try to get those functions out of your join columns, if you want to use indexes.

This also seems problematic:

,dbo.GetDateTimeAdd(INCALD, (

row_Number() OVER (

PARTITION BY sc.PnxCodeValue

,a.IAREF# ORDER BY a.IAREF#

) + (

SELECT MAX(seqno)

FROM...

Typing in caps equals shouting. It will not get you help any faster.

What is the delimiter of the flat file?

Enable logging on preexecute on postexecute events, so you can exactly see what is going on.

Greg Edwards-268690 (6/7/2012)

---

Brandie Tarvin (6/7/2012)

---

Greg Edwards-268690 (6/7/2012)

---

My co-worker is leaving soon, so yesterday my manager asked me job description / keywords he should use in a job posting.

We are open...

cafescott (6/7/2012)

---

Thanks for the response. I've been trying to confirm that the package was actually using the connection string from the XML config file. It now appears to...

Brandie Tarvin (6/7/2012)

---

I'm sure this will come off sounding stupid, but I have never heard of Fizzbuzz. I see the solutions, but I don't understand what you're solving.

Could someone elaborate...

Stefan Krzywicki (6/7/2012)

---

Brandie Tarvin (6/7/2012)

---

All,

If you have a LinkedIn account, you should change your password immediately. Their servers got hacked and millions of passwords were stolen. Not everyone is affected,...

Tarun Jaggi (6/7/2012)

---

Yes Paul. We need to process huge data. Thats why we want them to be run in parallel but within a transaction. Running them sequenctially will take a...