Viewing 15 posts - 31 through 45 (of 289 total)
try setting DelayValidation to True.
October 31, 2013 at 2:01 pm
Facts will always be on your side.
Were I you, I would make darned sure of what the processes currently do, and how they are done, in order that you can...
October 31, 2013 at 1:56 pm
I think I can help - you need to have the first part as ISNULL(fieldtotest) == TRUE ? replacement_value : else_value
I learned the hard way on this one as it...
October 15, 2013 at 12:35 pm
ah, yes, Makes sense to me. Possibly why I abandoned the idea for our use.
October 1, 2013 at 1:45 pm
barbara.sorkin (6/11/2013)
Are the products compliant with SQL Server 2012? The available information seems to reflect the 2005 version and nothing more current.
Given how old this thread is, that is...
October 1, 2013 at 12:07 pm
Oh, and Microsoft Adventure Bike Works is a great place to start. Easy to understand business model so grasping the concepts is rather straightforward.
October 1, 2013 at 12:04 pm
I took a job with a small company wanting to get into DW and BI, which is where I wanted to go. I was a strong candidate for covering...
October 1, 2013 at 12:03 pm
pmscorca (9/27/2013)
Hi,I'm searching articles, white papers, books, blogs, etc. about how perform a data warehouse assessment.
I'd like to have a good reference to match with my experiences.
Many thanks 🙂
What kind...
October 1, 2013 at 11:54 am
Is there a reason why it has to be in script task? I use Execute SQL task to pull select validation records from a table and email that.
October 1, 2013 at 11:45 am
Luis Cazares (9/30/2013)
Use the same solution 😉
awesome! Part of why I visit is for no-nonsense advice like this!
made my day, thanks!
October 1, 2013 at 11:41 am
I was thinking there was some support for checkpoints in ssis, tho I have never used them since we mostly do kill n fill.
My understanding is that you could restart...
October 1, 2013 at 11:40 am
Yes, I use pkg configurations to define servername and databasename which I have dev values supplied for in the variables pane. On the server, I use Set Values tab...
September 12, 2013 at 12:59 pm
We like to have that info right in the warehouse table and I have a morning job that checks for stale data and alerts us. Pkgs can run successfully...
September 11, 2013 at 2:30 pm
ensure that the file exists in that location on the server or pass in correct location from server standpoint.
September 11, 2013 at 1:40 pm
Yes, a question with no specific answer.
You need to start by asking some questions of your own:
what is the purpose of the cube?
who are the users?
what are we measuring?
What dimensions...
August 29, 2013 at 12:12 pm
Viewing 15 posts - 31 through 45 (of 289 total)