anjon

What type of trouble are you having? Is your xp_cmdshell set up and using he correct account?

This really sounds like a very basic homework assignment. Post the code you have written so far and I'm sure someone could help you tweak it if needed. ...

In SQL Server, you can accomplish this via SSIS/DTS. You can also do this via excel by querying the database, to include writing some VBA code that allows spreadsheet...

First ensure xp_cmdshell is enabled (you can do this under the surface area configuuration).

Next make sure that the account SQL Server is logged in as has access to...

I think I see your issue, you have a local drive that you want to back up to, yet, your SQL Server database is on a Cluster that does not...

Soapbox time...Please all DBAs. For your security, perform a backup of all databases as soon as they are created. It's just a good best practices thing to so....

take a look at this script, it should teach you all you need to know about copying and moving files over the network.

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/

Here is a good web source as well

http://sqldb.wordpress.com/2006/06/21/dynamic-sql-in-sql-server-integration-services-ssis/

daJonx

I understand your issue, however, it would be very hard to get you to the right area without being in an IM chat or conversation as I'm thinking you would...

On the dynamic connection, think script task. That should enable you to set the connection dynamically.

What you are attempting to do is use dynamic SQL. The best way to do that is to create a variable and then using that variable, set up your...

Well, being on a State government project, money always come up and you have to make do with what you have. That's why, with money as an issue,...

I like 7zip. It's freeware and command line oriented. It handles large files very well.

Hope this helps

Try this. Create a new variable with this expresion

"select replace(convert(varchar(8), getdate(), 3), '/', '') " + @[User::Filename])

Then on the properties section of the newly created variable, set...

Michaels answer is dead on. You should probably lean towards the script task as it will provide better control over the message and/or attachments you may need in the...