Thursday, July 03, 2008

Time Sindrome

From someplace.

Getting ConnectionString in a package in runtime

I had a question, if i have to get the id country from a connection string, so i said yes, but i haven't done never, so i start to search in google, and in a few minutes i found the answer in this link.

So i create a simple package and start to prove, mi package look like this:



then, i add a script component



then, the code, re-very little =)



then, it works =)



thats all, read the link.

@@ERROR in t-sql @_@

Well, i have a stored procedure that fail in some part, in a delete statement, but the sp continue running, and execute the next sp, something like that
CREATE PROC _SP_WRAP_ALLSP AS
EXEC SP1
EXEC SP2
.
.
.

Well, if a error ocurred in SP1, the _SP_WRAP_ALLSP continue with the next SP2,
then if you want to find a error, you have to use @@ERROR, like this link mentioned, and something else you get a code error, but what does it means? well sys.messages answer your question.

Bye