Disable validation

The error is saying that you are trying to take a source column with a length of 259 and put the data in a destination column with a length of...

Or perhaps have a date dimension with this kind of date and a date equivalent.

Thereafter you could simply perform a lookup task and reference the proper date?

Why not have some conditional flow in your control flow? If the table has been created dont make it do the data flow, else make it do the data flow.

This normally occurs if there has been a change to your schema, not to stress, just double click on your input and output and it should resolve itself

SSIS and MS Access also has its own unique nuances, some of which are downright irritating.

Good luck!

~PD

Try and disable validation of the loop container, maybe the path that you are accessing doesnt have the file. Also double check what files you are checking for, and consider...

For me, package configurations all boil down to one thing - portability...

Basically if you have an environment where some level of change control is enforced, package configurations become sort of...

My bad... I meant in Excel, text is seen as nvarchar and not varchar

Welcome to one of the most irritating nuances of SSIS. Text is seen as NVarchar and not Varchar. In other words, if you have a text (10), make it Nvarchar...

It should be part of the samples install.

Just readup on installing AdventureworksDW on BOL, this should point you in the right direction

~PD

How are you running this when you get failure?

Normally, your SQL Server Agent account would require permissions to the required folder

Try working with the aggregate transform, havent personally used min and max, but it should be pretty standard.

Conceptually something like following:

a) Use a sort transform and sort by customer ID

b)...

So you cannot write custom TSQL select statements on the DB side? Odd

I was off on Friday and read all the posts.

Congratulations Jenny on getting this to work. Good luck on your SSIS projects!

~PD