Hi all I have addedd the Derived Column and added the New column name

In that what Expression i need to give for getting the FIlename Date

Like ''ACTEST00001_20141111_0408_SV_APPT.Txt'' this is...

Ok i have added the Derived column and what Expression i need to give ..

No it was running perfectly and after adding the new column into the database i got error.

I have added by going to DataFlow Task -->Flatfile Source -- >Right Click Show Advanced Editor-->

Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have five the Column Name as...

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202091. The component returned a failure code when the pipeline engine called...

[SSIS.Pipeline] Warning: The output column "FtpDate" (598) on output "Flat File Source Output" (6) and component "Flat File Source" (2) is not subsequently used in the Data Flow task. Removing...

Actually U got my problem right ??

To do the entire process.. I tired as u told but its getting same error.

Hi pls can any share any videos regarding this because i am new to this process.

Hi Phil,

Thank you for your Reply.

I will calculate the columns FTtpDate from the file name and the Filename will be like this format

''ACTEST00001_20141111_0408_INV.TXT''

''ACTEST00001_20141111_0408_SL.TXT''

''ACTEST00001_20141111_0408_SV.TXT''

''ACTEST00001_20141111_0408_SV_APPT.TXT''

And we have details in this files.

But...

Can u pls explain more clear .!!