| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-07-19 : 15:18:14
|
| Hello guysHow do I execute a DTS thru a Activex ?Thanks!Igor. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-19 : 15:25:37
|
| dtsrun.exe is a command line utility that allows you to run DTS packages.Tara |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-19 : 15:44:06
|
| The job takes hours to run if I run it on schedule but it run in minutes when I execute the DTS package... I was trying to change the way it executes the job...Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-19 : 15:54:54
|
| Go to the database server. Log onto it with the account that the MSSQLSERVER service uses. Execute the package via DTS designer. Does it execute in minutes? This mimicks what the job scheduler does.Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 14:17:45
|
| Nice, I'll give this a shot...Igor. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 14:56:37
|
| very strange... I have admin access, I can run the job from a command line with my ID but the job takes hours to run, nothing gets wrote the event viewer...Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-20 : 14:58:32
|
| So you didn't logon to the database server using the MSSQLSERVER service account like I suggested?Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 17:55:43
|
| I did and still doesn't work... It was my last resort...Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-20 : 18:00:11
|
| What account is the MSSQLSERVER service using? Is it a domain account that has local admin privileges?Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 18:01:05
|
| Local with Admin Privileges.Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-20 : 18:03:58
|
| What does the DTS package do? Does it need to access anything outside of the database server such as another server?Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 18:12:19
|
| we're getting closer... I would have to explain that to you in a email...Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-20 : 18:14:51
|
| The reason I asked is if it needs to access anything outside of the database server, then you are going to need to use a domain account that has access to those other resources. The domain account would be used for the MSSQLSERVER service (might as well use it for SQLSERVERAGENT as well) and would be a member of the local admin group.Tara |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-20 : 18:44:33
|
| The mistake is outside of SQL, the job we're talking about involves downloading a file using a third party application (F-Secure) as the encryption method, the job downloads a file from a remote server using a PKI authentication and each user must have the public key uploaded to the remote server in order to run jobs in batch (this way we don't have to specify the password). The SQLAgent account never had the key uploaded, therefore the job was hanging on the authentication part because the remote host was asking for a password... What a lesson I learned today... Thanks for the post, I just realized that when you told me to log in with the agent's account.Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-20 : 18:45:50
|
| I had a hunch it was hanging somewhere. It's just hard to imagine where without knowing much about the package.Glad you figured it out!Tara |
|
|
|
|
Executing DTS from Activex