Hi,

I am using Sharepoint source and sharepoint destination in ssis to execute a package which will update sharepoint list.

Every thing is working fine. I have scheduled a job for this package which will execute every day which will update sharepoint list every day. Now in sharepoint source and destination, we need to provide sharepoint list name, view name and site url. But i want to make it dynamic.

So how can i make these variable dynamic, otherwise i need to update these parameters all the time if i have any kind of updation in site url. Is there any web config file where i can submit my site urls and other parameters?

Please suggest how can i acheive this functionality.

Thanks in advance!

Regards

Rajni

Hi Rajni,

If you use the SharePoint List Source and Destination from codeplex, I suggest you contact the solution author.

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

Or you can customize the code with the source code below:

http://sqlsrvintegrationsrv.codeplex.com/SourceControl/latest

Best Regards

Hi Dennis,

I am not getting your point,what you want to say with these links.

It would be great if you will provide some more detail.

Thanks 

Rajni

Do you want to send the variables to the ssis package or should the ssis package reads some values from somewhere on start?

Hi,

It can be any thing. I just want to make these fields dynamic some how.

Could you please explain these both methods if you have idea about it.

I am new in SSIS. So it would be great if you help me out for the same.

Thanks & Regards

Rajni