All,

I my opinion, this is a big bug by MS in SSIS. There is a very simple effective workaround that works bullet-proof. Never import directly from Excel. Open the Excel...

Folks, there is a limitation to PRINT. It can print 4000 nvarchar() and 8000 varchar().

After sending out my previous message, I realized that the solution is even simpler than what...

I experienced the same problem of printing nvarchar(max)/varchar(max), with truncation at 4000/8000 characters. I strongly agree: it's a bug (while Microsoft insists it's a feature). I found a very simple/effective...

The trigger is very spiffy. Really good!

Mike V