Viewing 15 posts - 256 through 270 (of 341 total)
Your 2nd requirement is where I'm hoping someone else can chime in. I have never had a requirement to do conditional control flow in an SSIS package. We have always...
May 16, 2008 at 6:52 am
select col1,col2 from table1,table2
where table1.col1*=table2.col2
and table1.col4=table2.col4
This one would be:
select col1,col2
from table1
inner join table2 as innertable2 on table1.col4 = innertable2.col4
...
May 15, 2008 at 3:23 pm
select col1,col2 from table1,table2
where table1.col1*=table2.col2
You need to change this statement to (for 2005 and mode 90):
select col1,col2
from table1 left outer join table2 on table1.col1 = table2.col2
I have this all over...
May 15, 2008 at 3:11 pm
Does it work on another PC? Have you tried re-installing BIDS to see if the problem corrects itself?
May 15, 2008 at 10:01 am
Your first requirement is easy. A Foreach Loop Container can be setup to pull all files (one at a time) from a particular directory you specify. Within that container, you...
May 15, 2008 at 10:00 am
ahutch (5/15/2008)
Is there any need to run sp_updatestats after upgrading from SP1 to SP2?What about DBCC_CheckDB?
Anything else needed (or not) that I haven't mentioned?
I personally haven't done either when I...
May 15, 2008 at 9:51 am
Val Byref (5/15/2008)
May 15, 2008 at 7:10 am
It is really the same in Query Analyzer. Right-click on the view and make the appropriate scripting selection and destination.
May 14, 2008 at 2:10 pm
Right-click on the View and select Script VIEW as > and make the appropriate selections in the next menu.
I'm not positive but I assume at least DBO rights are necessary....
May 14, 2008 at 1:48 pm
Considering it does not track licensing on its own, I'm not sure what benefit you'll gain. If you have to manually enter it, whether into a table or the registry,...
May 14, 2008 at 1:27 pm
Another thought would be doing a cost-benefit analysis of taking the "risk" to be encrypted or not. Of course, the risk if you are not encrypted is that the data...
May 14, 2008 at 7:33 am
The only option I can find is rather than opening SSMS first, just open the file and it will open in SSMS. The drawback is that it does not show...
May 13, 2008 at 2:37 pm
coastliner (5/13/2008)
BTW I was always told of a 4GB limit on 32bit...
May 13, 2008 at 9:56 am
Marios Philippopoulos (5/13/2008)
jim.powers (5/13/2008)
No, it was a 32-bit machine.Unless you enabled AWE, that's mathematically impossible.
The 32-bit address space simply does not have the capacity to reach that kind of memory...
I...
May 13, 2008 at 9:46 am
not since SP2, Maint plans no longer require SSIS
That is certainly good to know! Interesting enough, though, even with SP2, it still stores them in SSIS.
May 13, 2008 at 9:38 am
Viewing 15 posts - 256 through 270 (of 341 total)