You know, all along I knew it was going to be something little, because all the big stuff looked good. And quite frankly the devil is in the details.....

GSquared (11/18/2009)

---

Of course, this isn't a big deal. It's a minor difference. There are advantages and drawbacks either way. I see the advantages for Select Into as...

GSquared (11/18/2009)

---

I think some people are still looking for a magical transformation, not an evolution. I expect an evolution. And I expect that it will be incremental, and...

Lynn Pettis (11/18/2009)

---

Interesting that you mention Dataphor. There have been others that have been religous zealots...

I agree this WAS true, up to SQL 6.5, but at 7 and...

I have had a chance to play with SQL Audit and it is awesome.. But if you enable some features you get WAY TOO MUCH data and you take...

What is it that you want to have in the log, the fact that an action took place and/or the before/after data.. Also the edition of SQL may matter..

CEWII

I take it that the 84 structures are different..

Basically with SSIS all you can really do is build a package programatically and then execute it.

The big issue is that the...

Have you checked the windows firewall to make sure it isn't preventing connections?

CEWII

"Class not registered" rang some bells with me.. The SQL server is 64-bit? I'm guessing that the OLE DB provider is a 32-bit only provider OR that you...

Well, I disagree that much is fundamentally wrong, so...

You are welcome. There are a lot of nuts and bolts in SSIS that can be twisted.. It is things like this that we learn the most from..

CEWII

I think GSquared and I are having philosophical differences today. I generally don't do SELECT INTO because at design time I want to know exactly what the structure and...

I think your XSD needs to change, the value in the file is not satisfying the type specified. If the value is really an integer then the XSD needs...

I think the trace is your best best, you should be able to see the command that is running as opposed to what you think is running..

CEWII