Validation Error. SharePoint URL has not been set.

Jul 29, 2010 at 2:16 AM

After adding Data Flow task and SharePoint List Source to package I set the parameters but get following error

Error 1 Validation error. Load SharePoint List Data Get Cosmo BAL Archive: SharePoint URL has not been setPackage1.dtsx 0 0 

The data connection is using integrated security (SSPI) and i am admin on both dev box and SP server (wss 3.0).  Any ideas as to what may be causing this error

Coordinator
Aug 3, 2010 at 6:31 AM

This might be a silly question, but did you set the sharepoint url? :)

Check out this url and make sure all of the parameters are setup (and that you have a spcred credential if using the beta one)

http://msdn.microsoft.com/en-us/library/dd365137.aspx