Sorry I'm still not seeing the issue. Why can't you catch the value in a variable, or write it to a temporay table (local or global), or write the...

Sounds like 'import data' from the Enterpise Manager' interface is your best bet (fast and easy). This is along the same lines as 'cstrong' and it does cover text...

In addition to copy and paste you can change the 'Execute Mode' to save the 'Results to File'.

Sorry for not responding directly to the question before, but yes you can run multiple instances of a DTS package.

Quick Test:

use the DTSrun utility to generate the...

If I remember correctly, DTS is not used dynamically due to being slower than the alternative (SQL stored procedure, XML call). Keep in mind, too, that if you really...

The answer to both issues can be found at: http://www.microsoft.com/traincert/mcpexams/faq/procedures.asp

To add to rajeshpatavardhan, first check to see if @m_err <> 0, then start custom error checking.

Hello.

Yes it does work. I'm running all of my tests form the test server. I've been able to access other computers from a test job...

Antares' mention of FETCH seems worth greater comment.

Barring large overhead due to the cursor, this seems the cleanest.

Question though, which would be less of a burden, a temporary table or...

One way is to use two TOP statements:

USE Northwind

SELECT TOP 1 tablename.LastName

FROM

(Select TOP 20 LastName

from Employees

order by HireDate)

AS tablename

Thanks for the additional info, this is a neat idea.

Everett

Guarddata,

Would it be possible for you to expand on your system a bit?

Of most interest would be why different tables are used, although any additional information would...

Multiple transformation tasks can be added to one connection.

This trigger should work. xblt1 and xtbl2 are you TABLE1 and TABLE2

CREATE TRIGGER DetermineGroup

ON dbo.xtbl1

FOR INSERT

AS

Declare @sName char(10), @Group char(10)

Select @sName=I.m_Name

From xtbl1 S, INSERTED I

Where S.m_Name=I.m_Name

Select @Group = Item2

from...

This works. Although you end up with a varhcar. Note: GetDate returns

a data type of int, and if you convert this back to datetime you're going

to have...