Solved

SSIS Logging

Posted on 2009-07-10
6
159 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

920 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

15 Experts available now in Live!

Get 1:1 Help Now