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?

Which version of SSIS are you working with?

The first step is to enable logging and the appropriate events to see what is going on when the package runs.

Integration Services (SSIS)...