Hi Friends! I am facing a real problem on accessing ftp site over DTS. I have created FTP site in IIS with following details: Allow Anonymous Connection : checkbox checked Username: METALINK/chandrajits ---> First one is domain and second one is windows user name. This is a NT user in which I am working. My os is Win XP professional, IIS is installed in my machine. My system is connected with windows 2000 server where NT users are defined. Password: ****** ----> Given password is the same password for above NT User. Default FTP Site: IP Address: 192.168.1.4 TCP Port : 21 Enable Logging: Checked Username and password are the same as given above. allow anonymous connections: Checked allow only anonymous connections: Checked allow IIS to contril password: Unchecked Name of the virtual Directory: chandrajits Actual folder path: F:FtpFiles when I am accessing ftp sith in browser with following URL: ftp://192.168.1.4/chandrajits or ftp://localhost/chandrajits its working and shoiwing the files But I have created a DTS package with File Tranfer protocal Task, where source URL:ftp://192.168.1.4/chandrajits (ORftp://localhost/chandrajits) Username: METALINK/chandrajits (OR chandrajits) password: ********** -----> same password as I used for 'chandrajits' during windows login. its showing one error given below: Unable to Connect to Internet! Please Check the Source Site Information, Your username and password. Please help!!! My all works are stopped because of this. Regards, Chandrajit Samanta, MBM(Systems), B.E.(Electrical), Sr. Programmer, Metrica Systems, Bangalore, India, +919986044300, chandrajit.samanta@gmail.com
THis is something access to the internet from SQL server, ensure the SQL services has relevant privileges to access FTP on the server. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.