Thank you . it worked.

I had to re-generate the connection within the package for Iseries ODBC. I deleted the old connection and created again , it worked.

Apperciate your...

Thank you.

Tried changing protection level of package with SavenSensitiveWithPassword and supply the password same as SQL Server Agent.

Runs fine in BDIS or when i execute package. It...

EncryptSensitiveWithUserKey

Thank you for replying query. Can you please share SQL and report soulation ?

Thank you for suggestion. Change the with clause and it worked.

Thank you. Apperciate your help.

Apology for the question format. I will be careful next time. 🙂

once again thank you ,

it worked.

Perfecto, Thank you so much. Apperciate your help

Thank you. it worked.

Thank you. It worked

Hi

how do i add column name at the end

DESCRLONG as 'Case Description' ??? currenlty it display the information as 'No column Name'

CASE

WHEN DESCRLONG LIKE '%The...

Thank you Maleswara

it worked

CASE

WHEN DESCRLONG LIKE '%The incident occurred time%' THEN substring(DESCRLONG,PATINDEX('%The incident occurred time:%',DESCRLONG)+28,8)

ELSE

CAST(DESCRLONG AS VARCHAR(1000))

Thank you for your help.

apperciate

We are getting data from website like

'Wrong day The incident occurred date: 4/18/2012 The incident occurred time: 6:45 AM This incident report is for...

great !! Thank you.

Thank you for sharing the information. The indexes we rebuilt were created by oracle/peoplesoft. We use CRM module of Peoplesoft.

It worked. I was trying with my credential which didnt have proper authority. I tried with "sa" it, worked.

Thank you for your help. Apperciate.