question

Dulshanka avatar image
Dulshanka asked

How to load Excel data dynamically using SSIS to OLE DB destination?

I have a scenario where I have to load data in Excel sheets to a database dynamically via SSIS package. Also I need to access and load each excel sheet of a single excel file separately
ssissql-server-2012exceletldata-warehouse
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
@SQLShark avatar image
@SQLShark answered
One option would be to have a process loop though and save each sheet as its own file maybe a CSV with a pipe delim. The load each row as a single value in to a table. Then using an SP process the rows and load them where they need to go based on your logic.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.