What error message are you getting when you run it as a job? Does the package use package configurations? Could it be that the configuration settings are being...

No need. He's using a SQL table package configuration,...

From your brief description, I'd say you need a calendar table. Have a read about that - there should be some stuff on this site about it.

John

Failing over a clustered instance is, in effect, stopping it on one node and starting it again on another. So you should expect everything that happens when you stop...

If you can't see SQL Server Agent, it may be because you don't have the necessary access. Are you a member of the sysadmin server role, or a member...

This is because you're trying to configure things that don't exist in the package. If you're sharing one configuration file (or configuration table) between packages, the packages need to...

The requirements on many job descriptions are more of a fishing exercise than a statement of reality. You'll probably find your two years' experience qualifies you for quite a...

Or you can use xp_logininfo. No linked servers, no loops, no "foreign" languages.

John

The REPLACE statement doesn't update the table for you. All it does is return the first expression but with any occurrence of the second expression replaced by the third...

Steve

I understand. You may still have a missing index, I suppose. In any case, do the SET STATISTICS IO ON thing as I suggested - you'll then be...

Try using SET STATISTICS IO ON next time you run it for the first time in a few hours. Save the results, and then run it again and compare...

Use the COALESCE function.

John

You don't need to use a Script Task. A (relatively) simple UPDATE statement will do the trick. I haven't tested this, so you may need to tweak it:

WITH...

What version of SQL Server are you using? Please will you post a sample of data from your tbl_SI_Var_CS1 table?

John

Yes, or use GROUP BY and HAVING. Sounds suspiciously like an interview or homework question to me.

John