Are you sure this is the problem??

Yes for the Execute SQL Task right part.

The syntaxe is :

Insert into dbo.tableName (col1, col2, coln) Select col1, col2, coln from dbo.StagingTable --where condition that flushes the deleted records......

Sorry but I'm too yound to know about COBOL, I barely know how to spell it. My knowledge came from an interview question for a c++ job. They...

Here to be exact :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=195400

That could be correct :

(LinkedServer).(Db).(Owner).(Table).Column = 4 prefixes .

Cool. Could you please provide the required information next time so that we don't have to guess again? That way we can provide a tested solution in far...

French/Enlish/ (vb + C++ + sql server).

Easy to get mixed up between percent and pourcent and % at this stage .

The poster(tress!?) talked...

Then there definitly is an object in master named Test1, what query did you run to try to find it?

Check this out :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=193680#bm193725

Why do you want to run the job so often?

HTH. But I'll be out for 3 days after tomorrow. You might not get fast answers on my part .

thgamble1, did you intent to index the computed column so that you have a quicker range search?

You could create index on the computed column and the state so that the...

Il'l trie two bee moer caerfule .

Also speaking about typos... : "automtically "??????

You try writing things in 3 different languages without making a translation mistake once in a while... The strange thing is that it checked out without error in QA (errors...

"Please tell me you didn't just post something that said the same thing!"

Might I remind you that you are the one repeating after me... not the other way around.