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 |
|
ronstone
Starting Member
32 Posts |
 Posted - 2004-02-03 : 11:53:10
|
| I wrote a simple DTS that has an ActiveX Task. The task does nothing more than get the filesize and timestamp of a file and and inserts a row into a settings table with the information. I use UNC paths (\\server\share...).When I run from Enterpise Mgr as SA, the rows are inserted and the correct file sizes are posted. When I run from the DTS COM (from .net), the DTS runs (because there are rows in the settings table) but the filesize and date info are not posted.Question: What security context does the DTS run on the machine when called from COM? The DTS.Package.LoadFromSQLServer method takes in dbuser and dbpass, which I've tested with SA and still is not working.Ron |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
|
|
ronstone
Starting Member
32 Posts |
Posted - 2004-02-03 : 12:46:36
|
| Could you be a little more specific? Under DCOM Config (Component Services) I didn't see any DTS specific objects.As a test, I'm going to run the same DTS using the xp_cmdshell and "dtsrun ...." to see if it works that way.Update: I ran it under xp_cmdshell, and it worked! Hrmmm....Thanks |
 |
|
|
|
|
|
DTS Runs Ok Under Enterprise Mgr, Not Through COM