Lynn Pettis (2/10/2011)

---

Depending on how many posts per page you have...

You can import it as varchar to test the truncation errors, and convert it to nvarchar in the pipeline using a data conversion component.

About some 2380 pages ago 😀

Mark F-428640 (2/10/2011)

---

hey Koen thanks for your response just to be clear when you say set the input column to a string length of 1. Are you referring to the...

The name is indeed, quite dead. I decided it was time to grow up and lose the nickname I invented when I...

SQLSmasher (2/10/2011)

---

It is quite good question for initial telephonic interview. And you can give simple answer by

1. CONVERT is SQL speicific but CAST is ANSI standarised

2. CONVERT deal nicely...

And even if it was, it would be a lousy one.

If I'd want to check syntax and...

Don't cast it. Just pull...

Where did you configure that the input could only be nvarchar(1) long?

abhas (2/10/2011)

---

Hi,

I am having a folder say folder1 and in that folder another folder's which are compressed folders.I want to extract that compressed folders.These folders are compressed by built in...

Mark F-428640 (2/10/2011)

---

Thanks Koen for your response and yes my apologize this is a SSIS related question.

I tried your suggestion of pushing a larger string in a smaller string field...

Is it possible to provide us with sample input data and the desired output data?

That way it is more clear what you want to achieve.

I didn't really find evidence that you can extend the trial period.

You can however turn back your system clock:

http://shahfaisalmuhammed.wordpress.com/2010/02/22/sql-server-2008-evaluation-edition-upgrade/

Is it a production server? If yes, shame on you 🙂

You should mention it is a SSIS related question, so people can place it in the right context 🙂

My guess is that since the CAST function fails, the whole statement...

I can't imagine any of these as a real name 😀