You could try doing it the other way round, by setting the name of the task from the value of the variable. Just go to Expressions in the task...

Do you have a backup of your database?

John

Why do you need to be done...

parthi-1705 (11/17/2010)

---

Dont say it is cross post of

http://www.sqlservercentral.com/Forums/Topic1021535-391-1.aspxsince it is BI form i have posted here so that i can get solution

and i am using 2005 and 2008...

This is the kind of thing that SSIS (Integration Services) was designed for. Have you tried using it?

John

I think this is happening because you're trying to have an empty string as a date. You can't do this - you either need to choose a placeholder date...

I think you need to hire a consultant, in that case.

John

Convert the number into a character data type (if it is not already) and use the STUFF function to replace the first n characters with asterisks. Please try this...

Harm

Some third-party backup utilities, such as LiteSpeed, include object level restore, allowing you to back up one database and restore only the objects you require into another.

If you don't have...

So it fails when scheduled but succeeds when run manually? I can only think that's because it's scheduled to run overnight, and there is a problem with the network...

pujain (11/16/2010)

---

if its a permission issue how my Tlog backup is running successfully?

its only full backup thats increasing my headache.

when i ran it manually it ran successfully so network issue...

Yes. Try backing up to a local drive. If that works then you know your problem is with the network - permissions, communication, whatever. Check that the...

Pat

TRY...CATCH isn't available in SQL Server 2000.

John

In your sample results, the price is the same where the hotel is the same. But you can still group by the hotel name to show the minimum price...

It's because you've got more than one ResultID for each hotel. Does it matter which one you display? You can use GROUP BY and show the mininum or...