I'm learning how to make SSIS packages. My first three jobs are all data imports from Excel spreadsheets.
Two of the three files were created in Excel 2007. SQL Server Business Intelligence for SQL Server 2005 cannot recognize .xlsx files. In order to set up data sources and data connectiosn in BIDS, you will have to save the file as an older format .xls file.
No comments:
Post a Comment