Also, what's the connection info in the bottom right of the query window ??

[Note : for a new query, two options are available , one is with current conn. and...

you had it opened brand new

or the specific query window was opened as connected to prod ?

when you open a query window , specific to an instance; it...

thanks dwain for correcting ...

check out msdn for new additions in the 2008 ;the datatypes , filegroups , new keywords (MERGE,OUTPUT etc..)

for 2005 to 2008 you are good to go , for 2000 to...

I have faced a similar but not exact issue. In this the job used to fail on weekends. The job was with two different providers that works with last day...

Turn on the package logging ; there you can find multiple logging points. You can check package logging on msdn.

SQLKnowItAll (8/9/2012)

-on 8/1/2012 files being imported by backend job

-on 8/2/2012-8/3/2012 user make tons of change to the data via front end

-on 8/4/2012 updated files being imported

if we reverse back to...

why are you doing this ?

I mean, the +1 , and then inserting to another table...

I saw third first 🙂

create table #address(a varchar(50),b int)

insert into #address values ('pat',1),('giyo',2)

insert into #address values ('pat',1),('giyo',2)

select * from #address

this should do the work

with cte as (

select *,row_number() over(partition by a order by...

did I miss something ?

I guess i didn't get the question ...

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/a9bcde36-408d-4ddf-b62e-132c257e9362/

After yesterday's question , It was a feel good . 😛

rVadim (8/7/2012)[hrThen another way is to implement this as a "File Management" solution.

1. Don't discard files after loading, instead save them to a predefined archive location.

2. Create a table that...

when you say bad feeds ,...