We had the same problem with our SQL Server 2005 64 bit server. After some research, it seems that Microsoft got rid of their OLE DB Provider for ODBC Drivers....

We have been able to fix the start up parameters by editing the registry and removing and adding back the cluster checkpoint as indicated in this KB article.

http://support.microsoft.com/kb/912397

I figured out why this isn't working. The XMLValues column has an XML Schema associated with it. I can use the code below and insert the records into a different...

Thanks Larry!

This is a great article and explains the installation process very clearly.

Our cluster is a multiple instance (active/active) cluster with the first node being the production instance and the...

When we set up our SQL Server 2005 server, we did some research on the collation settings and we decided on using the Windows collation (Latin1_General_CI_AI) because of the sort...

I determined the size of the table by checking the data space used in the table properties dialog box. Also, as the alter column was being executed I was watching...

Okay, I feel very silly, but figured out what the problem was. I was expecting just the file name to be in the FileName variable from the foreach loop container....

I tried it like this as well:

(DT_DBDATE)(SUBSTRING(@[User::FileName] , 1,4) + SUBSTRING(@[User::FileName] , 5,2) +SUBSTRING( @[User::FileName] , 7,2))

and I still received the error:

Error code 0x80020005 occurred attempting to convert from data...

Hi Jon,

I am using SSIS. Thanks for your reply, but I don't understand what you mean about the statement looks like I'm trying to cast a string as an int....

That's what I thought. Thanks for your responses.

Thanks for your reply. Yesterday I was able to loop through the directory and move all of the files and it worked fine. Then I tried to do what you...

That's the problem. This was a new server and we haven't been using the default instance. We installed another instance on the server that we've been using for development and...

We were not able to connect using DAC. We got an error that said Login Failed for sa. Does this mean that we have to reinstall or do we have...

No, we are going to try that right now. We tried connecting using the osql utiltiy, but that didn't work either. Our SysAdmin and I are new to this and...