You cannot use a wildcard in your connection properties.

Use a FOREACH loop and put your wildcard file-spec in there. Map the file path returned from the foreach loop to a...

An alternative is to set the default value of your run date field in SQL Server - then it will populate itself whenever a record is created - no SSIS...

What sort of errors are you expecting? Any serious errors may not, of course, even make it into the db, so your envisaged method might not be a comprehensive solution.

But...

Also 'beleive' and 'varibble' 🙂

Surely, when you start getting to the realms of datasets with more than 65k rows, a spreadsheet is not the right repository. You need a database solution (Access maybe) or...

Please respond to Pradeep Adiga's posts - why is that not what you want?

coalesce (8/1/2010)

I'm not...

Of course you can.

Create a new Integration Services project, then right-click SSIS Packages in Solution Explorer and 'Add Existing Package.'

Then you're good to go.

Have a look here[/url].

You should be able to set the TransactionOption property of your DF to 'Required' to get the behaviour you require.

I still think your first answer was better (Excel 2007). Even better than that, however,...

Instead of using a File System task, use a script task containing appropriate code. It works much better, in my experience and requires just three or four lines of code.

OK ... may I ask what 'Transfer SQL Server Objects' gives you that a dataflow task does not? Just wondering why you went down this road.

Sure - do a multicast to all of the tables you need to update ...

Why not just copy the data you require? Deleting & recreating table objects repeatedly seems a little inefficient.

Is this because you have the same data in multiple tables (ie, redundant data)?