SSIS gets my vote as well...

If your FTP server is robust enough, let it drive the workflow. Otherwise, build a simple .NET service to watch the incoming FTP directories,...

I've written quite a few SSIS packages to import/export flat-files to/from SQL Server 2005, but I don't recall receiving that error.  Googling it, I found this info:

DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE - The data...

The reason some of my DB's we're greyed out is because they contain multiple files, which the app doesn't support yet.

Thanks for the great app and resource page!

Any idea why some of my SQL Server 2005 DB's show up grey?  They are online and I can query them...