SSIS logging, SQL script messages

This is a discussion on SSIS logging, SQL script messages within the sqlserver-dts forums in Microsoft SQL Server category; Hello i have an SSIS package that contains two execute sql tasks, and one data flow task. when i run the sql script on its own in the MS SQL Server Managment Studio i get a bunch of messages about how many rows were affect and other print messages that i imbedded into the script however when i run this sql script as part of an SSIS package i can seem to configure to log file to capture these messages. any and all help is greatly appreciated thanks mike...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-dts

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-25-2008, 08:16 PM
Default SSIS logging, SQL script messages

Hello i have an SSIS package that contains two execute sql tasks, and one
data flow task. when i run the sql script on its own in the MS SQL Server
Managment Studio i get a bunch of messages about how many rows were affect
and other print messages that i imbedded into the script however when i run
this sql script as part of an SSIS package i can seem to configure to log
file to capture these messages. any and all help is greatly appreciated

thanks
mike
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:44 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.