Thanks Philippe. However the question was if we can handel condition for schedule. For example lets say I have a Job that runs 4 SSIS packages that loads my data...

Ok we can add multiple schedule to a job. But can we do conditional schedule? Can we for example have a schedule for everyday except the last Thursday of the...

It all depends on the SCD type. If you chose TYPE I (overwrite) then in SSIS SCD wizard you chose <changing attributes> which basically means...

In SSIS you could use the <Slowly Changing Dimension> component which basically does the UPSERT.

I am glad I am not the only one then. I thought my Install got screwed up.

I agree with Sudheer, Its been a long time since Microsoft change the name to SSIS (In Beta 2 may be even late beta 1). So to show screen shots...

Although I mostly use project files (adp) to connect to SQL Server, sometimes I use Linked tables in Access MDB file simply because I do...