Content

• Video Tutorial
• Step-By-Step
• Properties
• Setting UI
• See Also
• References

Video Tutorial

Step-By-Step

1. Before we get started, We need Password credentials of the Excel file if it is password protected.
2. Download and Install SSIS ZappySys PowerPack.
3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
4. Right click on Connection Managers Panel to Create New Excel Connection for Excel File, and Context Menu will appear, Select New Connection from the Context Menu.
   
5. Select ZS-Excel Connection Manager from the Connection Managers list and Click on Add Button.
   
6. In the opened Excel connection manager window, set the "Source Path" with the file name and the appropriate extension. This will be useful for reading from and/or writing to the single Excel file. To read the multiple excel files using Excel Source component, you can use the Pattern approach in the Excel Connection Manager.

   NOTE: The Pattern is only applicable for the Excel Source, you can't use it in Excel Destination component.

   

   NOTE: If you want to operation with multiple files then use wildcard pattern as below (when you use wildcard pattern in source path then system will treat source path as folder regardless you end with slash).
   
   Examples:
   c:\SSIS\Excel\file123.xlsx (single file).
   c:\SSIS\Excel\file*.xlsx (all files starting with name file).
   c:\SSIS\Excel\subfolder\*.xlsx (all files with .xlsx Extension and located under folder subfolder).
   

   
7. Click on "Test Connection" to check if the configuration is correct or not.
8. Click "OK" to save the Excel Connection configuration settings in the UI.
9. Once you have finished, you will see the Excel connection in the Connection Manager panel.
   

Properties

Setting UI

See Also

• SSIS JSON Source Connector
• SSIS Export JSON File Task
• SSIS MongoDB Source Adapter
• SSIS Azure Table Storage Source Adapter
• SSIS Amazon S3 Storage Task
• SSIS Amazon Storage Connection Manager

References