output to text file

Question

output to text file

Viewing 5 posts - 16 through 19 (of 19 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Try the trace, catch the statements and reexecute them, maybe the error will be usefull there. I'm in no way an expert in dts so I can't offer much more help than that.

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 2

joyeux,

an unspecified error - (Erreur non spécifiée)

why can't they make these a little more helpfull ?

MVDBA

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Can you explain what you're doing to "DTS" the logins? And if you are using DTS, there are a ton of ways to get this info into a text file. At the very least you have access to scripting meaning you can use the Scripting.FileSystem object to write to a text file.

K. Brian Kelley
@kbriankelley

lalibert16 SSC Eights! Points: 928 More actions · Answer 4

In DTS, there is a task named "transfer logins". I just create a DTS package that says to transfer login from server A to server B.

I wanted to use DTS to easily transfer my logins each night to be sure my warm server would be ready to accept connections upon failure of my prod server. Unfortunately, the error shown above always appears... I wondered why...

Thank you all for your help

Erik

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 5

I've run the following to mimic your package

i get the following error log, however all of my new logins that i created are transferred correctly

Step 'DTSStep_OMWCustomTasks.OMWTransferLogins_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Unspecified error

Step Error code: 80004005

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:700

Step Execution Started: 12/07/2005 09:26:11

Step Execution Completed: 12/07/2005 09:26:11

Total Step Execution Time: 0.156 seconds

Progress count in Step: 0

Task Log for this step:

-----Start Task Log-----

Error = 1 (00000001), Description = Script Login QUANTIX\Oracle Support

Error = 1 (00000001), Description = Script Login BUILTIN\Administrators

Error = 1 (00000001), Description = Script Login textxx

Error = 1 (00000001), Description = Script Login sa

Error = 1 (00000001), Description = Script Login research_net

Error = 1 (00000001), Description = Script Login QUANTIX-UK\michaelv

Error = 1 (00000001), Description = Script Login QUANTIX\SteveK

Error = 1 (00000001), Description = Script Login quantix\stephenh

Error = 1 (00000001), Description = Script Login QSM

Error = 1 (00000001), Description = Script Login interface_user

Error = 1 (00000001), Description = Script Login HealthCheck

Error = 1 (00000001), Description = Script Login CMD

Error = 0 (00000000), Description = Transfer Login QUANTIX\Oracle Support

Error = 1 (00000001), Description = Transfer Login BUILTIN\Administrators

Error = 1 (00000001), Description = Transfer Login textxx

Error = 1 (00000001), Description = Transfer Login sa

Error = 1 (00000001), Description = Transfer Login research_net

Error = 1 (00000001), Description = Transfer Login QUANTIX-UK\michaelv

Error = 1 (00000001), Description = Transfer Login QUANTIX\SteveK

Error = 1 (00000001), Description = Transfer Login quantix\stephenh

Error = 1 (00000001), Description = Transfer Login QSM

Error = 1 (00000001), Description = Transfer Login interface_user

Error = 1 (00000001), Description = Transfer Login HealthCheck

Error = 1 (00000001), Description = Transfer Login CMD

MVDBA