opc.three (6/6/2012)

---

gravitysucks (6/6/2012)

---

I...

I have been...

opc.three (6/5/2012)

---

Right-click your Control Flow design surface and choose Package Configurations...

Click Enable, then Add, and you can choose SQL Server:

Look for the "SQL Server Configurations" section in this article:

Understanding Integration...

Or could it be that SQL Server Configuration is only available when the deployment method is "SQL Server". Here I did a file system deployment and for security issues...

opc.three (5/24/2012)

---

Koen Verbeeck (5/24/2012)

---

opc.three (5/24/2012)

---

The two Execute SQL Tasks you mention point to the same database, using the same connection, sounds good. What happens to that transaction if an exception...

Lynn,

Actually I need to use...

Lynn Pettis (4/26/2012)

---

MisLead (4/26/2012)

---

Lynn,

Business Case is Simple. We have data flowing from a system that supports Unicode to the system that does not support Unicode and only supports ANSI standard...

Lynn,

Business Case is Simple. We have data flowing from a system that supports Unicode to the system that does not support Unicode and only supports ANSI standard characters. what would...

opc.three (4/26/2012)

---

I think MisLead (ironic name given the conversation, no? :-D) wants to store the data as NVARCHAR, but wants to provide an interface for this legacy app to get...

You keep asking for answers from us, yet you won't answer the questions we ask?

Again, what is the business case for doing this? What other alternatives have been considered...

There are many ways to accomplish the task, be it through T-SQL or SQLCLR, and while I empathize with your situation all methods are irrelevant if they do not do...

opc.three (4/25/2012)

---

Lynn Pettis (4/25/2012)

---

I am still waiting to here the reason for all this work? What is the case for doing it? What other alternatives are there that...

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

Please refer this. Its exactly what i mean-if you still have some time

I could see if you wanted to tear apart ? into two separate bytes...

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

Please refer this. Its exactly what i mean-if you still have some time

I could see if you wanted to tear apart ? into two separate bytes so some...

opc.three (4/24/2012)

---

Yes, Windows uses a double-byte character set internally, with encoding UCS-2...which is the same encoding SQL...