Phil Parkin (11/17/2013)

---

I have a string variable which stores a big set of sql statements, ie insert statements. The insert statement intends to inserts about 200K rows with 10 columns (Lots !)

I think that my package always fails when the SQL string is this big. So, I was wondering if there is any limit on the size of the sql string ? It shows no errors or warnings.

Yes there's a limit. I searched Google and found it in two minutes. Have you even tried?