Jack Corbett (10/25/2010)

---

So I got an email from a friend this morning asking for some SQL help. They are running a system that used to have multiple databases per...

CirquedeSQLeil (10/25/2010)

---

Alvin Ramard (10/25/2010)

---

Stefan Krzywicki (10/25/2010)

---

Steve Jones - SSC Editor (10/25/2010)

---

Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick...

Steve Jones - SSC Editor (10/25/2010)

---

I think it's...

Stefan Krzywicki (10/25/2010)

---

I...

I didn't expect...

Craig Farrell (10/22/2010)

---

Alvin Ramard (10/22/2010)

---

Alvin Ramard (10/22/2010)

---

[rant]

I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use...

I think I...

gregory.anderson (10/22/2010)

---

Alvin Ramard (10/22/2010)

---

gregory.anderson (10/22/2010)

---

I've read quite a few websites and still haven't found a nice walkthrough on how to output my data to a flat file.

Here's were I am:

Created...

I...

gregory.anderson (10/22/2010)

---

I've read quite a few websites and still haven't found a nice walkthrough on how to output my data to a flat file.

Here's were I am:

Created a "Execute SQL...

s.chandrahasan (10/22/2010)

---

SELECT rf.ContainerNo,rf.BookNo,BC.seal1No,BC.tareweight as tareweight, ...

[rant]

I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!

[/rant]

One option is to use the derived column transform along with the conditional split in the dataflow to convert the data you have to the values you want.

Another option is...

You obviously have...

Sorry, but I do not have any good links for you. I figured out how to do this by myself. It's not that hard.