Do you need to do the intial processing using DTS?

you could create a batch file that goes into each directory and copies out the latest file to...

without full details it is hard to suggest a solution, but you should be able to use the HAVING clause to have aggregate functions behave like a where clause....

you can use the ForEach Loop container in BIDS

to loop through your folders to find the latest files.

http://www.youtube.com

there is a lot of them there.

Is there a more efficent way to use Full text indexing?

I...

Sorry i meant a primary key is required for replication, not identity column...

so not really that relevant to the discussion...

The problem could be in the where clause , the last OR statement means that the other conditions are ignored and it will select where firstnames is null put...

Either;

Import the file as a CSV and tell the flat file connection manager to start from the 5th row.

or

Add a conditional split in your package to split out the first...

nvarchar has a max length of 4000 not 8000

the 'N' in this statment converts it;

set @C = N'hello'

The one two days ago was casting to a length greater than the nvarchar data type max of 4000, so the length was truncated to 4000. The one...

an Identity column is required for replication, this would be...

If your database is not in production then use the detach and attach method.

Detach your database from your source server,

Right Click on db --> Detach Database.

Attach the database...

Okay makes sense.

Post the DDL of the table and im sure someone can help you out..

You are doing the exact same thing twice , unless there is some reason for this , then it will affect performance

Table structure is what the table contains, the names and types of columns contained in the table, expand the table node in SSMS to have a look at the...