That shouldn't be a problem to produce those results use a SELECT with a GROUP BY and a WHERE clause with the DATEADD function.

If you would like some exact...

That is not really clear,

you did not mention p1 d1 d2 originally so i do not know what they mean..

can you post your table definitions, sample data and your expected...

use DATEADD function

SELECT DATEADD(d,-60,GETDATE())

You cannot replicate a lvl 90 db to sql 2000, so you will need to change it and redo the publication.

You change the compatibily level at the database, not the...

What level is your db running on SQL server?

It seems from the error message that you already have a publication at a higher level, did you setup publication when...

If you are looking for an easy improvement in the speed by improving the Hardware I can recommend using a SSD

We installed one to speed up a server that...

try an inner join

select tbla.model, count(tblb.model)

from tbla inner join tblb on tbla.model = tblb.model

or something similar , post your exact tables for more precise code

This will not repair anything, it simply scans the database for physical structure errors and is a lot quicker to run that a full scan does a lot more logical...

There are a few ways to do this,

You can add a conditional split transformation after the excel data source and split out all records that have country='UK' and send these...

What happens when you execute the task directly (right-click-->execute task) ?

You can use Notepad to edit them but it is a bit messy, I perfer to use visual studio as this will format the file nicely for editing

this blog...

I would use configuration files, they are fairly easy to setup and make moving packages from dev to prod a lot easier.

You can either assign the connection strings to...

It looks like they are using (") to qualify the text.

On your Flat File connection manager editor - enter " in the text qualifier box

can you post your actual execution plan?

also do you have any non-clustered indexes or only clustered?

You should be able to do this in SSIS,

however your description is not clear.

Here in example first column stars with '8' and fifth column '3' and ends

with...