What exactly are you trying to do? If you are looking to export a single value to a cell you can use:

e_wksheet.Cells(1,1).Value = yourvalue

Or are you are looking to insert a...

It would be useful if you could display the tables that you expect to see as the output to avoid any confusion.

Also refresh the linked tables through the tools menu in case the structure of the table has changed.

Sounds to me that that there is not enough physical space on your disk to perform the increase.

Check the space usage of your physical disk and increase as necessary....

Need more information to be able to answer your question. Give an idea of what you are trying to do and any steps you have taken to resolve.

Thanks. The timing is perfect as I am looking at indexes at the moment with a view to leaving some out of the build as they appear not to be...

Depends what type of documentaion you need and the level you want to document.

You can open the package and save it as a visual basic file. This will give you...

Thanks for the replies. More or less what I thought.

As the tables are only used as in a staging area, I won't bother adding any indexes in from now...

Without looking at your script it's hard to tell. The syntax should be as follows:

DTSGlobalVariables("variablename").value

I don't know what you mean about 'tried to display the variable'. Where are you trying...

I think it would pay more to rewrite and omit the use of a cursor for that many rows.

Post your suggested cursor here and I am sure someone will give...

Best way is to create an instance of excel within an activex script in a dts package, open the excel document, do the logic and then write back the results...

How much easier would life be without security and permission implications?

A lot!

Try using the full unc path of remote (mapped) drive folder. This could be causing your problem.

Also, check that the account you are running this under has permissions to this...

You could:

Create a new column in access that matches the sql server datatype and convert the data into there. Then use this column as the source.

Or:

You could create your own...

Firstly, to tidy up your existing data see the following article:

http://www.sqlservercentral.com/columnists/lPeysakhovich/exoticsqlnullcolumnanalysis.asp

Loops through all columns in a db looking for null values. You can customise this to...