DTS pacakges are stored as BLOBs in msdb..sysdtspackages. So no T-SQL query going to be able to extract the info you need.

cocr's suggestion is probably the closest you'll get...

For a more efficient query, use a join clause instead of an IN.

eg:

select cust.* 

from db1.dbo.Customers cust

Inner Join db2.dbo.MainAcc main

on cust.id = main.id

Hope this helps

Phill Carter

--------------------

Colt...

nchar is a unicode datatype an uses two bytes per character.

Check "Data Types" topic in Books Online.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

The DTS package is stored as a binary object in msdb, so you won't be able to change it using a trigger.

Your best approach would be to dynamically assign things...

How dynamic is your package? ie: do you assign items like the source and destination tables from global variables at run-time, or a they statically assigned when the package is...

Take a look at the Tutorial section over at http://www.sqldts.com

http://www.sqldts.com/default.aspx?107

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Whle that is a workable solution, I don't prefer to go that path myself. It means that if you ever want to edit the SQL statement, maybe to add another...

Take a look at "SQL Server Task Scheduling" in Books Online.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

From the fact that you're seeing "sp_cursoropen", I say that these pages are doing a lot of recordset processing.

ie:

While recordset1 not EOF

open recordset2 with recordset1 parameter

while...

It's in the tasks group in the DTS Designer. The icon has a yellow database with a green arrow on the top.

Also, if you right-click on the designer pane,...

How's you network connectivity?

Maybe you have a dodgy NIC or driver.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Are you getting the same errors?

Whenever you see '80004005' in the message it's something to do with security. This number is basically the catch-all access denied error.

Has something changed recently...

Can you explain a bit more about what you are doing and what you want to achieve?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Create a stored procedure that calls xp_sendmail and execute it instead of directly calling xp_sendmail. Then use the ? character to specify a parameter in the SQL statement.

eg: EXEC my_sendmail_proc...

You can use BCP to create the basic format file by outputting from your destination table.

Using the DTS Bulk Insert task, click the 'Use format file:' option and then clck...