create log file - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

create log file

Author

Topic

somenoob
Posting Yak Master

112 Posts

Posted - 2011-10-25 : 03:31:20

Hi everyone, how do i create a log file looking like this:

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  6:09:41 PM
Info: 2011-02-08 18:10:05.09
   Code: 0x40016041
   Source: Agmt_Auto 
   Description: The package is attempting to configure from the XML file "c:\Program Files\Microsoft SQL Server\90\DTS\Packages\Agmt_Auto\Agmt_Auto.dtsConfig".
End Info
Info: 2011-02-08 18:10:05.15
..........
..........
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  6:09:41 PM
Finished: 6:12:29 PM
Elapsed:  167.687 seconds

i need to create a log file which looks like the above. but i do not know how to start.
how do i do it?
a step by step help will be appreciated.
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 04:15:32

you need to open your package and right click and select properties. select logging and logging window appears as below

http://www.sqllion.com/2009/05/programming-ssis-logging/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

somenoob
Posting Yak Master

112 Posts

Posted - 2011-10-25 : 04:33:17

i have tried the logging function but the result looks like this

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnError,EODW1MSDEVAPP1,EODWSIT\n,Data Dump,{E144D600-9EEA-47F8-92E4-0B115CB1DAFB},{307AFC3B-F66E-48BD-9E6F-AB1579547A24},10/25/2011 2:19:17 PM,10/25/2011 2:19:17 PM,-1071611876,0x,SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "EODW1MSDEVDB2\EODWSITPBI.EODW-Cntr" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
.......
......

it is different from the aboce sample

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 04:38:23

ok you mean you need to capture messages given by dtexec utility as in above?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

somenoob
Posting Yak Master

112 Posts

Posted - 2011-10-25 : 04:41:40

i am not sure what you mean. because i am not sure what i am needed to do as well.. haha. but i can provide a screen shot..

the log file name changes when i run. the date part changes.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 04:54:56

quote:
Originally posted by somenoob

i am not sure what you mean. because i am not sure what i am needed to do as well.. haha. but i can provide a screen shot..

the log file name changes when i run. the date part changes.

whatever you've shown above is messages displayed on running dtexec utility as i understand

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

somenoob
Posting Yak Master

112 Posts

Posted - 2011-10-25 : 04:58:39

so is it a log file? or do i have to do it seperately? or something?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 05:22:29

quote:
Originally posted by somenoob

so is it a log file? or do i have to do it seperately? or something?

its not a log file. Its standard execution results shown by dtexec utility.
i didnt understand what you want to do with it though

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

somenoob
Posting Yak Master

112 Posts

Posted - 2011-10-25 : 05:26:49

i see if it is not a log file then i don't need it.. haha
Thanks for all the help!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-25 : 05:32:56

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources