You just answered a five-year-old post - hope that...

Koen Verbeeck (11/18/2013)

---

I think the limit in SSIS is smaller.

I've had issues with very large SQL statements in Execute SQL Tasks, but they were less than 64K...

Batch size.

Have a look at this page. All sorts of useful info on limits there, including max. batch size.

Nomvula (11/17/2013)

---

thank you Phil for the quick response

i've managed to find the error after going through my script task over and over again and found that i didn't assign the...

Have you tried putting a breakpoint in the script task and then stepping through it line by line to determine exactly which row is generating the error? Might help you...

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

Try using SELECT instead of PRINT.

Nevyn (11/13/2013)

---

You don't need powershell if you don't want it.

An article in doing this in SSIS with scripts:

http://www.blue-chip.com.au/ssis-file-with-header-detail-trailer.aspx

Basically reads the file as non delimited and parses it in a script...

I would start by taking Excel out of the equation. Output the data to CSV (or fixed-width) and work from there.

SPtiruttani (11/14/2013)

---

Dear All,

I need the to subtract the value from the previous record and insert into another table

Declare @temp Table( [DeviceID] Int,[ctDate] DateTime,[Value] INT )

Insert Into @temp Values(1,'20131114 00:00:00',10)

Insert Into...

Does your SQL Agent proxy credential have access to the file? Is it a domain account?

Have a look here and see whether it helps.

The proxy account also needs to be associated with the SSIS subsystem, I think.

OK, maybe you could put some more sophisticated error-handling in the script in an effort to work out exactly which row is causing the error. I don't remember having any...