1. Use a derived column with the following expression:

ISNULL(myCol) ? "Dummy value" : myCol

2. But how can you put two columns into one column? Do you have to perform...

There are tons of sophisticated sorting algorithms out there. Sort your text file before you load it into SSIS. Use whatever programming language you feel comfortable in (or whatever language...

Look at this, I've done all the hard work for you and googled with the first half of your topic title.

This was the first result (at my local google website):

http://forums.bitwiseglobal.com/Forums/Thread.aspx?pageid=0&mid=4&ItemID=43&thread=150&pagenumber=1

I'm...

You can clean up your source first before you try to load your destination table. (if possible)

Are those real duplicates (meaning, every column is exactly the same) or are just...

In order to help people help you, you'll want to ask your question more better. You can check out the link in my sig to a detailed article on how...

Have you also changed your configuration file? If not, the configuration file will try reset the values of your connection manager.

Although it was a very tricky question (misleading header and code), I did find it useful to learn something about the delimiters. I also think it is worth 2 points...

The join, as the pivot transformation is semi-blocking 🙂

I must say, I admire your patience 😀

(5 replies and still...

You can use a conditional split to filter out rows with a length > x.

For the "good" records, you can add a data conversion component, to specifically set the lenght...

The pure T-SQL solution:

SELECT

customer_key= c.customer_key

,home_phone= h.phone_number

,business_phone= b.phone_number

,mobile_phone= m.phone_number

FROMcustomer c

LEFT OUTER JOIN

phoneh

ONc.customer_key= h.customer_key

ANDh.phone_type= 'Home'

LEFT OUTER JOIN

phoneb

ONc.customer_key= b.customer_key

ANDb.phone_type= 'Business'

LEFT OUTER JOIN

phonem

ONc.customer_key= m.customer_key

ANDm.phone_type= 'Mobile'

Beware, as this solution introduces NULL values for...

paul.goldstraw (10/11/2010)

---

Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting, funny...

Alvin Ramard (10/8/2010)

---

There might be a simpler solution that you miight want to try before doing the .NET stuff. Try either just CR or just LF as the row...

Hmmm. Reading and Friday afternoon, things that don't mix too well.

All right. Read the damn thing into...

Phil Parkin (10/8/2010)

---

da-zero (10/8/2010)

---

Maybe you could try a script task to solve this problem. After you've created the file, you could open it in .NET and go to the last...