I, personally, tend to use the expressions on properties of the connection manager, rather than the tool you are using there.

Did you do as the error suggested? What were your findings? We can't see the expression, or the data types, so you need to give more information here.

So you're trying to dynamically get the columns from the XML and (presumably) dynamically insert that into the appropriate columns? Then you are going to need dynamic SQL; you can't...

Does your XML always have the same nodes?

Unfortunately, I can't run the above, it initially gives an error about the scalar variable @MLID not being declared (more on that later), and then if I do define it,...

Design your tables to be appropriate for the data you need to store. If you need to store things like names, addresses, DOB, and passport Numbers, create all those columns...

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 1 year, 11 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 1 year, 11 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...