Paramters button?

FIFO - that's weak but expected.

Thanks

How does it know what order gvOne and gvTWO should be placed in in the statement?

sp_Bob ? (gvTWO),? (gvOne)

Thanks!

Gift Peddie, what is this BI cert you mentioned?

Hi

Right on man, thanks a ton.

The first statement worked, the second did not.

"sp_Bob @FName = ?" works

"sp_Bob @FName = ?gvFName" does not work

Now I remember how happy I was to...

Thanks!

I will look at all those places.

**Edit - one of our guys deleted and recreated it before the soultion was found (probably happen again

How do I get it to "generate a script of the changes it was going to make?" I seem to only have a save error file option.

Howdy

Table is dbo.tblbob

I should have said "we all have dbo permissions, i believe some even have admin."

I was hoping someone had seen this error before.

Lol.

Nothing. That's the problem.

Ended up restarting and it worked fine.

Got it I think,

=IIF(Fields!Q.Value = 1,"January " & Fields!Y.Value.ToString,IIF(Fields!Q.Value = 2,"April " & Fields!Y.Value.ToString,IIF(Fields!Q.Value = 3,"July " & Fields!Y.Value.ToString,IIF(Fields!Q.Value = 4,"October " & Fields!Y.Value.ToString,""))))

I guess I could just hardcode...

I need to know something similar.

Did you happen to find an answer?

Actually it looks like you are using Jamies way - http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx

You should be able to use this...

Ok - I tried it out (copying the flow from what the wizard does), but now I am getting this error:

...failed with the following error: "The COMMIT TRANSACTION...

Yep.

http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp

Hans, no harm no foul.

I'll have another post later about passing variables from an "execute package task" to the dtsx it is attempting to execute. If that is possible and...

excellent Carlos