I had a brief experience with a server showing High CPU usage. With the basic sp_who2 I found the suspect process ID and plugged it into

DBCC inputBuffer(pid)

That clued...

You'll have to tell me about how this is a push to the destination. Normally you query the change data capture tables to see what rows changed and get the...

I am not too knowledgeable on that level. I can say the capture job runs continuously but somehow knows when there is idle time in the system. Only then does...

Hi, I am not clear on your context here. CDC runs on a database where the data is being monitored for changes. How does this relate to your "destination "?

Change Data Capture (CDC) is a SQL job that crawls the sql server transaction log looking for changes. When a change is read it writes an entry to its...

I can add that SSIS is extendable. Thus it is possible to create in .NET your very own data source component for the data flow task to adapt to...

Just to note, you dont really need the GROUP BY clause in this example. The "SELECT MAX(WeekDay)" part is not really an aggregation on the previous columns listed. But it...

It would be nice to post create tables statements with sample data to see how your data is structured. What I am seeing / reading described is a final front...

That is interesting and thanks for sharing. This is equivalent to the UNION ALL operator but not the UNION operator. I suppose that you can take the query, wrap it...

Data conversions are a norm in the ETL world. Overall SSIS handles them great. The OP did the right thing by doing the conversion in the data source adapter with...

Hi, by using the Lookup transform, you will be only inserting rows that had no match.

So to do this in the Lookup transformation editor> general ...

Specify how to handle...

What language setting are you using? For example:

SELECT CAST('25/08/14' as datetime)

SELECT CAST('08/25/14' as datetime)

Can give you different results based on your language setting for the server.

SSIS can be rather quirky. Did you initially not do the conversion in the select query within the data source? And then changed it after realising you need to? That...

The way I read it your error is within SSIS. So let us see if you can use Excel as a dataflow destination. Right click your project > properties >...

I am wondering if you could not eliminate the nested looping by only using the one loop to iterate through the dates and then somehow build an expression pertaining to...