Ssis package not updating database
Rob Sheldon calms your private doubts and fears by answering those embarrassing questions. If your SSIS package retrieves data from an Excel workbook, you need both the connection manager and the source component.
2- Create another OLE DB Source for destination table.The System Administrator of the SQL Server instance needs to create the Catalog or a user with elevated permissions for creating databases. Some configuration takes place during its creation.Figure 1 shows the menu after right-clicking on the Integration Services Catalog folder in SQL Server Management Studio (SSMS). CLR Integration will need to be enabled on this instance.The job of retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as, for example, performing heroics with ill-performing queries.This could be why one hesitates before asking questions about how to do it.