how lmit - control output of dtexec ?

Hi,

we have job that execute SSIS (s) using dtexec and save output(s) to file

Output of SSIS is 4 page long full of entries like

Validating: 0% ..ProgressProgress: .. Prepare for Execute: 100%

1. Can I limit output to show only success or failure ?
2. Can I redirect output of dtexec to be saved in msdb insted of showing after execution.

Thank you

Alex

Alex_UTL wrote:

1. Can I limit output to show only success or failure ?

dtexec has an option /Rep (or /Reporting) that lets you select the events you want reported.

/Rep[orting] Level[;EventGUIDOrName[;EventGUIDOrName[...]]
Level = N or V or any one or more of E, W, I, C, D, or P.

'/Reporting E' shows only errors, '/Reporting W' shows warnings, etc. I think success or failure is reported regardless of the option. Try the option N and see if that helps.

Check out Book online entry for dtexec utility.

Alex_UTL wrote:

2. Can I redirect output of dtexec to be saved in msdb insted of showing after execution.

I think this is better done in the package, but there is a '/Logger' command line option for dtexec which you can try.

how i can save byte array in database?

hi all
i have Byte Array like this:
dim Arr(388,8) as Byte
its working good in my application, but after i close my application all
data saved in this array is lost.
i need save all data from this array to Database (MDB or SQL), then after i
run application again i load data from Database to my Array Variable.
how i can do that?
its byte aray.
Best Regards
Tark M. Siala
Software Development
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
You can save these values in a Blob field
regards
Michel Posseth [MCP]
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> hi all
> i have Byte Array like this:
> dim Arr(388,8) as Byte
> its working good in my application, but after i close my application all
> data saved in this array is lost.
> i need save all data from this array to Database (MDB or SQL), then after
> i run application again i load data from Database to my Array Variable.
> how i can do that?
> its byte aray.
> --
> Best Regards
> Tark M. Siala
> Software Development
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>
|||hi
thanks
but i know how i can working with Blob to save Pictures, but how i can
working with Blob to save (Byte Array)?
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
"m.posseth" <michelp@.nohausystems.nl> wrote in message
news:uomlDeQQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> You can save these values in a Blob field
> regards
> Michel Posseth [MCP]
>
>
>
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>

HOW I CAN SAVE AN XML IN SQL SERVER

I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
I NEED TO SAVE AS A TABLE IN SQL SERVER
CAN ANYBODY HELP ME ?
THANKS
GRS
Do you want to shred it into rows/columns or store it as blob?
If you want to shred it, you may use OpenXML or Dataset. If the file size is
big, consider using Bulkload which will stream the date to SQL server.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"GRS" <g_saturansky@.yahoo.com> wrote in message
news:1121727965.861690.60780@.g47g2000cwa.googlegro ups.com...
>I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
> I NEED TO SAVE AS A TABLE IN SQL SERVER
> CAN ANYBODY HELP ME ?
> THANKS
> GRS
>
|||

Quote:

Originally posted by GRS
I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
I NEED TO SAVE AS A TABLE IN SQL SERVER
CAN ANYBODY HELP ME ?
THANKS
GRS

http://www.kbalertz.com/kb_316244.aspx
That will get you started.
...

How I can I know the current mode of report?

Hi,
I need to switch off background color of column in print mode to save
printer resources. I need to show background color of column in preview mode
only for readability purpose on the screen.
I don't know how I can trace report current mode programatically. I am
running server side report.On client side , I am showing report in report
viewer.
--
Regards,
NanditaOn Apr 30, 8:54 pm, Nandita Reshamwala <resh...@.xtra.co.nz> wrote:
> Hi,
> I need to switch off background color of column in print mode to save
> printer resources. I need to show background color of column in preview mode
> only for readability purpose on the screen.
> I don't know how I can trace report current mode programatically. I am
> running server side report.On client side , I am showing report in report
> viewer.
> --
> Regards,
> Nandita
As far as I know, this is not feasible. The only thing that I can
suggest is to either display the report in a datagridview (or
gridview) w/the background colors and w/the same setup as the report
would show and then have the RDL file w/o background colors -or- have
2 separate reports in an application and try to trade them out at
runtime. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant