What happens after the Script Task - does the process try to run the dataflow, regardless of the existence of the file? Or have you used precedence constraints to send...

So bring the dates in as strings, and in the dataflow use a data conversion to convert to date. Then set the Error behaviour to be Redirect Row - to...

Lynn Pettis (3/17/2010)

---

Flat files would be smaller and faster to receive. It really comes down to preference. Not having had to work with XML files (yet) and having...

Maybe. You should check your data...

Thanks for posting that link - good info.

The SQL Server Export Wizard might generate the relevant Access CREATE TABLE commands for you (I haven't used it for a long time, so I'm not sure). You could edit...

Not quite sure how, but can the package detect 'who' is running it? For the scheduled job, it will be whatever user is running the SQL Agent service - and...

Use an OPENROWSET Execute SQL task to select the data.

Map the result of the Execute SQL task to a variable.

Use the variable as part of an Expression (SQLStatementSource) for your...

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