tag:blogger.com,1999:blog-4762425244190648087.post5471737375202766837..comments2010-03-31T21:17:26.479+05:30Comments on SQL Yoga: SQL SERVER: SSIS - Derived Column Data Flow Transf...Tejas Shahhttp://www.blogger.com/profile/04041260304854571049noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4762425244190648087.post-35053140761478815542010-03-31T20:26:13.815+05:302010-03-31T20:26:13.815+05:30Nice article, thank you jamiet for the info on Fil...Nice article, thank you jamiet for the info on FileNameColumnName propertyBI_Buffhttp://www.blogger.com/profile/06254495164438608712noreply@blogger.comtag:blogger.com,1999:blog-4762425244190648087.post-90051273219802558842010-03-30T17:13:39.432+05:302010-03-30T17:13:39.432+05:30You could also use the FileNameColumnName property...You could also use the FileNameColumnName property of the Flat File Source Adapter to get the name of teh file. Saves all that messing about with variables.<br /><br />Read more: http://msdn.microsoft.com/en-us/library/ms135923.aspx#flatfile<br /><br />Regards<br />Jamiejamiethttp://www.blogger.com/profile/17205835704950108652noreply@blogger.com