I ended up just uninstalling and re-installing. It was not as big of a deal as I imagined it would be.

Thanks for the advice. I appreciate...

Cool, thanks for the idea! I can't say that I fully follow all the details on my first pass of reading that, although I do get the concept...

Sorry, I have not as yet found any workarounds for this.

Using a staging table is a good idea, it's especially handy when trying to diagnose why a particular record either did or did not load like you wanted it to.

Some...

I have had the need in several of our SSIS packages to run command line executables. Usually the need to do this is when trying to extract data...

Thank you very much for the information, that is both an answer and an explanation. I understand what you are saying about how authentication works in SQL and...

The two ways we've done this are:

1) Writing the filenames as the contents of another file that you use as a source in the SSIS package.

2) Writing the filenames...

I would break this up into several tasks. The first would do all the comparisons and inserts into Table X using whatever logic you need.

The next task would...

Assuming that SSIS has been installed and configured on the same sever as the SQL Instance (which is not my expertise), one way would be to run it in a...

There may be an easier way, but the only way I know of to do this is to use a PIVOT statement.

select FirstName, [1] as Jan, [2] as Feb, [3]...

I believe DATEPART should have only 2 parameters and it will return an integer value.

For me ...

select datepart(hh,'2009-11-30 10:18:48.063') returns 10

select datepart(hh,'2009-11-30 22:19:44.790') returns 22

Glad to help. 🙂

After lots of searching, I fanally ran across the term "fast parse" in an article and found the following MSDN article.

http://msdn.microsoft.com/en-us/library/ms139833(SQL.90).aspx

This seems to be just the trick I...

That what I would have expected also. However, the date fields are loading with an error (-1071607676 The data value cannot be converted for reasons other than sign...

Thanks for your response.

Yep, we considered that and that is what we'll do if we have to. We'll then have to write a mechanism to do datatype checking...