shwelopo
asked on
Input files
Working on SSIS package that currently accepts non fixed files. Have to make it able to decide which one is it and what to do depending on whether it is a fixed or a non-fixed. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>decide which one is it
It's possible to create a ForEach File Loop, read the file name, and then send it to an appropriate data pump based on the interpretation of that file name to what the schema is. afaik it's not possible for SSIS to read a file, then interpret it's format.
>what to do depending on whether it is a fixed or a non-fixed.
Define 'what to do'. Without a definition, no idea what that means.