Did you enable the event ScriptTaskLogEntry in the SSIS log details tab for the script task?

Second query:

UPDATE a

set [Verwijderd] = getDate()

from [artikelen] a

WHERE NOT EXISTS (SELECT 1 FROM [Hofstede].[dbo].[sparepartsupdate] SP WHERE a.[PartNrFabrikant] = SP.[PartNrFabrikant]);

The third query, shouldn't that be an INSERT statement?

ps: dt-fout in commentaar...

My guess is that you stored the password for SA in the package, but used EncryptSensitiveWithUserKey as the protection level of the package.

On server B, another user is used to...

I think I have finally met the "exception on the rule" for SELECT *.

Select on an Oracle view with all the of the columns in the SELECT clause: 36 minutes...

There is no easy DMV to look for failed transactions.

You need to have some monitoring in place.

http://dba.stackexchange.com/questions/44836/get-transactions-that-failed-or-were-never-committed

They are not too difficult in my opinion. Anyone with at least a year of SQL experience should be able to answer these more or less correct.

(and I'm just a...

1. The budgets can be stored inside the data warehouse. This is typicall in another fact table and usually at another grain than the fact table with the "actuals". For...

Are there a lot of failed transactions against that table?

If a transaction is initiated, an identity value is allocated. If the transaction fails, the allocated identity value is "lost".

Put your code inside the script task into a try catch.

Inside the catch blog, log the error message.

Logging in the Script Task

Make sure you enable the ScriptTaskLogEntry event in the...

I haven't tried it myself, but I see no reason why not, as long as your Windows 8 runs IIS.

Suppose you have a fact table in which you store orders from an e-commerce website.

There are various dates linked to a transaction:

* order date = the date the customer ordered...

WITH CTE_AssignRowNumber AS

(

SELECT

historyid

,locationid

,flag

,createddate

,modifieddate

,RID = ROW_NUMBER() OVER (PARTITION BY locationid ORDER BY modifieddate DESC)

FROM #templocationhistory

)

UPDATE t

SET maintainancefalg = cte.flag

FROM #templocation t

JOIN

(

SELECT locationid, flag

FROM CTE_AssignRowNumber

WHERE RID = 1

) cte ON t.locationid...

Nice question, thanks.

They have a punctuation symbol for that:

Sean Lange (6/5/2014)

---

I am just going to leave this here...

http://www.sqlusa.com/bestpractices/%5B/url%5D

Don't worry there is soap for your eyes. Then if you read some of the content you may want to find...