No problem - it's pretty much the same as I described in my previous post.

The ExecuteSQL task will run the proc.

The proc will return a result which can be stored...

That's nice & easy.

Here's one way:

1) Create an integer package variable - say NumRows

2) Create an ExecuteSQL task to get the table's rowcount & return the result into NumRows. (You...

jampabsatish (6/4/2013)

---

Hi Brandie,

I'm facing the same issue but not able to figure out wt the issue is .

Im attaching a screenshot of the same error i got . could you...

Is there a chance that any of the values in pehPErcontrol is not a valid...

Ah - sorry - that came in a later version of SQL Server.

Try 'datetime' instead of 'date'.

select cast(left('201301042',8) as date)

Here is a small piece of code to back up my assertion that this is a datatype problem:

if object_id('tempdb..#ex', 'U') is not null

drop table #ex

create table #ex

...

If field2 is a datetime, trying to return 'nothing' if it is null will be giving the database engine a headache in terms of mismatching data types.

Instead, maybe try returning...

I just created a text file to check this. It parses for me.

--Edit: added screen shot

bobd125 (6/3/2013)

---

I need help trying to figure out what caused this error. I threw some Messagebox.Show in the script but they never get to appear? I'm not that...

homebrew01 (6/3/2013)

---

That is what I do. Then it goes yellow as it runs, and I hope green when it completes. But I cannot right click/execute the next task without first...

What do you mean by 'wrong'? Looks OK to me. Does it not parse?

You can right-click on a task and select 'Execute Task' - is that what you're after?

Well, I counted only one colon (:) even though you have two conditions. Everything needs to balance.

No nesting:

expression1?true1:false1

Insert one level of nesting:

expression1?(expression2?true2:false2):false1

KoldCoffee (6/2/2013)

---

so this is working

--snip

I've tried this but it doesn't...