Viewing 15 posts - 3,271 through 3,285 (of 11,678 total)
About uncompressing the CLOB: you should talk about your Oracle admins on how to do that.
Regarding storing the XML: I would store it in a VARCHAR(MAX). If you use XML,...
April 15, 2014 at 4:09 am
unnati.patel513 (4/14/2014)
Thanks you very much for your reply but my problem is i can write sql code but i can not write script task(C# Code and VB code)
I really appreciate...
April 14, 2014 at 11:54 pm
Motomoto (4/14/2014)
April 14, 2014 at 12:29 pm
What helped when I was doing the exercise was turning off the firewall.
April 14, 2014 at 12:28 pm
You can read the first line using a simple script task, parse it using the delimiter using the String.Split function and count the number of items returned.
You can find the...
April 14, 2014 at 12:26 pm
Try using an expression on the source component to construct the SQL statement instead of using a parametrized query.
Something like this:
"SELECT ColA, ColB, ColC
FROM TABLE_DTL
WHERE LastModifiedNumericDate > " + (DT_STR,10,1252)...
April 14, 2014 at 12:22 pm
Great question, thanks.
April 14, 2014 at 10:27 am
Jeff Moden (4/10/2014)
Koen Verbeeck (4/2/2014)
Jeff Moden (4/2/2014)
Heh... waiting for SP1. 😉Good grief, there may be 25 CUs released before they even think about an SP 😉
Heh... gotta give 'em time...
April 11, 2014 at 6:36 am
Some very nice words about some thread people and these forums in general:
http://www.sqlservercentral.com/Forums/Topic1553867-364-1.aspx (at the end of the thread)
The highlight:
In general this board is the most friendly and active technical...
April 11, 2014 at 6:30 am
aaron.reese (4/10/2014)
Phil, Gail and Koen are some of the most generous and helpful forum members on any board I visit and their opinions and advice have saved...
April 11, 2014 at 6:28 am
KoldCoffee (4/9/2014)
April 11, 2014 at 6:27 am
I would put the file growth of your data file a bit higher than 5MB.
Say you reach the limit of the database file but it doesn't have to grow yet.
The...
April 10, 2014 at 5:56 am
MysteryJimbo (4/10/2014)
April 10, 2014 at 5:13 am
Michael_Garrison (4/10/2014)
Dang, sorry spelled "Koen" wrong.
No problem. 😉
There is an "edit" button by the way. 😀
April 10, 2014 at 5:10 am
Viewing 15 posts - 3,271 through 3,285 (of 11,678 total)