Can you paste some sample source data? It might help me (and others) come up with ideas. Use [CR] and [LF] to designate where the carriage returns and line feeds...

If that is all that you are doing, why not just use a derived column?

If you can live without that log message, you could just put your dataflow inside a FOREACH container - then the package would still end gracefully, even if the file...

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...