Đang Thực Hiện

149497 script for remote DTS

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.

Kĩ năng: .NET, Bất kì công việc gì, SQL

Xem nhiều hơn: enterprise net, net sql script, net file manager, script automate, file manager script, execute sql script, script sql table, remote access script, sql server update file, access sql server ftp, remote database, ftp sql table, remote file access, remote login script, small package net, remote execute, user manager remote server, harddrive, server manager ftp, automate ftp, remote application access application, update table net, need remote, net application ftp, sql light

Về Bên Thuê:
( 47 nhận xét ) roswell, United States

ID dự án: #1895676