DTS Package Help Needed

I'm thinking this is two DTS packages: 1) Based on Batches that are separated by a "COPY" selection flag. A Sales Document has a UserDefined1 field that is automatically copied from the Payment Terms ID field from the Sales Document (I already have the update statement for this). 2) Based on an APPROVAL flag in a database table (I already have this defined) which by default is 0 and 1 if checked in the UI, a trigger will fire a DTS package which will run a query and send this query as a flat file (.csv) to an FTP address. Naming convention will be something like ABC_Inv_Batch_(current date). DTS PACKAGE is to run daily at 1:00 am pst. Notification if job unsuccessful. 3) Need to flag the docs as having been sent: If the UserDefined1 field is approved (=1) and does not have a value of "YES", and "YES" to this field after the DTS package has sent the file. 4) Import the return flat file from the other party from a predetermined file location ([INVOICE#], [ITEM#], [QTY], [SHIP DATE], TRACKING#]) into a SQL table named "ABC_transfers". DTS PACKAGE is to run daily at 1:00 am pst. Notification if job unsuccessful. 5) There are two fields in other tables that will need to be updated from two fields in this flat file: [TABLE 1].[SHIP DATE], [TABLE2].TRACKING#] 6) Update the BATCH NUMBER in our sales table: Query already done. 7) RESET transactions in a main system table: Query already done. I have all the queries, just need help with triggers and DTS packages. Not sure how to FTP flat file from DTS package. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP Professional, SQL Server 2000