Solved

SSIS Logging

Posted on 2009-07-10
6
156 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now