SUBSTRING(CDATA_6,1,FINDSTRING(cdata_6,'|',1)-1)

What error do you get 1% of the time?

Nice question, thanks.

killbob75 (10/22/2014)

---

Cool.

I've had more of a hunt around where it was going wrong, and it is looking like the cell it is having trouble filling would contain what is basically...

If I understand it correctly, you have two tasks connected to the Send Email Task with OnFailure precedence constraints?

By default, multiple precedence constraints are combined using the AND constraint, meaning...

Yes, dtexec is used behind the scenes.

What are the errors?

Either you are trying to put unicode data into a non-unicode column (or vice versa) or one of your columns isn't wide enough.

Check the mappings in the wizard to find...

Raghavendra Mudugal (10/22/2014)

---

ksatpute123 (10/22/2014)

---

Raghavendra Mudugal (10/22/2014)

---

Thank you for the post, really eye opening.. And really had no idea what this was.

I read it and without any research, i selected the...

saxsena_sanjay (10/22/2014)

---

Koen Verbeeck (10/22/2014)

---

You can add a row number to each line with ROW_NUMBER(). Filter on non-zero quantities and get the minimum row number. Substract this from the maximum ...

You can add a row number to each line with ROW_NUMBER(). Filter on non-zero quantities and get the minimum row number. Substract this from the maximum row number.

What is your expected output?

Add a row number with ROW_NUMBER() OVER (ORDER BY Timestamp).

Find the row where Manual = 10 and get its row number x. The row you seek has row number (x...

The question said:

A DONEPROC token is sent for each SQL statements within a...

Never heard of it. Probably will never use it. Misread the documentation and got it wrong.

Nice question though 😀

venus.pvr (10/21/2014)

---

Thank you Koen,

With SSIS package logging, I mean the sysssislog system table. We dont have any user databases in SQL server. We use sql server only for ssrs, ssis...