stevefromOZ (9/1/2010)

---

In case you are looking to do this in SSIS and not SQL, you're looking for the conditional operator (which, if you used that in a google search, it...

I didn't get this description. DARN!!!

You might want to take a look at the CASE statement.

I also would like to recommend that you take some time to learn a few things about SQL Server before...

Would you mind explaining the requirements? I would have to assume what that means if I was to try and answer your question.

Lynn Pettis (9/1/2010)

---

GSquared (9/1/2010)

---

Here's an interesting one. This is the list of skills someone wants for their "DBA":

Must have advanced proficiency and extensive knowledge of web development and design...

GSquared (9/1/2010)

---

GilaMonster (9/1/2010)

---

Grant Fritchey (9/1/2010)

---

If your contact email looked like mine, it was simultaneously a**-kissing and completely generic. The guy waxed prolific about how great I am and how qualified...

Too much bull,...

Brandie Tarvin (9/1/2010)

---

Grant's comment leads me to this question: What do the rest of you do if you get a call, or linked in mail, but aren't looking for a...

Elliott Whitlow (9/1/2010)

---

Ran into this before myself, and the answer is.. you can't directly..

BUT, you have several options to make it happen:

1. Use an EXEC SQL or Script Task...

You're more likely to get your SSRS question answered if you post it in the SSRS section instead of the SSIS section.

You'll have to use an expression for the destination filename. That expression should concatenate the timestamp with the original filename.

We cannot properly answer your question without knowing what you want to happen when there's an error with a file.

Stefan Krzywicki (9/1/2010)

---

Alvin Ramard (9/1/2010)

---

Stefan Krzywicki (9/1/2010)

---

Alvin Ramard (9/1/2010)

---

FYI, for those who have not tried to find out more about the SQL 2008 R2 Developer Edition, let me clear something...

Stefan Krzywicki (9/1/2010)

---

Alvin Ramard (9/1/2010)

---

FYI, for those who have not tried to find out more about the SQL 2008 R2 Developer Edition, let me clear something up.

You may be asking...

FYI, for those who have not tried to find out more about the SQL 2008 R2 Developer Edition, let me clear something up.

You may be asking why this thread? ...