Once again, I would suggest installing again.

I am running on Vista Business and use Reporting services all the time. I have Vista on my laptop with SQL2005 installed and it included SSRS but I had...

Sorry, but that doesn't make sense. The Server Type is where the Database Engine, Analysis Engine, Report Engine, Integration Services are listed. The Server Name should have the...

The sDestination file does not exist. The sSourceFile does not exist.

Function Main()

Dim oFSO

Dim sSourceFile

Dim sDestinationFile

Set oFSO =...

I fell into SSIS from DTS and was researching, reading and generally becoming frustrated. Then I found out how to do it! Simply go to the database engine...

I would suggest going to add/remove programs and select SQLServer and have your discs ready. Be sure when you come to the options page you specifically select SSis, etc....

If they are true duplicates from col 1 to the end of the record, how about a simple union to a temporary table and then replacing the table with duplicates...

That is exactly what the problem was....

The schema is dbo. I've tried it with the server.dbo.filename and it fails that way as well. Also just dbo.filename. Same failure.

The table:

USE [NPNPlus_GenericDrugs]

GO

/****** Object: Table [dbo].[PharmacyGenericDrugs] Script Date: 03/06/2009 13:45:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[PharmacyGenericDrugs](

[DrugName] [varchar](250) NULL,

[DrugGroup] [varchar](250) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING...

I've found the easy way to remove duplicates is with the UNION statement:

select * into aTempTable

from SourceTable

UNION

select * from SourceTable

GO

truncate table SourceTable

insert into SourceTable

select * from aTempTable

GO

Does this work for...