How Link Executionid Of Sysdtslog90

Oct 30, 2006

I have enabled logging using database.

When I try to query the sysdtslog90 table using System::ExecutionInstanceGUID to link executionid - it is not matching.

Any resolution?

Thanks

View 7 Replies


ADVERTISEMENT

Getting A Package's ExecutionID

Nov 27, 2006

Hello everyone

I'm logging the execution of my package into a SQL SERVER table. Everything works right. I'm also executing this package using a web service, I'd like to retrive the package's executionId after it is executed. By the way, i'm using a Microsft.SqlServer.Dts.Runtime.Package object but i haven't found any property that could give this.

any clue?


thanks a lot

View 3 Replies View Related

System::ExecutionInstanceGUID &&<&&> Logging ExecutionId ????

Nov 15, 2007

Any help in understanding and working around this odd behavior is greatly appreciated!

I have the default SQL database logging enabled (to sysdtslog90).
I start my package with an ExecuteSQL task that writes most of the system variables to an execution log.
Included is the value of the System::ExecutionInstanceGUID variable (which I thought should match the standard SSIS logging executionid value).

I have an error handling ExecuteSQL task that updates my execution log with an end time and the task that failed.
This is right out of the ProjectREAL audit approach.

Problem with the Error ExecuteSQL update is that it is trying to match the SSIS log but cannot.
This is the SQL being used:
select top 1 @failureTask = source
from dbo.sysdtslog90
where executionid = @executionGuid
and (upper(event) = 'ONERROR')
and upper(source) <> @packageName
order by endtime desc

When I enable OnInformation event logging something interesting appears.
The ExecutionGUID changes during validation of my one Data Flow Task in the package YET the system variable does not get updated with the new value!!!!

Log Excerpt:
1 OnInformation DFT Load Customer Test B94FDA4C-46D9-4193-BD87-12CFCB31EA1A Validation phase is beginning.
2 OnInformation DFT Load Customer Test 282F7D2E-329A-49DB-90B6-838053114940 Validation phase is beginning.
3 PackageStart AuditSample 282F7D2E-329A-49DB-90B6-838053114940 Beginning of package execution.
4 OnPreExecute AuditSample 282F7D2E-329A-49DB-90B6-838053114940
5 OnPreExecute SCR Set Correct Execution GUID 282F7D2E-329A-49DB-90B6-838053114940
6 OnVariableValueChanged AuditSample 282F7D2E-329A-49DB-90B6-838053114940 ExecutionGUID
7 OnInformation SCR Set Correct Execution GUID 282F7D2E-329A-49DB-90B6-838053114940 System Variable - Package Name AuditSample Start Time 11/14/2007 8:56:26 PM ExecutionGuid b94fda4c-46d9-4193-bd87-12cfcb31ea1a


Please also reference http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=420279&SiteID=1

View 10 Replies View Related

System::ExecutionID Required In Eventhandlers

Mar 7, 2006

It is possible for a task to be executed multiple times in parallel. e.g. If a package is executed more than once using "Execute Package Task".
I understand that in the future the ForEach container will have the ability to execute all its iterations in parallel as well.

This is a problem. In the eventhandlers we know the SourceID of the container raising the event so we can tie together events raised by the same container but this simply isn't possible if the events are running in parallel.
An example of where we would want to do this is drop a record into a table when a container fires OnPreExecute and then update that record with the container duration time upon OnPostExecute. This does NOT work when tasks run in parallel.

The solution to this is very simple. As well as capturing System:ourceID, capture a new value, System::ExecutionID as well.



In the meantime, can anyone think of another way around this?

cheers

-Jamie



P.S.

I have raised this bug here: http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackId=FDBK46904 and have asked for the provision of System::ExecutionID. If you think its a good idea then plese go ahead and vote for it.



[Microsoft follow-up]

This is still a valid request. Does it need opening on Connect?



-Jamie

View 3 Replies View Related

Dbo.sysdtslog90

Dec 4, 2007

