This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 13%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
I have a excel source with following fields:
I want to create table dynamically with First 4 rows having column name, data type & length. Eg for Decimal its (10,2).
Then import data from excel to SQL database with Data starting from Row No. 5.
How do I achieve the same?
Any help is appreciate.
Thanks
That's not really possible in SSIS using build-in tasks.
The only way would be a .NET script task with a lot of .NET (C#/VB.NET) programming.
Hi @Anjali Shah ,
You may use Script Task to create table and load the data to the table.
Here is a similar blog you may have a check.
http://www.techbrothersit.com/2016/03/how-to-create-tables-dynamically-from.html
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hey @ZoeHui-MSFT
Below is the link to the excel source file.
EUVwndvJuvlGrpxAMcWBA88Bddxe3bF0NO76Z2g_qkAEaA
It would be great if you can help!
Thanks.
Do you mean that you want to read the datatype from the excel and then create the table dynamically in SSIS? If so, I think it will be a bit hard to meet your need. You may convert Data Type with Data Conversion Transformation and then load the data to table with new table in OLEDB destination and the table will be created with the matched type.
@ZoeHui-MSFT Yes I want to read column names and datatype dynamically from excel and create table. Is it possible to achieve the same using script task?
@Anjali Shah , I'm not familiar with C# code writing, as far as I known, you may use the C# code to read the data from the excel and then try to create the table. Code writing is out of my ability. You may also raise this issue to C# side so that the experts could give you more professional advice.
An example code you may take a reference:
http://www.techbrothersit.com/2016/04/c-how-to-create-table-for-each-of-excel.html
Is it possible to achieve the same using script task?
As @ZoeHui-MSFT and I already wrote, yes, with a .NET script task it would be possible, but that's really a lot of programming work; don't expect us to do your job.