Load Excel data into SQL Server using SSIS without Creating tables in the target

Question

I am new to SSIS and am not sure if this is possible to upload Excel data into SQL Server without creating table schema, where the Job automatically creates the table schema according to the source file? I used to do this using SAP Data Integrator with Template table component and I am not sure if there is a similar functionality in SSIS

bobs · Accepted Answer · 2011-03-04 00:33:33Z

1

There is no capability in SSIS to interpret the structure from the source file and create the table schema. You can create tables as part of the SSIS control flow, but the data flows that load the data are very fussy about knowing the source and target structure at design time. In other words, it doesn't handle dynamic structures very well.

answered Mar 4, 2011 at 0:33

bobs

22.3k12 gold badges71 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TamusJRoyce Over a year ago

I guess a script task is the only way. But SSIS does have the ability through writing code.

Collectives™ on Stack Overflow

Load Excel data into SQL Server using SSIS without Creating tables in the target

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related