Are you sure you have the proper SMTP server address?

Check with your messaging team. They might have more details on the nature of the error or be able to help...

When you say that you're getting the error, is it an error that's stopping you from running your job?

If not, then I think it's more of an informational message. You...

I'm glad you like it. Good luck with your new career! @=)

That's a good question. I'll check.

I have a sneaking suspicion, though, that there's something in this scenario that the BU in question isn't telling me. Something outside of SQL Server...

Actually, Grant, I didn't know about this Template scripter. Could you give me that too?

I was going to make due with what I had, but I'd like to look at...

David's information worked.

I had to create a trace in Profiler with the Template in question (it was a homemade Template). I paused it and scripted it out. Looking at the...

Thanks for the link, David! I'll check it out ASAP.

Nope. As I said in my last post:

Brandie Tarvin (1/5/2009)

---

Also, the ShareFolder name is different between the two UNC...

Actually, now that I'm examining your code, I don't think that will work for me.

What I've got is this:

\\SourceServer\ShareFolder\DB1\DB1_db_200812011600.bak

\\SourceServer\ShareFolder\MyDatabase\MyDatabase_db_200812011700.bak

\\SourceServer\ShareFolder\TempDB\TempDB_db_200812011200.bak

And all files should be copied as:

\\DestServer\DiffShareFolderName\DB1_db_200812011600.bak

\\DestServer\DiffShareFolderName\MyDatabase_db_200812011700.bak

\\DestServer\DiffShareFolderName\TempDB_db_200812011200.bak

Notice the missing subfolders. Also, the...

You say you use the string to add a folder. What happens if the folder is already there? Does it overwrite or delete & re-add?

Okay, then.

Off the top of my head, I don't know of any issues between Terminal Services and SQL / SQL Express that would require one to be installed before the...

You need to throw a Try - Catch in the script task so it throws an exception, than write the error to your job log file.

Use the following in your...

Nevermind! My problem isn't a security issue. I forgot to write out my path variables in my Script task so the File System Task could find the source &...

Stephen,

In my experience, applications that use SQL Express usually include SQL Express in their install package. You might want to contact the app vendor to verify this before you go...

There is no common list like you're seeking. That's why the phrase "least privledge" is used, because what one person does with their code isn't necessarily what other people use.

I...