Hi,
is there any way to use dbo.sysdtslog90 table for SSIS package logging?

View 2 Replies View Related

Improvement Sysdtslog90?

Apr 12, 2007

hello



im trying to create a ssis monitoring tool (using sysdtslog90, reporting services and system tables) including sql server agent ssis schedules/history. but im having some problems evaluating sysdtslog90. im using the built in SSIS logging without any custom logging tasks (i only log OnError and OnWarning) to keep the logging table as small as possible (one sysdtslog90 table for all packages running on the server).

and there is the problem:

there are some executions without any events except OnError. the source of this event is the name of the failed task, so how do i get the name and id of the failed package?



"normal" executions have "PackageStart" and "PackageEnd" where the sourceid and source are equal with the id and name of the package



i could add logging for OnPreValidate and catch the first line, because no package can fail before validation!?

but isnt there any better solution?

i would love it to have two more columns in sysdtslog90.. package id and name. would be much easier to evaluate sysdtslog90 :/



- paul



View 8 Replies View Related

Meaning Of Datacode In Sysdtslog90?

Jun 13, 2006

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

View 7 Replies View Related

Sysdtslog90 Table Creation Issue

Jul 25, 2007

Hi,

when I select sql server provider pointing to connection mydatabase for Logging the sysdtslog90 table is not getting created. However if I point the connection to msdb - sysdtslog90 it works fine.



Can I have sysdtslog90 under the application database? what are the steps to do this?



Thanks in advance.

Prabhakaran

View 4 Replies View Related

Log Data Wrongly Redirected To Master.dbo.sysdtslog90

Aug 20, 2007



I have been using the SSIS Log Provider for SQL Server quite a lot this year with little to no problems. Recently however as I edit or create packages the logging seems to keep going to the master.dbo.sysdtslog90 table as opposed to the [db].dbo.sysdtslog90 as setup in the package. I tried totally deleting the connection from the package and recreating and still had the problem.

Is there some setting on the SQL server itself that can cause this? Our "dba" likes to make changes without letting anyone know about them.

Any ideas?

View 3 Replies View Related

Sysdtslog90, Message Field And My Unicode Ignorance

Feb 5, 2008

Sorry to be an ignorant American here, but I'm having a challenge I just can't seem to wrap my head around.

I am attempting to make a nice query for a report that will show how our SSIS jobs are doing. All my packages use the native SQL Server logging capability. The table is sysdtslog90 and it stores the message to a field called 'message' (crazy, I know) with a datatype of nvarchar(4096).

The challenge I'm having is that I'd like to grab all lines where my message is X. The following queries will return no results. The first is me typing in the message I see in the window, the second is copying the value and pasting it in. I know there are instances where that message exists, sadly, in the log table.




Code Snippet

SELECT

L.*

FROM

sysdtslog90 L

WHERE

L.message = N'A commit failed.'


SELECT

L.*

FROM

sysdtslog90 L

WHERE

L.message = N'A commit failed. '





If I were to change that clause out to a like, it'd work just fine. Is that the appropriate way to work with unicode literals? It doesn't feel right.




Code Snippet
SELECT
L.*
FROM
sysdtslog90 L
WHERE
L.message LIKE N'A commit failed.%'




I have exported my sysdtslog90 table to a unicode flat file and looked at this message in a hex editor and it looks fine, nothing looked awry. I then opened the file up in SSMS, thinking perhaps it's a silent conversion issue with pasting, but to no avail. Anyone have some guidance for me?

View 6 Replies View Related

Access2003 Cannot Link (but Excel2003 Can Link) To Tables In Access97 Database

Feb 20, 2008

I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)

The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.

When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.

BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.

Thanks
TR

View 1 Replies View Related

Cannot Link To SQL Tables Using ODBC Link Table In Access 2003

Feb 3, 2006

When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning. 

The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().

The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source. 

Observations:  This function has worked normally in the recent past and works on other computers running Access 2003.  One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).

Has anyone experienced anything like this?  What's going on?

