Hello to all Gurus,

I am a newbie and need a step by step help. I am attaching herewith sample .dtsx and .bak ( both zipped separately) from my environment.

The scenario i was trying is given below :

Tables in focus dbo.CustTable & dbo.CustGroup

both tables are linked with the field CustGroup.

There are different working company for an application instance which is defined as "dataareaId" in each table.

I would try to create one file dynamically for each distinct dataareaid in CustTable and within a workbook create worksheets for a distinct CustGroup and each worksheet will then have the CustTable data for that CustGroup.

I have tried to follow the article but i am stuck at the excel destination . It says "the excel file name is not provided".

Help me

There would be a need to change the connection to use the attached the database instead of the ince in the .dtsx file.

I have now attached the updated files for your review. Pls help