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,...

Nice question, made me do some research.

unnati.patel513 (4/14/2014)

---

Hi,

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...

Motomoto (4/14/2014)

---

Can anyone provide me the best practice procedures for deploying SSIS and/or SSRS from the development environment to Test and finally Productions. I am trying to set up procedure...

What helped when I was doing the exercise was turning off the firewall.

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...

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)...

Great question, thanks.

Jeff Moden (4/10/2014)

---

Heh... gotta give 'em time...

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...

aaron.reese (4/10/2014)

---

+1 from me

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...

KoldCoffee (4/9/2014)

---

No Phil, that is not correct. You wrote to go to Advanced Editor of Flat File Source. But you didn't say to go to the Connection Manager...

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...

MysteryJimbo (4/10/2014)

---

I have to agree with a lot of whats already been said. On their own these low level certificates are not going to get you a job as...

No problem. 😉

There is an "edit" button by the way. 😀