We currently receive a multi-hundred column flat file from a vendor, and the tech prior to me had created an import specification in Microsoft Access to automatically split the file into the right fields based on field length, properly formatting dates and such, etc etc.

As I'm migrating this data to SQL Server, is there any quick way to migrate the stored import specifications from Access to a SSIS package without completely recreating it? Since it's a file based on field length rather than a CSV, it's quite a process to recreate from scratch due to the file size, so figured I'd check if anyone is familiar with an automated way.

| improve this question | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.