Chelski_blue (7/17/2015)

---

So opened the package and changed the setting (having finally found it) to use EncryptSensitiveWithPassword. The package executes ok now through the Execute Package Utility, but pending confirm...

nidhi.naina (7/17/2015)

---

Thanks.

So you think there can be some other options? As i have quite a few checks in where clauses for different tables and columns.

Or should i go with...

Give me some examples please.

Simplified version.

select *

from

where try_parse(Capacity as int) < 0;

nidhi.naina (7/17/2015)

---

Gosh... I am sorry i am not ignoring... i trying to find some simpler way if any else i have your suggestion in store. Looking for something easier as...

Srikanth vathsala (7/17/2015)

---

Hi Nidhi,

Try this,

Declare @k char(10)

Declare @l as Char(10)

Set @k ='-88'

set @L = '88'

Select IIF( ISNUMERIC(@k) = 1,

Case

When Cast(@k as integer) > 0 then 'Positive'

When Cast(@k as integer)...

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