You could use a conditional split followed by as many derived columns as you need.

The Dixie Flatline (10/12/2010)

---

Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.

Just lay them on the table and proceed...

Donalith (10/12/2010)

---

Derrick,

Unfortunately, we've grown out of control on the production database (happened before I came on board) and we can't replicate it due to storage issues.

Alvin,

How do you export in...

How are you doing the export?

Have you tried doing this in batches instead of the whole table at once?

AndrewSQLDBA (10/12/2010)

---

Hello Everyone

What would be the Best way to create an IF statement within a SSIS Package?

I am wanting to fire off a SQL Task, if the Day of the...

preensheen (10/12/2010)

---

Hi All,

Is it possible to chage the values while transforming the values in SSIS. For example...I have bit values coming from database..say 0 & 1 and need display...

Find out why you have duplicates in your sample data. Is it because you of bad sample date? Will the real production data also have duplicates?

The answers to...

I've seen one company cycle the logs files on every server everynight at midnight. This made searching the logs much easier that trying to do it with a log...

No, SSIS is trying to commit a batch of records at a time. If any...

Michael Valentine Jones (10/12/2010)

---

Since the source of data is a TXT file created with BCP, why don't you just order the TXT file in the order you want by using...

steveb. (10/12/2010)

---

Deepthy (10/12/2010)

---

Thanks for reply, but dtexec and dtexecui are giving the same error

Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for...

No argument there. I'm trying to...

I'm not suggesting this as a way to sort big files. This is just an idea for a bit of fun.

I wonder if there's a way to implement a...

Donalith (10/11/2010)

---

Thank you so much for your help!

I'm going to go with the detach, copy, and reattach. That'll leave a viable database on the first server while I'm working on...

GSquared (10/11/2010)

---

If you can do it to a bagel, can you also do it to a...