Viewing 15 posts - 3,661 through 3,675 (of 11,678 total)
Are you exporting to the right format? UTF-8 vs ANSI
What is the data type of the columns?
February 19, 2014 at 2:10 pm
SQLRNNR (2/19/2014)
Yay - I'm finally insane!!! :hehe::w00t:
Congrats!
One day I'll catch up... 😎
February 19, 2014 at 12:54 pm
How do you call the stored procedure?
February 19, 2014 at 7:15 am
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.
February 19, 2014 at 5:44 am
I use using as well.
I think it doesn't make a difference:
February 19, 2014 at 4:29 am
Copy paste your column contents in an empty query window.
Hit F5.
February 19, 2014 at 3:56 am
Just checked it, the syntax is like this:
Dts.Variables["User::MyVariable"].Value.ToString()
February 19, 2014 at 2:49 am
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)
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al...
February 18, 2014 at 2:58 pm
Evil Kraig F (2/18/2014)
I don't use C#, I use VB.NET, ...
There's one in every family...
:hehe:
February 18, 2014 at 12:42 pm
February 18, 2014 at 12:28 pm
Steve Jones - SSC Editor (2/18/2014)
Ed Wagner (2/17/2014)
EL Jerry (2/17/2014)
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al who founded it, keep...
February 18, 2014 at 12:08 pm
Hany Helmy (2/18/2014)
February 18, 2014 at 1:28 am
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...
February 18, 2014 at 12:37 am
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...
February 18, 2014 at 12:04 am
Viewing 15 posts - 3,661 through 3,675 (of 11,678 total)