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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-11-17 : 04:09:03
|
| Hi All,I encountered an error when scheduled my DTS to run automatically. Basically, my DTS package will transfer the data from SQL Server to a .mdb file in remove PC. In order to do that, I used the following code to create an empty .mdb file on remove PC: 'Create empty MDB sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sFilename Set oCatalog = CreateObject("ADOX.Catalog") oCatalog.Create sConnectionString Set oCatalog = NothingIt runs successfully if I manually run it under DTS Designer. However, it fails on the "Create Object" point when I schedule it to run automatically. I have check my MSADOX.dll under the C:\Program Files\Common Files\System\ado folder. The dll permission is granted to the SQLSERVERAGENT. Can someone help me on this? What am I suppose to do? Thank you. |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
|
|
isanlu
Starting Member
7 Posts |
Posted - 2004-11-24 : 16:05:29
|
quote:
Originally posted by william_lee78
Hi All,After searching the net, finally I got the solution for this issue.Please refer to this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;298725
Thanks a million for finding this article. I could not find anything and I had the same problem... Isanlu |
 |
|
|
|
|
|
Permission Denied 'Create Object'