Andrew

The backup failure on T:\MSSQL10_50.sqlvault\MSSQL\Backup\UserDBs\EVVSGxxxxx\20140605_200752_EVVSGxxxxx_1_11.BAK - is that a backup that you have scheduled? At what intervals does this error occur?

John

Well, you won't know until you try, but I would guess that it will.

John

You need to use the splitter I linked to earlier in order to separate the languages out. Then you will be left with strings like this:

[font="Courier New"]US:"Project/Prescription sale"[/font]

The bits...

Yes. Do you have the option to use Windows authentication to connect instead? It's bad practice to do anything as sa.

John

Well, the language-specific description always begins at the 6th character, and ends at the (n-1)th character, where n is the total length of the string. You can use SUBSTRING...

Not sure which server you're referring to, but you can set up any old server as a CMS (has to...

If it's an option, I would create a table with one row for every combination of sale type and language. Then you can use a splitter[/url] and a little...

I wasn't aware there's a maximum length of script for the Execute SQL Task. What is it, as a matter of interest?

One alternative is to set up a central...

I only mean that you should do that as a one-off, in order to discover the ASCII number. Once you've discovered it (let's say it's 99), you can do...

Perhaps a variable in that part of the OPENROWSET clause isn't supported, although I can't find that documented anywhere. You may have to use dynamic SQL instead. Beware...

I don't know whether this'll work, but it's worth a try. Do it on a test server, not in production. Find a row in the table that contains...

Here are a few things I'd consider:

* Can you ping the target server from the computer the package is running on? If not, the server may be down or...

Think of it as rearranging the books on your shelf so that they're in alphabetical order. Because each book is now in a different place, that counts as a...

I'm sorry, but I still don't understand. Please will you post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements and...

I don't know enough about SSRS to know whether that's possible. But if it isn't, you could try using SSIS instead.

John