I am using SQL 2012, with the 2012 adpator (installed on VM that i am building the package on where the server also resides). I've built my package in Visual Studio 2010, when i execute the package in studio, everything works fine. When I try and schedule
the dtsx package, i get the following error below:
"This occurs when CPackage::LoadFromXML fails".
Any thoughts around this? I've tried multiple things:
create a proxy to make sure the sql agent can pull the data out of sharepoint (has permissions)
force it to run in 32 bit (someone in browsing google suggested this)
formatting of dates; i excluded dates to test
Ultimately, the above error is what I keep getting. Thoughts? It's driving me nuts, since I have a lot of lists that I need to automate and I am hoping i don't have to kick the jobs off manually everytime.
I am using sharepoint 2003.