That's the way I would do it - here's some sample code - notice that I have put the connection string in a global variable for ease of use:

 Dim strConn

 Dim...

One way is to put a piece of ActiveX code as the first step in the DTS package.  Perform the IS NULL checks in this step and then:

 if (NULL condition) then

  main...

No need to use set.  Just use

oRS = DTSGlobalVariables("RSTables").Value

you're in VBScript land here - not SQL Server.

You will need to be a bit more specific before we can really help you.

Can you provide a bit more detail about why you need to do this?  What are...

Not 100% sure that I have understood the question - I am no XML dude - but if you are having problems as a result of SQL Server generating primary...

Can you be a little more specific - is the import actually failing, or are you validating the data after import and finding that it is 'corrupt' because it fails...

DTSSource and DTSDestination are available within a Transform Data task.

When you create a Transform Data Task, you must specify a source connection and a destination connection.  It is from these...

TDS_RET_STATUS returns zero matches on Google.  Are you sure that you've typed it in correctly?

... so how much space do you have on your hard disk?

My mistake - I read the post too quickly

It may be stating the obvious, but it sounds like you've run out of disk space.  How big was the database (MDF + LDF) before it was backed up and...

Here's an example from Northwind that gives the same error:

declare @id int

select @id=categoryid, description from categories where categoryid = 1

The error message is actually quite helpful - you cannot mix variable...

Hi Ann, I would do this slightly differently.

Create a new SQL Server table - 'import', or whatever - and import all of your Excel data into that.

Then have your DTS...

Not 100% sure what that error message means - sounds like a security problem - perhaps the server doesn't have the right privileges to write to your PC.  Are you...

Nice one David!