Question: Gives examples where you used parameters?

Comment: Typically you use parameters to filter data in datasets (or data on reports) but you can also use them to restrict values...

Nice question. Had to do some research on 8.3 naming.

I actually laughed out loud when I read that. Thanks, you made my day 😀

(sorry for your wasted time though)

2 bytes is a little too small...

And why is that a problem?

You just create a table with the same name on each server.

And you can't use SELECT INTO because... ?

Either store it in a table or in a flat file. You could update your configuration file yourself, but oh boy if something goes wrong there 🙂

You can edit the .dtsx file without BIDS, if you have proficient XML skills and don't mind digging through hundreds of lines of XML. 🙂

Apparently the .dtsx file got somehow...

Slightly off-topic, but why are you using the WITH(NOLOCK) query hint?

You do realize it can give you incorrect results?

daveriya (5/18/2011)

---

i know this link,just tell me what this 2 condition do

archive 1 is for each loop after the first condition and archive 2 is for loop after the second...

What kind of queries are those? All SELECT?

If you want to dynamically create tables based on the data you selected, I would use the SELECT ... INTO syntax.

Great that you were able to fix the issue and thanks for posting back!

Thanks for the 2 easy points! 🙂

OK, glad that you got it working.

Just remember that if there is any index on the ModifiedColumn, the query optimizer won't use it anymore, as you converted the column to...

The question mark is not part of the SQL syntax, it is an OLE DB parameter placeholder. This means when you execute the SQL within the task, the OLE DB...