I don't know WQL, so therefore have no idea whether this will work, but can you force a non-null result by using something like:

Select Caption, '' + CSDVersion from win32_operatingSystem

Can you change your process slightly as follows:

1) Move all files from D:\sync_scripts to an archive folder somewhere

2) Run the DLL

3) Use a FOREACH loop to execute all files in...

Please explain what you mean by

?

Do you mean that there are multiple files in a folder and you want to execute the...

You did not mention this in your original post.

You need a different connection for every combination of flat file 'type' you have (by type, I am referring to the number...

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.