Each instance requires its own unique port number. You can force each instance to use any port you wish but again they must be unique.

I had the survey questions on exam 70-443 as well.

Take a look at the Microsoft SQL Server 2005 Support Life Cycle: http://support.microsoft.com/lifecycle/?LN=en-us&x=17&y=10&p1=2855

Please review the following discussion:

http://www.sqlservercentral.com/Forums/Topic464651-148-1.aspx

We are not using any server login mappings and connecting using a remote login. The linked sever connection test works (as well as pinging the server) it is only...

You may want to read this forum post from the MSDN forums:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4a4a2239-3ac5-4f1d-8b2d-b2c5f03d3c07

You can change the protection level on the dtsx package to Encrypt Sensitive Data with User Key but then you are on the only that open and maintain the package.

Through SSMS:

1. Right click the database mail icon and choose configure Database mail.

2. Choose Manage Databse Mail accounts and profiles and click next.

3. Choose View, change, or delete and existing...

How are you connecting to the DB2 databases - OLEDB or ODBC? It sounds like IBM is using a different driver version for 9.0 that is incompatible with 8.0....

Create a SQL Job to run the SSIS package and then execute the job from the sp.

I found these two sites helpful when documenting best practices at my company.

http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

You can do this. Just enable configurations for each package. Create a configuration file through one of the packages. Then add that configuration file to each package...

The password will not show in the config file. You must manually add pwd='password'; to the connection string in the config file. If the package is currently set...

How are your data source connections stored? Are you using configuration files? If you are can the package access them on the SQL server running the package?

When I started out I picked up SAM's Microsoft SQL Server 2005 Integration Services by Kirk Haselden ISBN:0672327813. I could not have started out without it. JumpstartTv will...