What is the best way to import tables (Total 7) from Access databases into one SQL table. I am using SSIS and created a connection to each of the databases. Not all of the tables have the same columns. Each import has its own container - with sql tasks and aggregations. Problems with the data types converting - so instead importing into temp table with char datatypes - then inserting the data into the sql table. Is there a better way to do this in SSIS? Also, need help with counting the records imported and date of import in ssis and exporting to Excel. thx bb
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.