DTS Logging in issues on SQL server instance

Question

Post reply

DTS Logging in issues on SQL server instance

Johnson J Mampoozhil

SSC Enthusiast

Points: 141
More actions
October 30, 2006 at 6:44 am

#69435

Dear friends
We have DTS package which need to run on SQL Server instances as well as on local server. We have issues to deploy it on SQL Server instances there we cannot set the logging in properties on run. I tried to set it the logserver properties at run time using dynamic properties setting. But no luck. If you have any solution please do get back.
Johnson

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

RH-296080 Mr or Mrs. 500 Points: 527 More actions · Answer 1

Have you tried checking the logging option on package properties.

RH

Johnson J Mampoozhil SSC Enthusiast Points: 141 More actions · Answer 2

Thank you for the response.

Yea that is what I tried first. I think we cannot change the logging in option once the package started. I have solve the issue temporarly by using sp_OA?? methods instead of DTSRUN

Johnson

Johnson J Mampoozhil SSC Enthusiast Points: 141 More actions · Answer 3

Anyone deployed DTS packages on instance of SQL . I welcome any help.

Johnson

the sqlist SSCrazy Points: 2398 More actions · Answer 4

You will find answers to your problem on http://www.sqldts.com/. You can use osql utility from a vb script and/or .bat file to deploy packages; you can pass in the server name, db name and authentications as params into a .bat file.

Don't just give the hungry man a fish, teach him how to catch it as well.

the sqlist

Johnson J Mampoozhil SSC Enthusiast Points: 141 More actions · Answer 5

I mean by package property is exclusively for the logging option which we cannot set at run time. Yes /S option is for server or server instance on which the Package is or is to run. not for logging I guess

the sqlist SSCrazy Points: 2398 More actions · Answer 6

Yes you can, in a dtsrun utility command you can pass in the server name, the login AND the DTS package global parameters. Same thing if you use the sp_OAs.

You can see the syntax here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

Don't just give the hungry man a fish, teach him how to catch it as well.

the sqlist

Johnson J Mampoozhil SSC Enthusiast Points: 141 More actions · Answer 7

I don't find logging in option settting for DTSRUN yes it allows Server option which will not set the logging( Steps Run status to SQL Server&nbsp option.

I mean by package property is exclusively for the logging option which we cannot set at run time. Yes /S option is for server or server instance on which the Package is or is to run. not for logging I guess

Johnson