Solved

SSIS Logging

Posted on 2009-07-10
6
170 Views
Last Modified: 2013-11-10
Hi Experts!

Trying to get package to log stuffs. In the images there's the log settings and when tried to run the package in BI Studio (F5) the err msg appears.

There is a connection manager (in image below).

What do you need to do about the Connection Manager?

TIA!

logging-setting.jpg
logging-setting2.jpg
logging-setting3.jpg
package-err.jpg
0
Comment
Question by:allanau20
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 24828970
it seems from your first picture that your choose log provider for text file in the upper combobox, and then log provider for sql server in the lower box, maybe that causes the problem
0
 
LVL 5

Author Comment

by:allanau20
ID: 24841986
hi momi_sabag.

When I created the logging it was set to SQL Server. Then I exited and went back in to create the screenshot. Funny thing is the provider type defaults to "Text" -- that's what was captured. But if I expand the column "Name" it shows "SSIS log provider for SQL Server".
logging-setting.jpg
0
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 24848882
Something you are doing wrong...
Also install SQL Service pack 3

Follow images...

Helped?
Regards,
Pedro
www.pedrocgd.blogspot.com
www.BIResort.net
SSIS-LoggingProvider1.JPG
SSIS-LoggingProvider2.JPG
SSIS-LoggingProvider3.JPG
SSIS-LoggingProvider4.JPG
SSIS-LoggingProvider5.JPG
0
Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

 
LVL 5

Author Comment

by:allanau20
ID: 24853823
Hi PedroCGD.

Did exactly how you have it in the images above. Except that the sysdtslog90 is in Database-> System Databases-> Tables-> System Tables.  Unlike yours it's in StockSample -> Tables-> System Tables.

I think there might be something wrong with my SQL Server. I still cannot execute bcp to create the format file, but the script works on my co-workers workstation.
0
 
LVL 5

Author Comment

by:allanau20
ID: 24854000
hahhaha .. .figured the errors of my way....
Did not specify 'configuration' at the right side. Sigh.
logging-setting.jpg
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24857647
Very Good!!!
:-)
Pedro
www.pedrocgd.blogspot.com
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question