• I use SSIS for everything. There is just about nothing that I cannot do. Especially with SQL 2005. I can move files around, create directories. You can also do the same thing with DTS, just using SSIS is now easier.

    And the best part, it is all free. Everything comes with SQL Server, of all versions. use one version, I would use SQL 2005, to do all the work. It has no idea what version of a SQL file it will be dealing with when moving files

    Andrew SQLDBA