The project that I am designing in my ssis project requires me to constantly change my tables and their column types. Its a big project so when I...

Then the code page needs to be 65001. The data imports fine with me with that setting:

• This reply was modified 2 years, 7 months ago by Thom A.

What encoding is the file saved in? UTF-16? UTF-8? Something else?

I can see you've got it set to "code page 1252" there; that's a strong suggestion the file is being read as a DT_STR not a DT_WSTR.

Seems you are using a varchar somewhere, or you've defined the column as a DT_STR rather than a DT_WSTR in your SSIS task.

For reference, there has already been some troubleshooting on this over on Stack Overflow, where there is some additional information in the comments.

The fact that you're using a loop sounds like there are other problems too. T-SQL is a set-based language and so excels at set-based solutions. Conversely, it doesn't perform well...

Why do you want to reseed the value? You only DELETE the rows with a ID of 1, 3, and 5.  If you reseed the IDENTITY (so that the next...

• This reply was modified 2 years, 7 months ago by Thom A.

Also, for those interested, this error occurs at compile/parsing rather than at execution. Take the following:

SELECT 1/0;

SELECT CASE WHEN 1 = 0 THEN NULL END;

You might expect...

If you get an error, what is that error?

The error specifically states it can't be a...

Also, to support Thom on his claim that 3 and 4 part naming has been deprecated, take a look at the following article written by a really smart fellow...

I used to be on this...

3+ part naming for columns is (due to be) deprecated, so get out of the habit of their style. Instead, alias the object(s) in your FROM and then qualify the...

• This reply was modified 2 years, 7 months ago by Thom A. Reason: Add about delimit identifiying

I think the topic is "bugged"... I got a notification of a response from Scott, and the forum shows they were the last to reply, but I don't see it......

• This reply was modified 2 years, 7 months ago by Thom A.