As this does not appear to be SSIS related, I suggest that you post it here.

Perhaps if I explain my thinking ...

Here is how I read your post:

"I have a problem and two potential solutions. One solution works and the other does not. Can you...

My idea ...

If export works, use that.

It's a complex one to try and diagnose, because I don't think you've provided quite enough info.

My first comment would be that your conditions are not exclusive. Eg anything that...

udaya_1222 (3/10/2010)

---

Thanks Devyanth , Sort transformation was helpful but now i have a question how should i build my data flow to capture duplicate records in a file and what...

Why did you post this?

I would do it the way you suggest - but as part of the package. Step 1 - Script Task to validate spreadsheet format.

Trial and error strikes again! I'm afraid I can't help you any more, but well done on getting there in the end.

gprasad.nit (3/4/2010)

---

You can not debug or run this project, because the required version of the Microsoft Office application is not installed error come in ms SQL integration services

when i want...

What is the datatype of the destination field on SQL Server?

Can you confirm that Excel is the problem by adding a data reader after the data source?

A derived column using...

Can you clarify what you mean by 'correct order'?

If possible, some sample data would probably help ... just enough to illuminate your ordering problem.

Yeah - I reckon you'll get more than just the table name by doing that. If you try 'object', does the error go away?

You might need a bit of script...

So it sounds like you want to be able to repeatedly (at defined periods) process an Access database. (Is there only one? Will it always have the same name?).

Every time...

What do you mean by "type of table"?

--Edit

are all of the physical tables already set up in SQL Server, or are you hoping to do some sort of create-then-import...

This works - just tested it:

RIGHT("0" + (DT_STR,4,1252)DATEPART("dd",GETDATE()),2)