I think there is good potential in BI. From what I've seen there is a want from employers to have a background or understanding of basic statistics. BI turns data...

Take a look at the MERGE operator in Books Online. It will insert into the table when the record is not there and update the DESC or whatever other non-key...

select CAST(sum(saletotal) as money) /NumberofDays;

Should give you the correct significant digits.

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.