edit a DTS package in sql 2005?

How do you edit a DTS package that has been migrated to SQL 2005 from SQL
2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
can't quite figure out how to edit it.
What are the steps to follow to do this? If it's possible.
Thanks!
Per the SQL Server 2K5 Upgrade Advisor
You can use SQL Server 2005 tools to edit your existing DTS packages.
However, upgrading or uninstalling the last instance of SQL Server 2000 on a
computer removes the components required to support this feature. You can
retain or restore these components by installing the special Web download,
“SQL Server 2000 DTS Designer Components,” before or after you upgrade or
uninstall SQL Server 2000.
"mp3nomad" wrote:

> How do you edit a DTS package that has been migrated to SQL 2005 from SQL
> 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
> can't quite figure out how to edit it.
> What are the steps to follow to do this? If it's possible.
> Thanks!
|||thanks!
"Mark H" wrote:
[vbcol=seagreen]
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> “SQL Server 2000 DTS Designer Components,” before or after you upgrade or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:
|||I tried installing this component and I'm getting error messages trying to
open the legacy DTS package. I also have the backward compatibility
components installed as well. Is there something I'm missing here?
What are the steps to follow to move a DTS package from SQL 2000 to SQL 2005
and then edit the package on the SQL 2005 server?
"Mark H" wrote:
[vbcol=seagreen]
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> “SQL Server 2000 DTS Designer Components,” before or after you upgrade or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:

edit a DTS package in sql 2005?

How do you edit a DTS package that has been migrated to SQL 2005 from SQL
2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box bu
t
can't quite figure out how to edit it.
What are the steps to follow to do this? If it's possible.
Thanks!Per the SQL Server 2K5 Upgrade Advisor
You can use SQL Server 2005 tools to edit your existing DTS packages.
However, upgrading or uninstalling the last instance of SQL Server 2000 on a
computer removes the components required to support this feature. You can
retain or restore these components by installing the special Web download,
“SQL Server 2000 DTS Designer Components,” before or after you upgrade o
r
uninstall SQL Server 2000.
"mp3nomad" wrote:

> How do you edit a DTS package that has been migrated to SQL 2005 from SQL
> 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box
but
> can't quite figure out how to edit it.
> What are the steps to follow to do this? If it's possible.
> Thanks!|||thanks!
"Mark H" wrote:
[vbcol=seagreen]
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on
a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> “SQL Server 2000 DTS Designer Components,” before or after you upgrade
or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:
>|||I tried installing this component and I'm getting error messages trying to
open the legacy DTS package. I also have the backward compatibility
components installed as well. Is there something I'm missing here?
What are the steps to follow to move a DTS package from SQL 2000 to SQL 2005
and then edit the package on the SQL 2005 server?
"Mark H" wrote:
[vbcol=seagreen]
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on
a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> “SQL Server 2000 DTS Designer Components,” before or after you upgrade
or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:
>sql

Dynamically change the sender email address on a SQL2005 Windows 2003 server 64-bit box using da

We currently use xp_smtp_sendmail to send the emails on a sql2000 32-bit box. We are trying to move our databases to a new sql2005 64-bit box. One solution is to replace xp_smtp_sendmail with database mail since xp_smtp_sendmail does not work on 64-bit box. The only problem is that we need to change the sender email dynamically based on the query results and I don't know how to accomplish this by using database mail. Does anyone have an idea? We are not restricted to database-mail solution though.

Thanks for help.

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

See SQL Server 2005 Books Online topic:
sysmail_update_account_sp (Transact-SQL)
http://msdn2.microsoft.com/fr-fr/library/ms188381.aspx

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

|||Thanks. This answers my question.

Dynamically change the sender email address on a SQL2005 Windows 2003 server 64-bit box using da

We currently use xp_smtp_sendmail to send the emails on a sql2000 32-bit box. We are trying to move our databases to a new sql2005 64-bit box. One solution is to replace xp_smtp_sendmail with database mail since xp_smtp_sendmail does not work on 64-bit box. The only problem is that we need to change the sender email dynamically based on the query results and I don't know how to accomplish this by using database mail. Does anyone have an idea? We are not restricted to database-mail solution though.

Thanks for help.

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

See SQL Server 2005 Books Online topic:
sysmail_update_account_sp (Transact-SQL)
http://msdn2.microsoft.com/fr-fr/library/ms188381.aspx

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

|||Thanks. This answers my question.