Viewing 15 posts - 5,251 through 5,265 (of 11,677 total)
Jeff Moden (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2013 at 12:14 am
You could use an Execute SQL Task before the data flow.
In the SQL Task, you retrieve the data and put it in a variable.
Inside the data flow, you use a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2013 at 12:07 am
Right now @TotalRows will always be 1 at the end. Is that the idea?
If you want the rows not updated, you'll need to do a rowcount (there are many ways...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 9, 2013 at 12:05 am
The event log usually has nothing useful to say.
We either need the job history from the jobstep itself, or the SSIS logging.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 11:57 pm
Easy one to finish the week, thanks Steve!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 11:55 pm
Didn't you get any warning or error when you went through the wizard.
I remember the wizard disabling the run immediately when there was some sort of issue the wizard couldn't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 3:01 pm
You're right, it didn't help 🙂
Normally SSIS wouldn't just lose rows. Even if it's a bad connection. TCP/IP connections are used, so they are pretty reliable.
A bad connection could slow...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:59 pm
Sean Lange (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:55 pm
I think you need to define a drillthrough action in SSAS:
Defining and Using a Drillthrough Action
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:17 pm
Sean Lange (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:13 pm
Sean Lange (8/8/2013)
Koen Verbeeck (8/8/2013)
Sean Lange (8/8/2013)
Koen Verbeeck (8/8/2013)
Jeff Moden (8/8/2013)
It doesn't? I just called the article up and here's the Prologue that I "remembered" adding to the article.
Hmmm,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:13 pm
Sean Lange (8/8/2013)
Koen Verbeeck (8/8/2013)
Jeff Moden (8/8/2013)
It doesn't? I just called the article up and here's the Prologue that I "remembered" adding to the article.
Hmmm, this might be the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 2:07 pm
Jeff Moden (8/8/2013)
It doesn't? I just called the article up and here's the Prologue that I "remembered" adding to the article.
Hmmm, this might be the language gap. I was...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 1:13 pm
jbm6401 (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 1:02 pm
Jeff Moden (8/8/2013)
Koen Verbeeck (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 1:00 pm
Viewing 15 posts - 5,251 through 5,265 (of 11,677 total)