Excellent article. Thanks for sharing.

Don't forget that when you're working in activex, you have to use double quotes. In your example you're using single quotes.

Also remember that when you're building SQL statements in Activex,...

You do not need a global variable in the SQL task AADelete. The entire SQL statement for that task was formed in the Activex task...

Excellent! Thanks to John and Jeff.

Thanks, Jeff. There's a lot of stuff in that snippet, some of which I don't know, but in a little while I will. Thanks for pointing us in the right direction.

Jambu,

Thank you for taking time to share your knowledge with us. We have a copy of Erwin, but have not started using it because we lacked a nice tutorial like...

Thanks for responding, Jeff. Is there any chance that you have an example? When you get a moment, could you post it?

SQLtask AA  ----> SQLTask BB -----> ActivexTask  -----> DynamicProperties Task -----> SQLTask AADelete -----> SQLTask BBInsert

The activex task assumes that the previous two tasks have populated the global variables AACount...

Although I do not have the confidence that this is the best solution, this is what I would do: Archiving weekly data by means of a datapump. One SQL task...

In google do the following and you'll see that a stored procedure is a collection of SQL statements. If someone gave you one or more SQL statements you could write...

Thanks, bitbucket! It's a simple solution and thanks for telling us about it.

Thanks for y'alls reply.

Phil, I think SYSTEM_USER is what we were looking for. We'll know for sure when different users execute a stored proc and we log whodunnit with SYSTEM_USER.

Ninja,...

Elegant solution. I modified it after creating the table separately:

CREATE procedure usp_testUserID

as

 INSERT INTO dbo.ProcActivity (ProcName) SELECT OBJECT_NAME(@@PROCID) AS ProcName

GO

Is there any way to get the network userid? When I run...

Thank you for your suggestions, Jonathan. In the long run, standards and conventions are not for the brilliant innovator, but for the stalwart person who can keep an enterprise going....

Thank you for taking the time to share with us, Jambu. Maybe you were not able to help the geniuses, but it was very helpful to the rest of us.