AAAANDD... I found another boo boo of mine....

i had the ' being assigned in my script...

I think I need a vacation...

Ignore my previous question...

Removing the single qoutes near DMNID as such:

"UPDATE TB_DMNSTAGE SET DMN_STATUS = '" + @[User::DMNSTATUS] + "' WHERE DMN_ID = " + @[User::DMNID]

Gives me this error:

Error: Unclosed quotation mark...

"UPDATE TB_DMNSTAGE SET DMN_STATUS = '" + @[User::DMNSTATUS] + "' WHERE DMN_ID = '" + @[User::DMNID] + "'"

Gives me error:

Error: Incorrect syntax near '18'.

[Execute SQL Task] Error: Executing the...

Once again i mix up my vb with my sql... single quotes not double quotes!!! BAH!

DOH!!! :pinch:

Lol thanx!!