Which version of SSRS? 2000, 2005, or 2008?

No. You don't convert. Just create the datatype as type Nvarchar(Max). It's really that simple.

EDIT: SQL Server will known how to handle your datatype and will only use the amount...

I did read your first post. You didn't say anything about "passes" in that post. Hence the reason I asked the question.

As far as your primary key violation goes... Is...

sqldba_icon (10/18/2010)

---

Thanks Brandie, and i was refering to Wayne's statement. There is limit of 8000 characters on nvarchar and my sql dynamically generates more than 8000 characters of code and...

Gianluca Sartori (10/18/2010)

---

Well, I was wrong.

When I see things like "plz" and "How can i write the Sp PLZ let me...

Noes! U cantz haz cheezburger!

But u can haz lazanya.

You've heard the old adage, right?

If you're not making mistakes, you're not actually working. @=)

You may have a set of disks built for ghosted workstations. I.E., someone built the disks specifically for client tools only.

I love polite respondents. Heck, I love people who actually respond once you give them advice. It's nice to know when advice doesn't go down the rabbit hole and who...

Glad I could help. Please let us know if you have any additional questions.

I assume this is in SSIS? You're using the Script Transformation Editor?

What exactly does your input and output data look like (examples, please)? Are you pulling from SQL Server or...

Aha. There are similarities in this code for what I did as an article today. Using spaces to alter character case. In this situation, though, I'd advise looking at the...

You don't completely...

You need to follow both Gail's and Jeff's advice. You can embed a REPLACE inside of a CONVERT to fix the hypen problem, then switch that column to datetime or...

Sounds like you need to use some ANSI searches to find those. What's your collation set as, BTW?