The servers registered in EM are stored in the registry at the following key,

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group

It's a binary value so you probably...

Ok here's what I came up with. An important thing to note is that you need to set the Precedence Constraints for the next step in the sequence.

I set up...

Have you tried doing a self-join,

eg:

select d1.DomainID , d2.DomainID

from Domain d1

inner join Domain d2

on d1.ParentDomainID = d2.DomainID

Thanks

Phill Carter

Do you get any error messages? Turn on package logging to check what it's doing. Also, make sure that the process that will execute has sufficient access rights.

Thanks

Phill Carter

In a word, No . Global Variables don't hold arrays.

Thanks

Phill Carter

Edited by - phillcart on 02/03/2003 3:55:49 PM

Do a Bilk Insert into a staging table, then execute a regular T-SQL insert to insert the records into the final table.

Thanks

Phill Carter

Looks like a latch wait problem. Check out 'Latching' in BOL.

Run perfmon and watch the 'Average Latch Wait Time' counter. From memory, I think anything above 1500ms is indication of...

Have you tried setting the StepExecutionStatus to 'DTSStepExecStat_Completed'?

I've only done the Inactive and Waiting myself. Just thought that this might simplify a problem I'm having. Will be trying it out...

Try doing using the BULK INSERT command in Query Analyzer and see how long it takes.

What sort of data are you importing?

Thanks

Phill Carter

It's a permissions problem. Checkout the following articles,

http://support.microsoft.com/default.aspx?scid=kb;en-us;298725

http://support.microsoft.com/default.aspx?scid=kb;en-us;269074

Thanks

Phill Carter

If you use the DataPump task to import your data, then you can write an ActiveXScript that manipulates the task properties before it executes.

If you're using SQL 2000, jump into...

Try DTSBackup 2000 at sqldts.com

http://www.sqldts.com/default.aspx?220,272,272,1,1

If you're moving the packages between SQL Servers, make sure you have 'Direct Transfer' select in the options. This will preserve the formatting and annotations.

Really though,...

In your ActiveXScript, first you need a package object then you can open the steps and tasks associated with that package.

EG:

Dim oPkg, oStep, oTsk

Set oPkg =...

Try copying the ActiveXScripts into seperate files and execute them at a command prompt. You'll probably find that the script is waiting for some sort of input.

Thanks

Phill Carter

How many rows are you importing? How long is it taking? What version of SQL are you using?

What other methods of importing have you tried?

Thanks

Phill Carter