Re: Open DTS saved as .bas

Hello Lisa,

If you look at the code you will see a section that lets you choose to execute the code there and then or it allows you to save the package back to SQL Server. It is this latter option you will need to choose.

Allan

I have saved my dts as a vb file, made changes and now I want to open
it again using Enterprise Manager.  How can I do this?



.

Relevant Pages

  • Re: processadmin cannot kill
    ... It is not required to stop and start sql server after giving a role. ... Execute sp_who to identify the process id and execute KILL to kill a ... Once you are ok with this, try killing the process from Enterprise manager ... > problems with a user not being able to kill processes. ...
    (microsoft.public.sqlserver.security)
  • SP execution
    ... I have a stored procedure with parameters in SQL Server 2000 database. ... I execute it in Enterprise Manager, it takes less than 1 second to return ...
    (microsoft.public.vb.general.discussion)
  • Re: C# and SQL-Server Stored Procedures
    ... Run Sql Profiler and see if the procedure is being called at all. ... can be launched from Enterprise Manager (Sql Server 2000) or Sql Server ... But if I trie to execute it from C#, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)