For the purpose of our example, I am creating a text file, which holds the name and address information of the Applicants of Credit Cards.

The text file attachment can be found at the end of the post.

Since we are creating the table at run time we are making use of this property.We have covered the export/import techniques from SQL Server, Oracle and DB2 LUW in several of our posts – this one concentrates on building up a SSIS package to achieve this task.