First off, you need a precedence constraint between Export SBISCLPRICELIST and Rename Files.

Please will you double-click on the precedence constraint between Rename Files and FTP Each File and post a...

I'm not...

Lindsay

Is the database in question significantly larger than the others? Have you done a RESTORE VERIFYONLY on the backup file? Is this done as part of the backup...

Lindsay

Go to a command prompt and type net helpmsg 64. This will tell you what the error message means. Looks like your network is somewhat flaky.

John

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...