Right, got it working. Had to change the data source from using Windows integrated security to Credentials stored securely on the report server. I also checked the Use as Windows...

Thanks for the feedback John. I ended up installing the OWC 11 add-in and that also resolved the issue.

Cheers,

Mark

Hi Tommy,

That post was logged before Office 2007 was even released so perhaps there is a more up to date fix available. I'll install that component as a last resort...

Thanks!

I've used the below script to remove duplicates (may even have found it on this site):

ALTER TABLE TableWithDuplicates ADD EliminateDuplicates_RowID int NOT NULL IDENTITY(1, 1)

DELETE

FROM  t1

FROM TableWithDuplicates t1

JOIN(

 SELECT EliminateDuplicates_RowID=MAX(EliminateDuplicates_RowID),

  Field1,

  Field2,

  Field3,

  Field4

 FROM TableWithDuplicates

 GROUP BY Field1,

  Field2,

  Field3,

  Field4

 HAVING COUNT(*)...

I found this script to be particularly useful.

-- /E : Use a trusted connection

-- /!X : Do not execute the DTS package

-- DTSRUN.EXE /S ServerName /E /N PackageName /F FileName /!X

-- Copy...

See the script below to quickly save all your DTS packages. Note that packages will be appended to each other if the batch file is executed more than once and...