Very weird. Perhaps you could debug the package by changing the variable's type to Object to get over this error and then inspecting its contents...

Thanks for posting back & I'm glad to have helped.

Phil

No problem. Add a Script Task, open the properties and Edit Script. You'll find a load of template code already in there. Replace the bit from

Sub Main

to

End Sub

with...

lduvall (8/9/2010)

---

I've determined that all I need to do to make this work is to open up the file and add a comma to the end of the header record....

Bizarre answer - this is not a Boolean logic test. My question asked you to identify one or the other.

If you meant that you are using SQL Server as...

How do you mean: 'using SSIS as your back-end'?

Is your VS app somehow calling an SSIS package, or did you mean that you were using SQL Server as your back-end?

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