It's normal. See here:

How It Works: When is the FlushCache message added to SQL Server Error Log?

Why not generate one INSERT command:

INSERT @p Values

(id0), (id2), ..., (idn)

Something like this, perhaps?

SET @sql='SELECT EVENTUID,EVENTTIMESTAMP,EVENTMAJORTYPE,EVENTMINORTYPE INTO #TEMP

FROM ' + @WgnWCUser + '.EMPLOYEE A WITH(NOLOCK)

WHERE A.'+@TIMESTAMP+' >= ''' +convert(char(8), @datFrom, 112) + ''' AND A.'+@TIMESTAMP+' < ''' + convert(char(8), @datFrom,...

So would I, but you can't have generic dataflows unless the views produce the same columns...

This part:

Select Count(C2.AppID) From Channels c left join Applications a on c.ChannelID = a.SourceID left join Contracts2 c2 on a.AppID = c2.AppID Where Channels.ChannelID = c.ChannelID

makes no sense...

What is the Protection Level of the package set to? (DontSaveSensitive, EncryptSensitiveWithUserKey, EncryptSensitiveWithPassword, EncryptAllWithUserKey, EncryptAllWithPassword, ServerStorage)

fwiw We store credentials like that either in an XML config file or in a...

John Rowan (10/6/2015)

---

You still have the Header and Trailer rows to contend with. A flat file source will allow you to skip the header, but not the trailer and...

Article here:

Finding dependencies[/url]

and here:

find dependency chain

You aliased table Chanels as c, effectively hiding Chanels so you can't use it anymore. Replace Chanels. with c.

Just realized, you have the same table as the target and part of the source. Merge doesn't work properly in that scenario

By "not working" do you mean that you get an error (if so please post the message) or that rows are not inserted when you think they should be?

If the...

have you checked out Find Most Expensive Queries Using DMV[/url]

If this is reproducible, fire up profiler to look for deadlocks and get the deadlock graph while running the package. Then you'll see why.

Cond. Split is the way to go. Look for rows starting with 'DET' and process those.

Perfmon to the rescue!

Good writeup here: Measuring Disk IO performance for SQL Servers