View 8 Replies View Related

Logging Package Name For Any Event In Sysdtslog90 Logging Table

Oct 17, 2007



Hi,
I decided to use the SQL Server log provider to store logging data of all my Integration Services packages. I also created some reports about this data for operating purposes.
I have a problem occurs the name of the executing package is not always written to the log,but the name of the single task which failed. But that is not very useful information for operating, because I do not see any chance to get the name of the package by the information which is logged in the sysdtslog90 table in the database which I defined for SSIS Logging.

How do I configure the package to always log the package information into the table, too?


Best regards,
Stefoon

View 5 Replies View Related

Link For SQL BOL Anyone?

Jun 11, 2001

and does BOL store the system error messages? if not where would i find those?
Im getting error 3700.

Thank You
Matthew Nye

View 2 Replies View Related

Link To DB2

Jan 21, 2006

Hi all,I'd like to know what the best means available is to enable distributedqueries from a SQL Server 2000, on tables in BOTH SQL Server 2000 and aremote DB2 server (the latter is not yet available for testing).So, I would be wanting to write queries or SP's like:select t1.field1, t1.field5, t1.field6, t2.field55, t2.field22from MySQLServer.mydb.dbowner.tableXXX as t1inner join ThatDB2Server.thatdb.thatowner.tableYYY as t2 on t2.field11= t1.field99where t1.field44 = @foobarI'm aware of at least two ways to go here:1) in SQL Server 2000, create a linked server to the remote DB2server, either using the wizard or sp_addlinkedserver, and using eitheran OLEDB or ODBC connection;2) using MS Host Integration Server (HIS).Since I've only just today learnt about HIS, I don't know very muchabout it.Questions:(a) are options (1) and (2) mutually exclusive, or does one depend onthe other?(b) can I do (1) without having to bother with (2)? If this, wherewould I get hold of the required OLEDB/ODBC Provider?(c) Is there another way(s) to go about this task?HYCH,Rob

View 1 Replies View Related

Is This The Right Link To SP2

Mar 18, 2008



Is this the right link to Microsoft Sql server 2005
http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx

and what is latest Versions thats around.. I have 9.00.3054.00 installed..

Is this the latest version??

View 4 Replies View Related

Link To A Table

Jun 21, 2006

There is a way to create a link from a SQL Server database to a table located on a MSAccess database? I mean like creating links from MSAccess to other databases. The requested table is updated many times/day, and I dont want to import the table each time an update happens.
Thanks,
Richard

View 2 Replies View Related

Can I Have Link Between Several Servers

Sep 5, 2007

hello all
I have a web application(asp.net) and Database(sql server 2005) .
we have installed them on several servers.
now we want to  have a  connection between apllication on one server to a database on another  server .
for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.
sometimes the Apllication on server(A) must connect to database on server(B). 
whats the solution plz?
note that the number of servers can be inceased in the future this mean the number of servers are not fixed.
thanks

View 3 Replies View Related

Link Servers

Mar 22, 2001

Is there a good article somewhere on sql link server I can find and be able
to get a good understanding ??

Thanks very much.

Rick

View 2 Replies View Related

Link Server

May 4, 2000

Can any one tell me what I did wrong? Tried to set up link server from SQL 7.0 to Oracle.I did it as it was instruct in BOL. When I tried to click on the table, I got this message "error 7399: OLE DB provider "MSDAORA" reported error. Thanks.

View 1 Replies View Related

Link To MySQL

Jan 24, 2006

Can anyone tell me how to link to a MySQL database please?

i want to DTS some data from one and i cant see how to link....

TIA

FatherJack

View 1 Replies View Related

Link Server

Sep 18, 2001

I have created a linked server using an userid that have access to 2 different databases. The linked
was created successfully but I am only able to see tables in 1 database but not both.
The tables of the databases that I can access is the default database of that userid. Is there a way to see all the
tables from more than 1 database that the user is authorized to? Thanks.

View 2 Replies View Related

SQL 7 Link To MS Access

Aug 30, 2004

