Persistant variables

Greetings SSIS friends.

Is it possible to create a persistant variable in an SSIS package?

dreameR.78 wrote:

Greetings SSIS friends.

Is it possible to create a persistant variable in an SSIS package?

Meaning what, exactly?|||

The variable retaining its value after the package is run.

|||

dreameR.78 wrote:

The variable retaining its value after the package is run.

I suppose there are progmatic ways of doing this, but the "easy" way that I can see is to use SQL Server based package configurations. At the end of your package, you issue an Execute SQL Task to update the configuration table to set the value of the variable in the table to that variable's current value.|||

Hi Phil,

I will try your suggested method.

Thank you.

Permissions to use SQLProfiler

Hi Friends...
I have some developers that need to use the SQLProfile to analyze some
queries, i dont want to grant them SA priveledges, so, what kind of
permissions needs these users?
Thanks allCan't do in 2000, I'm afraid. Need sysadmin. In 2005, you can grant permissi
ons to use profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:EEF2D9D2-3EF4-434D-9AD2-FC26CD2A87CE@.microsoft.com...
> Hi Friends...
> I have some developers that need to use the SQLProfile to analyze some
> queries, i dont want to grant them SA priveledges, so, what kind of
> permissions needs these users?
> Thanks all

Permissions to use SQLProfiler

Hi Friends...
I have some developers that need to use the SQLProfile to analyze some
queries, i dont want to grant them SA priveledges, so, what kind of
permissions needs these users?
Thanks all
Can't do in 2000, I'm afraid. Need sysadmin. In 2005, you can grant permissions to use profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:EEF2D9D2-3EF4-434D-9AD2-FC26CD2A87CE@.microsoft.com...
> Hi Friends...
> I have some developers that need to use the SQLProfile to analyze some
> queries, i dont want to grant them SA priveledges, so, what kind of
> permissions needs these users?
> Thanks all

Permissions to use SQLProfiler

Hi Friends...
I have some developers that need to use the SQLProfile to analyze some
queries, i dont want to grant them SA priveledges, so, what kind of
permissions needs these users?
Thanks allCan't do in 2000, I'm afraid. Need sysadmin. In 2005, you can grant permissions to use profiler.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:EEF2D9D2-3EF4-434D-9AD2-FC26CD2A87CE@.microsoft.com...
> Hi Friends...
> I have some developers that need to use the SQLProfile to analyze some
> queries, i dont want to grant them SA priveledges, so, what kind of
> permissions needs these users?
> Thanks all

permission over excute SP

Hi Friends,
I want to create an DB_role with the target to give the excute SP
permission to some users and when i create a new SP these users acquires the
permission over the new SP.
A lot of thanks for our possible help.
WalidI don't personally use this method, but you could try adding the stored
procs to a schema and granting the database role containing your users
execute permissions on the schema. That way, any new stored proc would be
added to the same schema and the users inherit exec permission.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Using SQL Server 2005 this is GRANT EXECUTE TO [SomeUser]
HTH, jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--

permission over excute SP

Hi Friends,
I want to create an DB_role with the target to give the excute SP
permission to some users and when i create a new SP these users acquires the
permission over the new SP.
A lot of thanks for our possible help.
WalidI don't personally use this method, but you could try adding the stored
procs to a schema and granting the database role containing your users
execute permissions on the schema. That way, any new stored proc would be
added to the same schema and the users inherit exec permission.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Using SQL Server 2005 this is GRANT EXECUTE TO [SomeUser]
HTH, jens K. Suessmeyer.
http://www.sqlserver2005.de
--

permission over excute SP

Hi Friends,
I want to create an DB_role with the target to give the excute SP
permission to some users and when i create a new SP these users acquires the
permission over the new SP.
A lot of thanks for our possible help.
Walid
I don't personally use this method, but you could try adding the stored
procs to a schema and granting the database role containing your users
execute permissions on the schema. That way, any new stored proc would be
added to the same schema and the users inherit exec permission.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Using SQL Server 2005 this is GRANT EXECUTE TO [SomeUser]
HTH, jens K. Suessmeyer.
http://www.sqlserver2005.de