February 18, 2009 at 2:42 pm
You are right. That is what I am doing it creating the new ssis package on the 64 bit server. I feel like we are so close.
If I try to query the table in access that is linked to sharepoint I get an ISAM error.
If I query the table that is not linked to sharepoint, it is successful.
This makes me think either 64 bit was never the issue, or with they steps you have helped me take, we are past the 64 bit issue.
I guess the question would be, why can I not query that table.
There is no security on the access database file. There is an "admin" user with no password, but I think that is default and required.
February 18, 2009 at 2:57 pm
No we are not because using Sharepoint list require an adpter so you should have added that and I would not have spent a whole day trying to fix platform problem when it is not related to platform. Here are the links and start a new thread at the Sharepoint general forum at MSDN.
http://www.codeplex.com/SQLSrvIntegrationSrv/Release/ProjectReleases.aspx?ReleaseId=17652
http://msdn.microsoft.com/en-us/library/dd365137.aspx
Kind regards,
Gift Peddie
February 18, 2009 at 3:06 pm
Again, my source is the access table. The table may be linked to sharepoint, but it is indeed still an access table. I am not attempting to link directly to sharepoint.
Also, again, when this package is created on a 32 bit server (event if sms is connected to the 64 bit when it is created) it work.
But when ran on the 64, it does not.
February 18, 2009 at 3:29 pm
it is an access database linked to a sharepoint list.
When last I checked a SharePoint List is a reference type so again I will not tell person with a reference type as one of the points in the connection to use ODBC or OLE DB because a reference type needs ADO.NET provider. And please start a thread at the Sharepoint general forum so Sharepoint users can help you.
http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneral/threads/
Kind regards,
Gift Peddie
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply