Of course, now that I am looking at your sample data a bit, it looks like your time column is probably a VARCHAR in which you could have 8:00am and...

SELECT Employee, Entrydate, MIN(Entrytime) AS Entrytime

FROM Entries

GROUP BY Employee, Entrydate

Use a Conditional Split transformation component in your data flow.

I think you are using a SQL Destination in your data flow and the destination SQL server is not the local SQL server that is executing the SSIS package.

The SQL...

I had to do this and ran into two issues.

The first is that the SSIS components will not update an AS 2000 cube. You will have to use a...

Ok, the dead horse is well-kicked.

You may also want to take a good look at what you are actually doing. A job that runs every minute is probably not the most efficient process.

What are...

You may want to give a better description of what you are trying to do. This is not necessarily what SSIS is made to do.

It can, however, do this...

When you schedule a SQL Agent job for an SSIS package, the job step UI allows you to select any SSIS server for choosing the package.

However, the package will be...

I blame it entirely on the initial post.

1) If the databases are not being constantly added and removed (so you don't need the process to be dynamic for new databases) you could create an SSIS package with...

Because we are all idiots and had the line feed before the carraige return.

Try this:

select @t = replace(@t, char(13) + char(10) + char(13) + char(10), char(13) + char(10))

Replace 2 carraige returns next to each other with one:

set @t = replace(@t, char(10) + char(13) + char(10) + char(13),char(10) + char(13))

If you are trying to get all of the rows from table A for each row in table B, use a merge join.

It's also important to note that the "Search" feature on Report Manager searches the names and descriptions of the reports.

Descriptions are pretty useful.