Based on the replies to this point, I would have to think that it should not make one difference how you perform the backups if they are going to stay...

Make sure the IUSR_ account has full control to that folder. Or, if that doesn't work then you need to find out what account is running IIS and...

Thanks RBarry! I will give that a shot.

I would really post this on a 2000 forum somewhere. This is a 2005 forum discussing backups.

you left that important detail out. I haven't done too much recently with 2000, but i can't see why you couldn't use a bulk insert, but you'd still have...

This question is more for the SSIS forum than the backup forum.

High level will be:

-Create two connection managers inside you ssis package. 1) connection to SQL, 2) connection to a...

To add- you can install the components separately and when you go through the SP2 setup the second time around, it should already see that SP2 was already applied to...

Glad to help!

Create a global package variable called "strSQL" as a String. Put a value in it that will parse against the connection and provide the columns you are trying to...

The way I have done this was the following:

1. set up a package variable, something like "fileFound" as an int

2. set up a script task to look for the file...

Thanks!

That is close to what I'm looking for on page two of that discussion, but that is also scripted for SQL 2000, and it takes the parameter of a database...

I'd have to agree with Steve Smith. You need to present the argument in a monetary sense. Point out that if a database file had to be moved...

You can use an expression on the query for the oracle connection. Programmatically, you can construct the query you wish to run via script tasks, and then in the...

Most of the problems people are experiencing with using the FTP task here have nothing to do with the FTP task settings. I suggest that everyone look up the...

I would use master.sys.databases (sql 2005 system view) instead of master..sysdatabases which is only included for backward compatibility in sql 2005