Got it!!!

declare @MaxRowdateTime datetime

select @MaxRowdateTime = max(DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), starttime), 4), 3, 0, ':')) AS DATETIME2(7)))) from [avaya].[dbo].[hSplit]

select

DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT( TIME,...

Attached is the actual query I'm trying to use.

Evil Kraig F (12/3/2014)

---

Append it before you turn it into a...

Thanks. I'll take a look at it.

Thanks that worked. How can I concatenate this with a date field. neither '&' nor '+' seem to work.

Thanks all for the suggestions. I figured it out. One of the joined tables had been changed and field that was previously an integer was now a varchar. It was...

Thanks, that's where I'm focusing my search. So far no luck.

Koen Verbeeck (6/11/2014)

---

What if you delete the script component, add a new one and copy paste only the following piece of code into the main() function?

bool failure = false;

bool fireAgain...

Koen Verbeeck (6/11/2014)

---

craig.bobchin (6/11/2014)

---

I have it set to true for the connection manager which made no difference, but see no where...

I have it set to true for the connection manager which made no difference, but see no where in either package...

Koen Verbeeck (6/11/2014)

---

craig.bobchin (6/11/2014)

---

No error, it seems to just be passed by when I have bad credentials...

No error, it seems to just be passed by when I have bad credentials in the connection...

I would Do the following things in this order:

Pay off my bills

Buy a house where there are nice dark skies

Set up trust funds/savings/investments for my family (kids and grandkids)

Build out...