Maybe one of the databases is sometimes offline and there is no time-out set on the connection?

Here you go:

( == "N") ? (ISNULL([C])? [D] : [C]) : [F]

I made the assumption that all columns have the same datatype. If not, you'll need to add some typecasting.

Ah, glad that you found the issue.

Nice question, thanks.

Nice question, but a bit hard for people who are not from the US or Canada...

Kiara (8/1/2011)

---

GilaMonster (7/29/2011)

At the moment, Witcher (1), Anno 1404, Fallout 3, Farcry 2, Mass Effect 2 on XBox. Have Dragon Age 1 waiting (yes, I'm behind). Heaven knows what I'm...

Does the package run correctly when you start it manually from the server?

Griffster (8/1/2011)

---

Aside from the print convert statement, this is along the lines of what my package is actually doing. Basically, I have sequence container containing all the tasks of the...

Are you sure it is a null value and not a string with the value NULL?

Griffster (8/1/2011)

---

As I run that package for many different purposes. The send mail task would become unworkable. Looks like putting this in works fine in debug mode, but it doesn't...

You can parse the Excel file using .NET in a script task.

But directly out-of-the-box with the regular SSIS components, no, it is not possible.

Griffster (7/29/2011)

---

I've written a package that runs an execute sql agent job task and then sends out an email by a send mail task. Problem is it sends the email...

Syed Sami (7/31/2011)

---

Dear Koen Verbeeck

Can you say me this

we are already have 2005 on server will sql server 2008 get install on it or i need to uninstall 2005 before...

nhsingh123 (7/30/2011)

---

Hi,

I have the exact same scenario as yours. I need to access a flat file on a remote server which is generated every week, and want to store its...

You are mixing AND (&&) and OR (||) in one condition, which can result in unexpected results. Try putting brackets so that you are sure that the conditional logic is...