I appreciate all the help and I regret for confusing anyone.

I'm sorry that I did not clarify that I could only use one table to remove the duplicates and I...

I just walked into the situation.

The Databases were created by Non-IT Professionals.

I have experience with the entire SDLC.

I appreciate your comments and I hope to change the way things are...

Yes you correct but I may need to check the size of the file to ensure that it is within an expected range.

Also there this is only one report and...

Simon,

I assume that there is a way to gather other file attributes, such as DateCreated, modified, size, etc?

I usually use the FSO to get this information.

Cool!

Thank you very much!

The approach take in the following example script may be more practice.

I can't hard code the file names so I believe that I could use the xp_cmdshell to read the...

Sorry, I found a solution to the problem.

Please disregard...

:laugh:

The sort part of the question was a no brainer, all I need to do to accomplish that is load the filenames in a temp table and use the order...

Taking into consideration that the Report Server is currently on SQL Server 2000 and the Production Servers are using 2005 & 2008 and there may be a funding issue; perhaps...

Sir,

I can't confirm that because the BO is out of town.

I have always been able to set standards for naming conventions and file formats but I unfortunately I have no...

This is a great example but what if the employee table had duplicate entries. and one or more columns had non-distinct values and you wanted to return the the first...

I used a scrupt task inside a For Each Loop Task with the following code:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

Public Sub Main()

...

My apologies...

The is an example of table that I want to populate from multiple files with different formats:

CREATE TABLE [dbo].[MemberFormat](

[FirstName] [nvarchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LastName] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[EMailAddress] [nvarchar](55) COLLATE...

Another approach that I could take would be to load each file with the same format into an array, move the file into a temp directory, use the File System...

I found this link but I'm not sure I could utilize some of these approaches to satisfy part(s) of the (vague) requirements that I was provided?

I asked for more details...