DTS from Web server

I want to create a DTS package which will import a text file from my web server to SQL server. This is not a one shot deal. I will be executing this package from within a stored procedure on a consistent basis.

Is creating a DTS such as this possible within your environment? Do the user accounts on the SQL Server have read access to the webservers? If so what is a sample UNC path?
My sql server is mssql01 and my webserver is web136.

Thanks for any help you can provide.

 

Betts said...

I want to create a DTS package which will import a text file from my web server to SQL server. This is not a one shot deal. I will be executing this package from within a stored procedure on a consistent basis.

Is creating a DTS such as this possible within your environment? Do the user accounts on the SQL Server have read access to the webservers? If so what is a sample UNC path?
My sql server is mssql01 and my webserver is web136.

Thanks for any help you can provide.


DTS packages must be created from within SQL Enterprise Manager.

The SQL Server does not have access to the webservers.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET