Boss has just given me a CD with about 50 Excel Spreadsheets to import into the SQL Server.
Spreadsheets are all named A1, A2, B1, B2, C1, C2, etc, for each letter of the alphabet (the remaining ones, are irrelevant).
I'm creating an SSIS Data Flow package to import the contents of the Spreadsheets, but rather than do this 48 times, is there a way of importing a 'directory'?
All Excel spreadsheets have the same column headers, so no problems there, and they are all going into one table.
Did think of having one large Excel Spreadsheet, but there's about 4.8million records, so goes way way way over the 65536 row limit of Excel.
Any thoughts, or am I gonna have to do individual flows?
Spreadsheets are all named A1, A2, B1, B2, C1, C2, etc, for each letter of the alphabet (the remaining ones, are irrelevant).
I'm creating an SSIS Data Flow package to import the contents of the Spreadsheets, but rather than do this 48 times, is there a way of importing a 'directory'?
All Excel spreadsheets have the same column headers, so no problems there, and they are all going into one table.
Did think of having one large Excel Spreadsheet, but there's about 4.8million records, so goes way way way over the 65536 row limit of Excel.
Any thoughts, or am I gonna have to do individual flows?