long input file name validation
I am working on a data migration project, where data is getting transfered from csv file to sql tables using ssis package. Should there be any restriction on number of characters for the input csv file name. If I concatenate the file names with date time, file name will have more than 50-60 characters. Why I am saying so, because at one place I am doing file name validation. Can u plz provide ur suggestions? SandyLeo
October 28th, 2010 12:09pm

No problem with filename validation as far as length is concerned. You can easily compare the filename with some other value for validation purpose.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 12:20pm

Your only limitation inside SSIS is a "soft" limit of 4000 characters due to expression handling. But you can use Scripts to get around even that. Talk to me now on
October 29th, 2010 1:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics