Viewing 15 posts - 451 through 465 (of 1,162 total)
Nope, it needs installing on the server that's running SSIS (It's accessed from the GAC during runtime, the dtsx just holds the class ID)
March 15, 2012 at 5:30 am
Is it always exactly 1 hour? If so, sounds like it's hitting a timeout somewhere (maybe on a proxy, firewall or the ftp server?).
You could always try one of the...
March 15, 2012 at 5:09 am
I think Microsoft's solution to this is the Sync Framework. I've never used it before, but there's a reasonable amount of work and planning involved with this kind of architecture.
March 15, 2012 at 3:38 am
beginnew2012 (3/14/2012)
March 15, 2012 at 3:22 am
Absolutely. A data grid can return as soon as it has enough results to populate the first page.
A data reader just receives results in a pipe and can do...
March 13, 2012 at 2:12 pm
Sorry if it appeared I was being argumentative for its own sake, I just thought it was an important distinction as it made it sound like it can't hurt to...
March 13, 2012 at 1:56 pm
Eugene Elutin (3/13/2012)
It does not make query to run any faster! It just makes query to return required number of rows (n) immediately as they were...
March 13, 2012 at 10:24 am
I'm not disputing what the BOL article says, it's correct. However it's still different to what you said, hence my clarification.
All the sentence you've quoted is saying is that...
March 13, 2012 at 10:08 am
The BOL article is not saying the same thing as you did.
All queries return results as soon as they are found, this hint doesn't change that behaviour at all....
March 13, 2012 at 9:29 am
Eugene Elutin (3/13/2012)
pallavi.unde (3/13/2012)
...
I read Option(fast n) executes query fast and gives o/p soon.
...
Where have you read this from?
It does not make query to run any faster! It just makes...
March 13, 2012 at 8:50 am
Pragmatic Works do do a packaged/supported version that's paid for, but the one I linked to is open source/free.
The problem is that most of the hit of this update won't...
March 12, 2012 at 7:05 am
You could use one of the 3rd party SCD merge components[/url], but I'd tend to just insert everything into a staging table first, then join that to the main table...
March 12, 2012 at 6:37 am
You could use a For Each File Enumerator to populate a variable with the full file path/name, then make this an input to your script task. You can then use...
March 12, 2012 at 6:02 am
Which properties? You'll probably have to use a script task to get the majority of the file system properties (size, dates, attributes etc.)
March 12, 2012 at 5:19 am
Check the SQLAGENT.OUT file in <SQL Instance directory>\Log
You can find the install directory by looking at the path of the service.
March 12, 2012 at 5:06 am
Viewing 15 posts - 451 through 465 (of 1,162 total)