Does the Access file already exist? It needs to, or you won't be able to set up your mappings.

Do you really need many files, or just many tables within one...

... and, to do the design work in the first place, you'll need a valid source-data file in your import folder. Without it, SSIS cannot build the necessary meta data....

So I am assuming that you have multiple dataflows, connected in some logical order. You want each of the dataflows to finish successfully if the source file is not found,...

OK - what do you want to happen if some of the files are present and some are not? Import them, or not import anything?

If you know that the file will exist at run time and you're just avoiding design-time validation errors, set DelayValidation = True.

If you want a package to run successfully regardless...

Check the Regional Settings on the computer running the package and ensure that 'Decimal Symbol' is set to comma, rather than a full-stop.

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?