Sorry it was a mistake. I actually mean FST.

NO create file operation in FST.

Thanks

Thanks for the reply.

How can I create a file using FTP task there is no operation called Create file(create file is in source connection).

Thnaks in advance

But after inserting in to rejects, the inserted rejected record no longer should be in Table1.

Any Ideas?

I tried solving using OLE objects this time.

Created a procedure called validateheader to validate the header of each file with a template file.

create table validate_table (validate varchar(max), FileName1 varchar(100),FileName2 varchar(100)...

Thank you SSC Veteran. This works. Thanks a lot

Or

I need to have a code that will go into the txt files and see if the first row being a long string is exactly the same to 'Title Forename...

cAN YOU PLEASE ALSO ADD THE SCRIPT WITH THIS TEXT VALIDATION IN THE CURSOR ? AND ALSO SLIGHT CHANGES IN THE REQ, NEED TO MOVE THE VALID FILES TO THE...

Script working gr8 but where should I perform the validation?

My task is to validate which files contain the header as

Title Forename Surname FullName JobTitle Department Organisation Address1

and move that...

Thanks for the script eralper, let me see if I can work this out with the given script

No thers isn't any actually. I am new to sql and ssis.

I migrated the data from these flat files in to another flat file destination using SSIS, but no...

Can you help me in providing any T-sql code for it.

I got a set of txt files. Each file contain different header(Firstline of the file)

for ex:

"Title""Forename""Surname""Full""Job Title""Department""Organisation""Address 1" - textfile1

"Title""Forename""Surname""Full...

Thanks for reply. But I got read a set of files from the folder but not a single file