Viewing 15 posts - 9,856 through 9,870 (of 11,678 total)
This is a bit of a special case:
the error regarding the unsuccessful configuration is thrown before the actual package execution, since you are still configuring the package.
This has the consequence...
March 9, 2011 at 12:46 am
Duplicate post.
Please reply in the following topic:
http://www.sqlservercentral.com/Forums/Topic1075326-148-1.aspx
March 9, 2011 at 12:11 am
The fuzzy lookup has not so good performance, so you should do a normal lookup with list B as input and list A as the reference table (since it is...
March 9, 2011 at 12:10 am
Set the DelayValidation property of the dataflow to TRUE.
See if that helps...
March 9, 2011 at 12:04 am
More information on the SCD:
http://msdn.microsoft.com/en-us/library/ms141715.aspx
http://msdn.microsoft.com/en-us/library/ms141662.aspx
What are the issues that you are facing?
March 9, 2011 at 12:02 am
Ol'SureHand (3/8/2011)
It should be clear that you can restore to ANY point in time (at each 15 minute interval in this...
March 8, 2011 at 11:41 pm
Nice article, but in my opinion a bit too much focused on DBA's. There are other people who use SQL Server Agent too 🙂
For example, scheduling the entire ETL flow...
March 8, 2011 at 11:36 pm
Tom.Thomson (3/8/2011)
Kiara (3/8/2011)
Koen Verbeeck (3/8/2011)
(who for some bizarre reason love to work in an industry...
March 8, 2011 at 11:28 pm
Phil Parkin (3/8/2011)
This is a bit out of my domain.
Was that deliberate?? Nice pun!
I shall now pretend I have an amazing sense of humour and say:
Yes, it was deliberate.
😎 :hehe:
March 8, 2011 at 11:01 am
First of all, as it is international woman day, congrats to all those woman out here!
(who for some bizarre reason love to work in an industry dominated by men :-))
I've...
March 8, 2011 at 10:59 am
smac (3/8/2011)
Name: OEM PC Admin
Identity: 10.239.130.111\Administrator (since this pc is not on the domain)
Created.
New Proxy, select credential, failed.
Proxy "10.239.130.111\Administrator" is not a valid Windows user.
I...
March 8, 2011 at 10:53 am
smac (3/8/2011)
Don't feel like bringing the company to its knees if that is remotely possible!!
Thanks, you've been patient and great...
March 8, 2011 at 10:53 am
GilaMonster (3/8/2011)
Koen Verbeeck (3/8/2011)
If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry about inconsistency.
What...
March 8, 2011 at 10:49 am
smac (3/8/2011)
Gotcha!I see where you are talking about.
Can I create the credentials and proxy or does the administrator need to do that?
This normally belongs to the tasks of an administrator,...
March 8, 2011 at 7:45 am
taylor_benjamin (3/8/2011)
Thanks for reminding me how old I am, and how long I have been working with SQL Server. 🙂
There was a 4.21 version??? 😛
March 8, 2011 at 7:44 am
Viewing 15 posts - 9,856 through 9,870 (of 11,678 total)