Hi, thanks for the reply.
we originally were using a script to pick up the files and build staging tables based on the file content and then use bcp to load them. If the file layout changed, we could handle it easier once it was in SQL.
have had a rethink and we going to use SSIS data flow going forward. if the files change, to bad, their fault.
MCITP BI Specialist