Are you exporting to the right format? UTF-8 vs ANSI

What is the data type of the columns?

Congrats!

One day I'll catch up... 😎

How do you call the stored procedure?

That's not possible in SQL.

You need to write two seperate queries and choose between them using an IF statement, or you construct your query dynamically and execute it with sp_executesql.

I use using as well.

I think it doesn't make a difference:

http://stackoverflow.com/questions/11401364/performance-between-importing-entire-namespace-versus-using-alias-in-c

Copy paste your column contents in an empty query window.

Hit F5.

Just checked it, the syntax is like this:

Dts.Variables["User::MyVariable"].Value.ToString()

Nice question, thanks.

Greg Edwards-268690 (2/18/2014)

---

Koen Verbeeck (2/18/2014)

---

Steve Jones - SSC Editor (2/18/2014)

---

Ed Wagner (2/17/2014)

---

EL Jerry (2/17/2014)

---

G'Day Everyone!!

Have you noticed the community has grown over 1.7M members?

Congratulations to Steve et al...

There's one in every family...

:hehe:

What happens when you build the script component[/url]?

Steve Jones - SSC Editor (2/18/2014)

---

Ed Wagner (2/17/2014)

---

EL Jerry (2/17/2014)

---

G'Day Everyone!!

Have you noticed the community has grown over 1.7M members?

Congratulations to Steve et al who founded it, keep...

Hany Helmy (2/18/2014)

---

Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by...

I use the placeholder as well.

Because you only just started recording history, the initial load is the representation of the "single version of facts" by the source system as it...

DT_(N)TEXT is a CLOB format. In order to convert it to a regular string, you need to use a script component.

Google for ssis script component convert blob to string and...