SSIS - Can I get the column schema for a flat file source from a database?
- by Steve Clement
We receive a nightly data export from a vendor in the form of about 10 tab-delimited flat file without column headers. In addition, the vendor provides us with the SQL scripts for the database tables so that we can import the files into our system.
Unfortunately, the vendor recently changed the schema for the flat files. Each file has upwards 150…