|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Execute DTS package from .adp ?Currently I save a DTS as a storage file. I then run the storage file with VBA code in the .adp(Access Data Project). This works if you run the ADP on the Server but the users of the .adp will be opening it on the network from their machines. When they do it says missing custtask.dll and some other .dll these .dll are in the SQL server Binn on the server so they are not on the users machines. I could not register the .dlls on the user machines without SQL Server. It would be great if I could solve this problem but I'm not sure how..... Another possiblity would be to save the DTS SQL Server msdb table and run it from the server but I do not know how to run the DTS using VBA code or a SQL statement... Please help with any documentation or suggestions, Chuck You can dts runtime. You'd want to read the readme for details as to what's
distributable. Meanwhile, you want to save your dts package on sqlserver (i.e. in msdb) and then create a sqljob for the package. Then in your vba, you would invoke sp_start_job 'jobname' to execute it. -- Show quote-oj <meyv***@yahoo.com> wrote in message news:1126375373.241589.256440@z14g2000cwz.googlegroups.com... > Hello, > > Currently I save a DTS as a storage file. I then run the storage file > with VBA code in the .adp(Access Data Project). This works if you run > the ADP on the Server but the users of the .adp will be opening it on > the network from their machines. When they do it says missing > custtask.dll and some other .dll these .dll are in the SQL server Binn > on the server so they are not on the users machines. > I could not register the .dlls on the user machines without SQL Server. > > It would be great if I could solve this problem but I'm not sure > how..... > > Another possiblity would be to save the DTS SQL Server msdb table and > run it from the server but I do not know how to run the DTS using VBA > code or a SQL statement... > > Please help with any documentation or suggestions, > > Chuck >  |
|||||||||||||||||||||||
Other interesting topics