Hi all,

Because it won't return the same number every time. In my I just wanted to keep it simple; I knew that the issue I was havng was syntax....

Yeah, that's what was weird to me too. But if I have to use the "else" condition, I'll just set it to 0.

Strick

Sweet thanks! Actually my expression will always return a value. I guess I'll just set the ternary = 0 even though it'll never happen.

Thanks,

Strick

Thanks all.

Its more for organization than anything. When I look at the AdventureWorks SQL database that ships with SQL 2005, I like that all the production tables are together,...

Great thanks. I noticed that one. So JobAgentID property actually representts the name of the job?

Thanks,

Strick

Hello,

Ok, I didn't notice the Execute SQL Server Agent Job Task. Looks like this will execute a SQL job. My question now is how would I go about...

I have a process like this that works great. I have to load files in from a client and they send the damn files as csv and tab delimited....