--removed

This suggests a change to the package has been made.

It suggests that the package protection level (see here) has been set to encrypt sensitive with user key.

mohammed.mazahr (7/17/2015)

---

Dear All,

I would like your help in solving the following issue using the Patindex function i cannot retrieve or extract the single numeric value as an example in...

Why are you ignoring my suggestion?

nidhi.naina (7/17/2015)

---

I was trying to get a solution and came up with this -

select * from table WHERE ISNUMERIC(LTRIM(RTRIM(Capacity))) = 1 AND Capacity < '0'

It is working fine...

nidhi.naina (7/17/2015)

---

i Have a table with a column Capacity which is char(10) and gets populated from user files. I want to check records which have negative Capacity value. So i...

You are not alone! This has been raised before and, for reasons which are beyond my comprehension, dismissed as...

Hit Edit again.

sqlnaive (7/16/2015)

---

Apart from the above got the two following errors as well

Error: 2015-07-16 10:15:40.57

Code: 0x80004005

Source: Generate Sales Data File

Description:

End Error

Error: 2015-07-16...

Can you get a more comprehensive set of errors from the 'All Executions' report in SSISDB?

Foxbase?

Terminate = roll back? Or what, exactly?

SET XACT_ABORT ON

may be...

And if that means deleting millions of rows in any of the tables, you should consider implementing a batch delete process to avoid excessive locking and TLog growth.

Some ideas:

1) Add a script task to conditionally delete the file before trying to import it.

2) Call a batch file to delete all files of 0 bytes before trying to...

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during...