February 21, 2007 at 6:37 am
In a DTS package i have created 'File Transfer Protocol Task' which downloads the data from a site. (Eg: http://www.sitename.com/filename.xls) Into a local drive.
FTP property is
Source: Internet Site
FTP Site: Eg: http://www.sitename.com/filename.xls
Username: a valid username
Password: a valid Password
Directory Path: C Drive:\Myfolder
When i try to run the package I get the message:
'Unable to connect to internet! Please check the source site information, your username and password.'
Are there any other settings, configurations to run this? Are there any other reasons to get the above error message? Is there a solution to solve this?
I'd really appreciate your help, Thanx in advance.
February 23, 2007 at 12:29 pm
Don't specify the file name in the FTP site address.
February 27, 2007 at 12:43 am
There are many files existing in this site
Like: http://www.sitename.com/textfile.txt
http://www.sitename.com/htmlfile.html
http://www.sitename.com/filename.xls
So, it is required to specify the filename right.
Basically, i need to download the data in the excel into the sql server table using a DTS
February 27, 2007 at 9:09 am
The site name is the address. There's a "Files" tab where you specify the file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply