Take a walk on the wild side and do it. If it bails, sit back and whistle like you know nothing....:cool:

While the two suggestions are spot on, you do not need a script task to modify the variable value. Look at variable expressions (Highlight variable, F4). You can make the...

It's fairly easy to walk down the package.

See http://msdn.microsoft.com/en-us/library/ms135946.aspx as a starting point.

Here are many tips:

http://mahiways.spaces.live.com/blog/cns!6A1F270FEA8CDD8C!142.entry

Finally: http://www.google.co.uk/search?hl=en&safe=off&rlz=1T4GZEZ_en-GBGB270GB270&pwst=1&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=programmatically+create+ssis+package&spell=1

sorry, remove count(Null) and just have null.

Select null from table.

SQL Command would work but is slow if you on a large data set.

Why not push them into a temp table and do a join. Will be far faster on...

Easiest way would be to use a SQL task and run a check in it.

If not Exists(Select count(Null) From MyTable)

RaisError("Table is empty!", 16, 1)

All SPs and hotfixes will only patch unpatched "parts"

Have you tried using a SQL task?

Very weird, does not happen to me.

If you try with a different proc? Or cut down your existing proc for the purpose of testing and try see what is happening....

It is a lot easier than Jamie's. It's a lot simpler as well. One of the advantages of his is the row counts. But ultimately, they do the same thing....

There is nothing wrong with doing that. Slow, but ok. What is your inner loop based on? Which loop seems to be endless. What defines endless? How many rows is...

To make a Super Client:hehe:

Sorry, it's late and not enough coffee....

You could write a package to do this. You would have a...

When it's trying to run, no blocks on the DB for your SPID?

The logging to Text or SQL (Not the version jamie is talking about) is quite simple.

Right click in the work space and select Logging.

1) Select a provider (Use text for...

And you sure the connection manager is ok? Test Connection button is ok?

Are there any expressions on the connection manager that could be changing the server name at runtime?

If you...