News

1. Package Description This code presents a template to dynamically extract tables from Excels stored in Sharepoint onto SQL Server tables, using a SQL Server Integration Services (SSIS) package. It ...
64-Bit SSIS and 32-Bit Excel Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime. By Eric Johnson 06/21/2010 As much as it can be a ...
Extract-and-Load-Flat-files-using-SQL-Server-Integration-Services In this project Mutilple flat files where extracted from one source and loaded into SSMS Database tabele using sql Server Integration ...