Ah well, your question is indeed more clear now 😀

If you have "regular" strings, aka non-unicode, you need to specify a code page that describes how the characters needs to...

Check out this thread on the MSDN forums:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/a667c6d6-21b9-4f8d-9a74-1aeaf235f85b

😉

To convert the strings to unicode strings. 😀

In SQL Server, this is varchar versus nvarchar. Unicode can handle much more special characters...

Great question, thanks Hugo.

In the Flat File connection manager, you can set the code page to UTF-8.

A trick that usually works is having a dummy row right below the headers. This dummy row will contain date values, so the JET provider will normally insert the data...

You cannot do this in SSIS directly.

But there are some other options:

* use an Execute SQL task to transfer the data. In the INSERT statement, you can use the OUTPUT...

Your problem is probably related to this one:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/de4607a6-27b2-4934-b767-3ce6cc93e334/

Usually re-installing BIDS helps.

Good question, thanks. The MSDN article doesn't specify the precedence of the date datatype, so there was some guessing involved.

Jim Murphy (11/9/2011)

---

GilaMonster (11/9/2011)

---

Haven't you forgotten the old saying...

L' Eomot Inversé (11/9/2011)

---

Koen Verbeeck (11/8/2011)

---

L' Eomot Inversé (11/8/2011)

---

The next bad normalisation myth is that normalisation always increases the amount of storage required - a database in 3NF will require...

Are you using SSIS 2005 or 2008?

I can use the Excel connection manager for Excel 2007 without a problem.

You need to ask Microsoft that question, not some unknown forum members.

I guess you need the cumulative update package 6 for SP1. So sp1 alone is not...

So you are saying your queries take up more than 2147483647 bytes? In other words, more than 2 gigabytes? I find that somehow hard to believe. If it is the...