You don't need to this in ActiveX. You can follow your ActiveX script with a normal datapump between the two connections (file and table). Add in some code, to set...

Hi,

When querying the XML, SQL Server does not see a NULL value produced by xsi:nil; the value is interpreted as not being there at all rather than a NULL value. An...

A plain text example of the DTSRun command with switches looks like:

DTSRun /Sserver /Llogfile /Npackagename /E

The switches are:

/S the server where the package is stored

/L the path of the DTS...

What's the final outcome that you are trying to achieve? I can't understand why you'd need to do this on a stylesheet?

It's a...

You could have a connection to the Excel file (path dynamically adjustable through a Global Variable) and a SQL task with a SELECT that returns the contents of the Excel...

Jeff, it's a quintuple post! There was another one on the 18th too!

I believe that http://www.readytogiveup.com was the original site.

The latest one is http://www.notreadytogiveup.com which better reflects Rex's (and his family's) attitude to this mammoth hurdle! There's a donate link on...

"The best perk of all would be for "corporate management" to understand and value what their IT departments CAN do for them..."

Outstanding answer Robert! I've only worked or about...

I wish that was true! 

They film most of it in Liverpool these days with about two minutes footage of Chester thrown in about once...

Chris,

I nearly ended up buying a house in the street behind work, but thought that would be a bit too close for comfort!!

I live and work in Chester in North-West England. It's only a small place and my home is about 800 metres from my work so a nice perk for me would be...

For what reason is it unnecessary to delete the file and recreate it? Whether you drop and recreate or truncate gives basically the same result.

Hi,

I'm not sure what you mean by ServerName property. Are you looking at the Package Log Server or is this a SQL Server connection object in each package, or something...

The replace function is available in ActiveX; You can use it after you've read in the file to a variable. Usage:

Replace(myscript, "orders", "orders_test")

               ^           ^              ^

          Look In       Find         Replace With

This will...

400 to 500, hmm.....

I guess I need a Method 3 then!!

If you are passing the script name as a Global Variable you...