I need to develop a simple DTS package that runs in SQL 2000 for exporting a table into a CSV file, zipping it, and uploading via FTP to a remote server where SQL 2008 is installed. The DTS package will also trigger an SSIS package that will unzip and import the text into a table… (Budget: $30-$250 USD, Jobs: SQL)
