Try granting VIEW DEFINITION permission to the users in the database.

I haven't heard this is true and can't find any confirmation, even with a Google search. I kind of doubt that SSIS could use a binary .dmp as a...

To tell the truth, I haven't figured out how to give a developer access to DTS packages in SQL 2005. As for jobs, check out the SQLAgentReaderRole database role...

Good point, Ed. I use the DTS editor a lot since we still have many DTS packages in our SQL 2005 instances. Almost all of our production packages...

The SQL Server Upgrade Advisor can give you a list of things that will need to be changed to upgrade a DTS package to SSIS. If you still have...

Hi Rem,

Debug is only active for a project. It's disabled when you just edit a package file. Have your colleague create a new project then add the package...

Save the package as a file then, in SQL Server Management Studio Object Exporer, expand Management, Legacy, right-click "Data Transformation Services", and select "Import Package File".

Connections are part of the package and the package information is stored as binary data in msdb.dbo.sysdtspackages, so there isn't a way to get the information with T-SQL. The...

I might not understand your question, but DTS packages are only stored in the msdb database.

Since you've created the SQL 2005 database with different table schema than the SQL 2000 database, you can't use backup and restore either. SSIS or DTS are the methods...

Yes. I get it all the time and ignore it with no problems.

You'll need to set the protection level for each package as you edit and save them in BIDS. Then you provide the password in the ExecutePackage tasks in the...

It depends on who will be executing the packages in production. If you use any of the ..UserKey protection levels, you'll be the only one who can execute them....

The job must be connecting to Box2 via a Linked Server which maps the SA login on Box1 to the SA login on Box2 with the password for the Box2...

It also occured to me that if you have Express Edition, SQL Server Agent isn't included.