Viewing 15 posts - 9,391 through 9,405 (of 11,678 total)
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...
May 20, 2011 at 6:15 am
mister.magoo (5/19/2011)
[rant]This takes the biscuit http://www.sqlservercentral.com/Forums/FindPost1112017.aspx
[/rant]
I actually laughed out loud when I read that. Thanks, you made my day 😀
(sorry for your wasted time though)
May 20, 2011 at 12:40 am
MuraliKrishnan1980 (5/19/2011)
[font="Tahoma"]Hello Elliot, Seems that the package is corrupted while it was transferred through email. But not sure. It is only 2 bytes. :blink:
[/font]
2 bytes is a little too small...
May 19, 2011 at 8:38 am
And why is that a problem?
You just create a table with the same name on each server.
May 19, 2011 at 8:20 am
And you can't use SELECT INTO because... ?
May 19, 2011 at 7:57 am
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 🙂
May 19, 2011 at 2:32 am
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...
May 19, 2011 at 2:31 am
Slightly off-topic, but why are you using the WITH(NOLOCK) query hint?
You do realize it can give you incorrect results?
May 19, 2011 at 12:38 am
daveriya (5/18/2011)
archive 1 is for each loop after the first condition and archive 2 is for loop after the second...
May 19, 2011 at 12:34 am
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.
May 19, 2011 at 12:27 am
RamSteve (5/18/2011)
Hi !This issue was resolved once i installed 64 bit Oracle client
Great that you were able to fix the issue and thanks for posting back!
May 18, 2011 at 11:58 pm
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...
May 18, 2011 at 7:20 am
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...
May 18, 2011 at 7:15 am
Viewing 15 posts - 9,391 through 9,405 (of 11,678 total)