Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
infodemers
Posting Yak Master
183 Posts |
 Posted - 2014-01-22 : 09:48:08
|
| Hi all,I have a linked server to an MS Access file.I wish from my SQL instance , run a store procedure to execute a data definition query in the MS Access file. Basically I want to delete and create a table in the MS Access file, before inserting fresh data.I tried this --> EXECUTE [AccessDBLinkedServer]...DROP_tbl_DED--> EXECUTE [AccessDBLinkedServer]...Create_tbl_DEDbut receive the following error.The attempt by the provider to pass remote stored procedure parameters to remote server 'AccessDBLinkedServer' failed. Verify that the number of parameters, the order, and the values passed are correct. |
|
|
infodemers
Posting Yak Master
183 Posts |
Posted - 2014-01-22 : 11:37:48
|
| Never mind, I managed it by adding a SQL task and an OLEDB connection into an SSIS package. |
 |
|
|
|
|
|
Run MS Access query from Linked server