yes i am raelly sorry.For my earlie post.We need to use script transformation for reading the numbner of column.On that basis we can do the logic.

Use this Query

SELECT dbo.cardholder.c_fname AS [First Name], dbo.cardholder.c_lname AS [Last Name], dbo.cardholder.c_nick_name AS [Emp Id],

dbo.badge.b_number_str AS [Card No],(CASE WHEN ISNULL(LTRIM(RTRIM(dbo.badge.b_disabled)),0)='1' THE 'YES' ELSE 'NO' END) AS [Disable Sts],...

Hi,

The Simple logic for this Package is that While reading data from flat file use row count transform.After Reading data from flat file using data flow task.Use expression in...