Posted on 2009-04-03
i am trying to find out first part of my filename is numeric or not using followed function
DECLARE @filename varchar(100)
SET @filename = ?
SELECT isnumeric(substring(@filename, 1,(charindex('_', @filename,1)-1))) AS result1
when i give the filename directly and check it works well in SSMS,but when i pass the file name through an input param in SSIS it fails..any help appriciated..