Say today sharepoint list has got 3 columns as below. These three columns needs to be populated in SQL table which has to be created at run time.

C1 C2 C3

A   UK  1

B   US  2

C   JP  3

Tomorrow sharepoint list might have 5 columns as below. These five columns needs to be populated in SQL table which has to be created at run time.

C1 C2 C3 C4    C5

A   UK  1   Yes  No

B   US  2   No   Yes

C   JP  3    Yes  Yes

Please note there should not be any manual work involved in this process. Whatever code we should be writing that should work for any no of columns on given day.

Please let me know of any solution.

AFAIK you will not be able to achieve that as the only way to have your changes captured is having the package produced dynamically in code, but the SharePoint list component doesn't expose programmability.   

Hi,

Pull all the data into XML File using Script Task --> Generate XSD file at run time using Execute Process Task --> using XML Source load the data into destination.

Note: Only major issue is how to do column mapping at run time 

You can try this.. I'm also working on the same issue.. Will let you know if needed any further changes.

Best Regards

Parth Patel 

• Edited by Parth..Patel 14 hours 15 minutes ago