I am working from within an SQL database trying to get data from an MS Access Database as a linked server. I can "successfully" add the linked server, but when I try to open it from SQL EM I get "Error 7399. . . " from Microsoft Jet. When I try to query it from QA I get "Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Not a valid account name or password.]"

I tried both Access 2000 databases and '97. Same results for each. Big project pending . . . any help is appreciated!

JB

View 3 Replies View Related

Remedy Link For SQL

Nov 2, 2004

Hi,

Does anyone know how to configure a Remedy Link for SQL.

let me know
CHRIS

View 3 Replies View Related

Database Link

Feb 9, 2004

Hi!

Is it possible to use database links on MS SQL-Server 2000, like on Oracle? If its possibe, what is the syntax and can i create a database link from Microsoft SQL Server 2000 to Oracle?

Nick

View 1 Replies View Related

Link To Mysql

Mar 8, 2004

I tired to create a link 'MYSQL' in a SQL Server using the following code :

EXEC sp_addlinkedserver
@server = ‘mysql’,
@provider = 'MSDASQL',
@provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQLServer;UID=root;PWD=;'

NB: I have a DB by the name of : MYSQL

There is no errors during creation ...

The link creation is OK but I am not able to see tables from SQL Server…

Any Idea ?

View 6 Replies View Related

Link - Other Servers

May 22, 2008

Hi
I have a scenario please help

I have 2 servers A and B
DB1 is the database in A and DB2 is the database in B

want to fetch the records from the server B in DB2. My query is

select * from B.DB2.dbo.table1

when i issued this statement in server A from database DB1 got the following error...
OLE DB provider "SQLNCLI" for linked server "B" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'sa'.

How to solve this issue.

(Note - login for SERVER A - sa/<nopassword>
login for SERVER B - sa/master)

View 4 Replies View Related

Link A Db To SQLExpress

Dec 3, 2005

I just reinstalled SQLExpress and all the dbs that I created are no more linked. The files still exist in the folder where the current version stores dbs (...Microsoft SQL ServerMSSQL.1MSSQLData) but they are not "linked" (don't know the right term).

Is there anybody who could help me how to "relink" these dbs to the actual .SQLExpress instance?

Thank you very much for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 2 Replies View Related

How To Link Two Databases With Out Using FQN

Oct 15, 2006

Hi all,
I am having a problem in sql2000.
I am having two databases.One is having all the tables.
Another one is having the stored procedures.
I ve to use the tables in first one in my stored procedure with out using fully qualified Name.

Thanks,
Karthik.

View 1 Replies View Related

Link To Access

Jul 31, 2007

I work extensively with Access; I have a new project with very large tables (as many as 15 million records). Is it worth my while to link Access to SQL Express if both are on the same machine?

I've downloaded SQL Express and installed it, but it won't let me link to Access 2003. Is there an update or patch to Access 2003 that will make this work?

If I do make the link successfully, will it be transparent - that is, can I work in Access as I always have, or would I have to learn how to create databases and queries in SQL? (I do know that I can make tables in Access and migrate them to SQL Server).

Where would I find simple step-by-step instructions to do this - my interest is more in the substance of my data analysis than in programming per se.

Ed

View 2 Replies View Related

Link Between SQL And MDAC

Jan 2, 2008

Hi All
may be my post sounds stupid but i have on idea about it.

can some one there please clear what is relationship between MDAC and SQL Server. id MDAC part of SQL Server or it is optional tool for some thing else. what it is excatly and links to useful tutorial etc.

View 1 Replies View Related

Link Between Sql And Oracle

Mar 4, 2008

Hi,
Im using SQL server.I need to get a table from a database in oracle server from my friend. She sent me the database by exporting. But the contents in the database will not be updated if she updated her databse right. What to do if I want the database that she sent me to be updated each time she updates her database? Help me.

View 1 Replies View Related

Link Server

Mar 4, 2008

I need help on creating Link Servers. The error message that I get says the link server is been created but it fails to connect.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved