I'll agree with this. In our neck of the woods, particularly, Access seems to take the most heat. That's primarily because it's used and abused compared to what...

Paul White NZ (12/13/2010)

---

Craig Farrell (12/13/2010)

---

Alright, I'll bite. Anyone know how to turn a column from a stream in an SSIS package into a non-nullable version of itself? ...

GilaMonster (12/13/2010)

---

only4mithunc (12/13/2010)

---

Here my doubt is in this case as we are not able to use sp_executesql (due to the vary large length of the string), then how can we...

GilaMonster (12/13/2010)

---

The last post by the Original Poster (OP) stated that he's going to read over that blog post in detail. Hence he...

Yeah, this basically creates a oneshot job that runs under your rights, but I'm unfamiliar with that error occurring.

Best bet is to plug it in entirely into google and see...

Jack,

This is close. I *believe* it should work for you, but I didn't have a chance to expand the dataset to make sure I didn't step on anything. ...

Jack,

How are you deciding which AcctStatCD to use here? Is it always the final one, can it be any, or is there a precidence order? For example, in...

No, but you can minimize the impact. Create a new table with the schema you need, and load it. Then swap the tables with two calls to sp_rename....

Can you give us some more information about what you're using to copy the database? How did messenger and NetSend get involved here?

I believe you can avoid this by persisting the results of the function in the table.

I *think* I've also seen this error when I was only replicating specific tables and...

What are you using to redirect the error?

I personally would use a conditional split with a bunch of rules to send any failed item to a separate stream, and then...

Can you try a workaround for me? Login to the SSIS server via SSMS, go to Stored packages, and rt-click 'import package'. See if you can import it...

While I fear I won't be able to compete with Gary, I'll toss my hat in on this contest. Makes the most sense for me.

Having consulted a while, every...

Simple trick we used to use was to RDC into the box and check the TSR tray in the bottom right for the VM software.

Dave Ballantyne (12/13/2010)

---

Craig Farrell (12/8/2010)

---

I believe that a function called for a row with the same parameters as other calls is 'remembered', but I'd have to do some testing to...