Lee,

You're welcome.

The only two places I recall seeing that mentioned were either in Inside SQL Server or a blog entry on sqlskills.com.

Your understanding is about the same as mine.

However, one full database backup is required before the log chain is started.

Does Secure Copy support removing files? You might be confusing Secure Copy(pscp) with the Secure FTP client (psftp).

As far as the date and time...

The attached zip file contains a document with some more detail on each of those steps.

Just keep in mind there are other ways of storing and displaying images, this is...

If the SFTP server doesn't support that command then you're left with getting the file, putting the file back in the new location, then removing the file from the original.

I...

On the Send Mail Task set the DelayValidation property to True, the default is False.

You might be looking for the mv command.

The documentation on the PuTTY website has many examples: http://the.earth.li/~sgtatham/putty/0.60/htmldoc/Chapter6.html#psftp

Nope, no examples. But if you post what you've done I'll look at it.

Look at using the Execute Process Task on the Control Flow canvas.

First, you should get your SFTP command working outside of SSIS the way you want, then transfer the commands...

What command(s) did you use to try and shrink the log?

You might want to have a look at this: BOL: Shrinking the Transaction Log.

You're right. Thanks for pointing that out.

Edit: SQLCMD, while not included with SQL 2000, does work with SQL 2000 and...

From the command line you could use SQLCMD. Variables can be used with SQLCMD too to make it more flexible.

For example, to import Table1 from the db1.mdb database to...

The good news is your SMTP Task is talking to an SMTP server, that error message is evidence. But it may be talking to the wrong SMTP server for...

Can you show some examples of how you're calling usp_Get_Street_Info and which ones do and don't work?

From what you've provided, if you passed in a NULL for [streetaddress], or one...

These two catalog views should show that.

SELECT * FROM sys.views

SELECT * FROM sys.procedures