We have a DTS package located on SQLSERVERNAME.
To access it we have LOGIN / PASSWORD for this server.
we have a file we FTP to our harddrive FILE
DTS package does the following:
1) delete data from 1 table in DB
2) update with information from FILE
I need to have a small .net application that will allow to execute DTS without going to Enterprise manager.
if we can have an ability to automate FTP with 1 click, that would be excellent too.
This is what I imagine:
user enters login info for FTP, click get file and it is saved to designated place.
then he has to enter login / password for DTS and click "update file" and database is updated.
i don't know if this is possible, please provide some light.