Make sure to check out Power View a little better. It's very intuitive and with a few clicks you can make a compelling dashboard.

If you have Excel 2013, PowerPivot and...

dario.quinn (3/21/2013)

---

Just now I have a date column with format of 2011-05-25 I would like to split this into three columns:

Year Month Day

2011 ...

Ah, great that you found the solution and thanks for posting back!

If the ACE OLE DB driver thinks the column is a date column, it will try converting the numbers to a date.

Internally, dates in Excel are represented by a number...

No chance you are using SQL Server 2012? Because this would be easy with the new lag/lead functions.

Here's a script to create a time dimension:

Script to Populate Date Dimension, without Using a Cursor

I wouldn't stop at the month level. I would create the dimension to the date...

Easy one, thanks.

Jason.Robinson (3/20/2013)

---

The source is a small CSV file with something around 10 rows. I'm using a flat file connection.

The conditions are checking two string fields for different value combinations. There...

swhedges47 (3/20/2013)

---

Unfortunately, that's one of the first things I tried.

Here's the thing though (and this is the reason I added the [edit]), refreshing the fields for a Report dataset (that...

Can you be a bit more specific? Desired output would be welcome.

Long time ago I installed SQL Server 2005, but shouldn't you install the database engine?

Lowell (3/19/2013)

---

i think it has nothing to do with SQL, but rather the ACE drivers that are used to access via Excel;

the ACE driver does the peek at the first...

What's the source?

Which conditions are used in the conditional split?

Under which account is the SQL Server Agent job run?

If time is on your side...

Any package configurations that might steer the package to another source?