Thank youm, i have done.

create table fstlst(name varchar(max))

insert into fstlst values('raja rao')

insert into fstlst values('mohan raj')

insert into fstlst values('sachin tendulkar')

insert into fstlst values('gowtham gambeer')

insert into fstlst values('veerndar sehwag')

select * from fstlst

select LEFT(name,1)+substring(name,CHARINDEX(' ',name,1)+1,1) from...

Hi,

Be check with wether the server where the file located credentials given properly or go through some steps below...,

1) ftp task loging or not

2) ftp task wether the related file...

i haven't schedule, even i couldn't come up with how to schedule the package.

i have a package but how to schedule the package.

at that time i am getting doubts in...

Hi,

Actually i am having one requirement i.e

i am running some scripts that are scheduled by sql server agent and generating some files and loading that files into some path...