Help! DTS to upload an excel file
i need your wide expertise. I`ve created a DTS in SQL server to upload the information from an Excel file located in a shared drive to another Excel file located in the server. I`ve saved this DTS in a Visual Basic and i`ve added the "Microsoft DTS Package" reference. This DTS is located in my server. Everytime i run the program it works for me but when i try tu run it from the client side or from another computer i`m getting this "429 ActiveX error". I need to run the DTS from the client side to let some other people upload the file everytime they want. I did a lot research regarding this problem and the only thing i`ve found is to use the "regsvr32" and register the dll (the dts dll) in that computer. I`ve done it but i`m still getting the error. Do you have a clue what i`m doing wrong? or how can i run the DTS script from another computer? Your help will be much appreciated.