Thank you very much.

Thank you very much:w00t:

Thank you.

So essentially this procedure is querying dbo.table and whenever it finds a null value it replaces the null value with one of the call variables we initiated...

So there is more input than just dbo.table? How does this work?

Just wanted to reinstate how much help you were here. You got me off to a really good start Elliot. Thanks again.

Great, thanks

I'm not quite sure what happened, I have seemingly back slid since this was successfully working.

I am now getting a failure to lock variable. It doesn't seem like IsSourPathVariable...

Ah okay, thanks

The easiest way to do this is to go into SQL Management Studio and NOT BIDS.

^ Unsure why this doesn't work, maybe I need to be on forum...

You make a very good point. Definitely something to consider.

Thank you for your comment Jeff, I will definitely be trying that next.

For anyone else who is attempting this, here is how I solved what I was doing...

It definitely builds, I must have the wrong code somewhere though. Thank you for your help, updates will continue.

Nice, we are making headway.

I am now receiving this error when debugging:

[Execute SQL Task] Error: Executing the query "IF EXISTS (SELECT * FROM sys.objects WHERE object_..." failed with the following...

I set each expression to it's appropriate Execute SQL Task, I assigned no other expressions.

Both of the properties are set to ForceExecutionValue. It didn't co-align with MSDNs...

Thank you for your detailed response, you are a very big help as there is not a lot of useful/detailed information on this subject matter.

-I have the property...