I really don't understand your issue. Your example looks like you want to combine rows with duplicate values into a single row with multiple columns, that would be a...

As has been said, certifications without experience are pretty useless. I just booked my first certification test 70-432 to work toward the MCITP - DBA certification, but I'm...

I'm not sure what your question is as the link you provided does a pretty good job stepping you through the process.

Can you share what you have and then we...

It sounds like you want to Pivot your data base on the value column so you probably need to use the Pivot transform. I've never used it, but it...

If you have Anti-Virus running make sure that Database Mail is added as an exception.

Here are a couple of blog posts about database mail:

http://wiseman-wiseguy.blogspot.com/2009/07/mystery-of-failing-database-mail.html

http://wiseman-wiseguy.blogspot.com/2009/09/what-happened-to-that-email.html

Why can't you use DBMail/sp_send_dbmail?

If you right-click on your source and go into the Advanced Editor you can set the code page to be used. I'd try that.

What is the error?

Sounds like a user had been removed from the server and owned the job. I'd recommend changing the owner to sa or creating a user just used to own...

Have you read the 2 Cross-Tab articles linked in my signature? The second one discusses how to do a dynamic Cross-Tab/Pivot which is what you need.

Well, the expression you have provided will set the date to December 1st of the previous year whenever the current month is January. I have no idea why it...

I agree with Gail. What happens if more than 1 row is inserted or updated.

I wouldn't worry about the messages if you can verify that the correct changes are...

Seconds to go to trash destination from the OLE DB Source. I'm 5 minutes in with the script component going to the trash destination and still running. Pretty...

I see where you are coming from, but the dataflow has only 4 steps:

1. Get the appropriate rows from SQL Server - ~5000 rows returned sub-second.

2. Script Component...

Are there any jobs running DBCC or Index maintenance at those times?