maybe this link helps ..

http://dbforums.com/t746009.html

did you check that the account that runs the cluster has access to your sqlserver. (login should do)

"declare @sql nvarchar(2000)

SET @sql=N'Select *

From vHaulageJobsUnfinished U

WHERE EXISTS (

SELECT *

FROM HaulageItems I

JOIN Jobs J ON I.JobPrefix=J.Prefix AND I.JobID=J.ID

WHERE J.JobRef LIKE ''' + @ShippingJobRef + ''' AND U.Prefix=I.HJPrefix AND U.ID=I.HJID

)'...

"... but replace all the 'IS NOT NULL' statements with '!=NULL' and ..."

You'll have simular differences when you use the JET-syntax for outer joins on sqlserver.

'*=' does not work...

You'll always (never say never ) have to interpret business "demands" to "needs".

You can do the same thing in # ways. Some are already constructed for...

Maybe you can go for the colation-solution with your select. (check BOL)

e.g.print CHARINDEX('k' COLLATE Latin1_General_CS_AI ,@teststr COLLATE Latin1_General_CS_AI )

When you run the package, is that at your client or are you at the server-console ?

Don't modify dts-packages from your client, but always perform this stuff at the server,...

is the job-step set to "quit with failure" when the step fails ?

With Standard VB6 it needs a normal login-procedure and the a switch to the

application-role executing the sp_setapprole.

Is there a .Net-framework-based integration for SQLServer application roles?

If not : are application roles...

If you just want to insert and you don't need the recordset fore anything else in your logic, don't use the recordset to do this, but use a native insert...

maybe isnull(yourcolumn,replacementvalue) can help out or

coalesce(yourcolumn,replacementvalue)

OK Identity does not reuse. Should it ? Depends on the requirements. If your id column reaches the maximum value (int/bigint !!), you're in big troubles anyway and probably you'll...

I think I'll start counting from the other left side

Cheers

use IDENTITY. That's what it's made for.

Or keep your own parameter-file which you access using a genereate-new-id stored procedure.

this EOM-thing , does that mean you have to stand on a chair/table and that everyone else has to sing to you ? ended by 3 times hurray