I'll start out by saying I have nothing new to add to any of the previous comments. However - you seem to be very eager to achieve this. ...

You need to look at the advanced properties of the "flat file source". I'm thinking it's trying to "default" to 50 characters on that column, and your path is...

I just came across something on the MSDN web site that implies that that particular error would be resolved in SP1 for SSRS 2005. Have you patched your 2005...

Cursor would be about the last thing I would use to import old data. I would usually use a staging table (something with no major constraints, strings attached, etc...)...

Grant Fritchey (3/12/2008)

---

I ran into a problem. It didn't prevent 2005 from working, but it did cause parts of the GUI in SSMS to stop working. I would be very...

Hey hey hey....

As the famous line from Monty Python's Holy Grail...

"I'm not dead yet...."

My biggest curiosity - why are we discussing VisualBasic homework in a SQL forum? The homework pretty much shoots any ability to leverage SQL Server, and I'm pretty sure...

Well - division and multiplication have same precedence in SQL Server's implementation, so in SQL's world - the answer is 4....

In just about every math text I've ever seen, multiplication...

I know I'm showing late to the party - but is there any chance to make that a covering index? Assuming those extra fields aren't ludicrously long - you'd...

TheSQLGuru (3/12/2008)

---

Of course, I got a good deal of attention in my last interview (for my current job) by putting my volunteer Online RPG Admin experience on my resume. ...

Considering you are looking to "export to XML" - you should write the Stored procedure using the FOR XML PATH clause (so that the results are returned as XML). ...

That error seems to imply that SSIS thinks you're importing UNICODE data. Have you tried using nvarchar fields instead?

Nesting level tells me you likely have a trigger that's firing over and over and over again. If a trigger is set up in such a way as to...

Jeff -

Today, one of my colleagues mentioned to me that this very metric was repackaged and turned into a Code review package.... I thought you might enjoy it....:)

http://www.crap4j.org/%5B/url%5D

Sadly...

Oh so do I (enjoy the jousting as you describe it). it stretches the mind.