Hi,

All the column need to be considered varchar. As we doesn't have an access to ssis we couldn't able to access the FTP file directly from backend.

So, Do you guy's...

Hi,

Consider all the fields as varchar. As we doesn't have an access to SSIS we will be unable to do this.

Do you guy's think that copying the csv/excel...

Hi,

This problem arise because we didn't able to read the excel / csv file from ftp location.

From local server I can read excel / csv file using openrowset function.

So, Now...

Thanks

Thanks for your suggestion.

Can you just help me to create a batch file

I tried following code:

ftp 3.104.85.96

username

password

get filename

Its opening the command prompt but its asking the username and password.

How to...