Thanks a lot...let me try that...

I log in as the administrator...can u specify me what rights shoud i have?? and I m not using agent service to run the package...thanks for ur reply....let me check...

yep...I m using xml configuration files....in windows authentication...

Thanks for the reply...The package is located in C:\SSIS folder....I have both .dtsx file and .dtsConfig file in that folder...when I click .dtsx, it guides me to execute package utility....there...

ok kool...Thanks a lot....let me try that...

oh sorry abt that...but we just have to add the new data...may be we can do that using a stored procedure...my client wants me to use SSIS...

Thanks for ur reply...But my concern is all about comparing...we have a date field in each table...we ve to enter only the new records...how to compare?? I m new to...

Hey...I got it...Its just I was updating the values in the dimension table instead of the source table...i went mad really...anyway thanks for both of you ...

Thanks Michael...I m using the dates(start date and end date)...but Where can I find the settings?? I ve been trying to solve this past a week...

yeah...Thanks for your reply....I already did the samething...I just took 10 records and tested it...It does nt work..

yeah..but my problem is...for the new records it shows as old records and old records as new records....is it like any time settings do i need to change?

Thanks a lot....I solved it....

I have the same thing now....I ve to deploy packages to the production server....its really nice that you mentioned all the steps in an order....but once we move the packages...

I have not completed it yet...may be it takes time...what i did is, I took a datasource in ssis and selected the sql query option and I wrote the query...

Thanks a lot....you almost gave the solution...