I think an Exec SQL task that returns a row count and feeds it into a variable. Then the variable is used in the precedence with expressions to determine...

I haven't experienced that. There are additional features, and you can do some things faster like index rebuilds. But your everyday queries shounld't be any faster..

CEWII

To make it work you can't use the Integration Services Package type. You have to use Operating System type..

You need to find the full path to the 32-bit version...

Simple question..

Does the sproc support multi-values in the paramter? If not no matter what you want to send it won't work..

Do you know if it allows multi-input? If...

Maybe for SQL Mail.

And a warning from BOL "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

See my answer at:

http://www.sqlservercentral.com/Forums/Topic792353-146-1.aspx

CEWII

See my answer at:

http://www.sqlservercentral.com/Forums/Topic792353-146-1.aspx

CEWII

It should. However, if the job was running DURING the failover the answer is probably no, it won't restart.

CEWII

Lynn, great article..

You make reference to Jeff's article, I'm curious how this method compares to Jeff's method..

CEWII

EXEC dbo.Test1 @Key1 = ?, @Key2 = ?

CEWII

Sorry, it came accross as not understanding the entire point I was making. It sounds like you understand..

CEWII

See my answer at:

http://www.sqlservercentral.com/Forums/Topic792329-148-1.aspx

CEWII

Kicking_Fish0713 (9/22/2009)

---

Hello,

Can somebody help me on how to solve my problem in SSIS?

I've created SSIS,when I try to run this on the development,it works.

But on the job,the error is:

Argument "XLS"...

There isn't a query.

You'd have to write it in .NET to make it happen, so no, I can't give you a query..

CEWII

It is possible, sort of, but the problem is that you have to set the command and you can't change it. What that means is that you can't change...