September 4, 2008 at 9:00 pm
I have one SSIS Package but I have some problem with data source. I want to make secure sharepoint site as a SSIS source. All the source files comes into sharepoint site very often. I have given that link as a Sourcefile in SSIS package but when i run the package it gets the data from that site but I have to give the username and password manually for that site. I am planning to schedule this package but I cann't do this because of that username and password which i have to give every time the package run.
I am planning to write some script task in VB.Net for this security credential but I have no idea at this time. I want to write some code which dynamically pass that credential to sharepoint site so we don't need to give it manually each time.
Please help me with the VB.NET code in script task or please give me any other way if you have.
Thanks,
Ketan
September 5, 2008 at 12:55 am
I am assuming that you know what the VB.NET script fundamentally would look like (my forte is definitely not VB.NET). Sure if you google accessing a sharepoint site via .NET you will hit paydirt.
However, on the SSIS side, add the respective variables (i.e. varUserID, varPWD, varSiteName). Pass these in a .NET scripting task, and you should be able to connect.
Now, for some portability, add package configurations, which means that you can control the authentication to the site in various environments seperately.
Good luck
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply