the first pic is the query that runs inside the oracle .

the second is how it should be in the ssis

i need to replace all the dates in that query...

thank you very much,

but i have to keep this format since i execute this string via EXCECUTE SQL TASK ( i send it to an oracel DB to run...

Ok after a couple of hours i figures what the problem is.

when the time (hours) is '240000' the query failed.

so i need to replace '240000' with '000000' and everything is...

avishain (6/25/2013)

---

ChrisM@Work (6/24/2013)

---

Something like the algorithms for obtaining datetime from sysjobhistory run date and run time:

SELECT

jh.run_date,

jh.run_time,

RunDateTime = x.RunDate + x.RunTime

FROM msdb.dbo.sysjobhistory jh

CROSS APPLY (

SELECT

RunDate =...

ChrisM@Work (6/24/2013)

---

Something like the algorithms for obtaining datetime from sysjobhistory run date and run time:

SELECT

jh.run_date,

jh.run_time,

RunDateTime = x.RunDate + x.RunTime

FROM msdb.dbo.sysjobhistory jh

CROSS APPLY (

SELECT

RunDate = CAST(STR(jh.run_date,...

ChrisM@Work (6/24/2013)

---

avishain (6/24/2013)

---

J Livingston SQL (6/24/2013)

---

do you have any other columns available that hold date info ...eg yyymmdd?

also what are you expecting to happen when the end time is two...

J Livingston SQL (6/24/2013)

---

do you have any other columns available that hold date info ...eg yyymmdd?

also what are you expecting to happen when the end time is two or more...

Lookup wont work since there is no common key between these 2 tables...

Works like a charm 🙂

thank you

the DS would be an XML file.... so i have to this within the ssis package 🙂