they use the exact same DLLs.  Highly doubtful the personal edition would have any differences.  I have not come across any to date.

-Mike Gercevich

I would save your XLS as an MSDOS CSV file.  Use an Active-X Transform and format each source column in the manner expected at the destination:

Function Main ()

    '** Force...

I'm going to take a stab at that you are trying to pass your global variables to a stored procedure that processes them as a FOR XML EXPLICIT select.  From...

Since you are doing a compare.. and you do not want to lock any of the tables... Why dont you try using the WITH (NOLOCK) hint.  I bet this query...

Loading another package into memory on many tasks within on package will surely cause performance issues. Another solution, if you are using a mess of the same routines, over and over...

Put...

May be a round-about cludge; but you can get the collection of steps in the package... Check the ExecutionStatus property of each... This should give you the current Step Name. ...

I've used an @ResultStatus BIT OUTPUT parameter in many procs that I call from DTS packages.  Default the param to 0.  Place an error handler in the script that gets...

Also, you may want to try and set your Command-Timeout to a value of 20 rather than 0.  If that does not help, look at your locks on the database. ...

Never really had to do this, but was wondering, couldn't you grab the parent package2 object, loop the step collection and determine which step object has a "DTSStepExecStatus" of "DTSStepExecStat_InProgress"...

Have you tried:

Dim oObj

SET oObj = DTSGlobalVariables.Parent.GetExecutionErrorInfo ...parameters

i think that should work.

-Mike Gercevich

If you insist on using the EXECSQL task,  You'll have to define an input global variable and use the syntax below:

EXEC dbo.mystored_procedure @RETURN_VALUE = ? OUTPUT

The global Variable will be...

If you use the Command object, you can look at the @RETURN_VALUE parameter after execution.  You may need to issue a oCommand.Parameters.Refresh prior to execute method.

If @RETURN_VALUE is 0, the...

Try using single quotes for your strings.

Mike Gercevich

I have written a VB.Net application that will read in selected DTS packages from the SQL Repository and extract all important information: i.e. Connection objects, Tasks, Steps and any Active-X...

Without knowing your requirements this is a difficult question to answer, but I thought that I might offer these options.

Any process that would need to send an email could populate...