You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2014-07-09 16:05:59

susht
Member
1 post

susht said:

Please suggest

We have data in excel file which updates weekly. This excel file is imported every week to SQL server table using SSIS(Sql server integration services). The problem here is the excel columns gets deleted /added sometimes and also the columns gets re-named. So instead of manually mapping the ssis package when ever my excel sheets changes is there any way it can be done automatically?
The scenario that if new columns are added then the column should be inserted in sql table and if it is renamed it should map correctly and if the column is deleted then nothing should happen.
I am looking for a good tool which does this? Feels like talend software works for me?Please suggest.

Thanks

Offline

#2 2014-07-09 19:31:21

jlolling
Member
3186 posts

jlolling said:

Re: Please suggest

You can use Talend and the component tFileExcelSheetInput from Talend Exchange. This column allows to setup the column position based on a header line and the header names can be searched with regularly expressions.
http://www.talendforge.org/exchange/ind … &nav=1,1,1
Take a look into the documentation.


Talend Certified working for cimt objects AG in Berlin

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy