Viewing 15 posts - 5,071 through 5,085 (of 11,678 total)
Jan Van der Eecken (8/22/2013)
Koen Verbeeck (8/22/2013)
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. 😛
It's been a while...
August 22, 2013 at 2:59 pm
Yelena Varshal (8/22/2013)
I can for example use Execute SQL task that queries a Stored Procedure or function that returns @@Rowcount and assign the result to a package variable as decribed...
August 22, 2013 at 2:43 pm
Sean Lange (8/22/2013)
I didn't mean you were low hanging fruit. In fact, I don't think I have ever grabbed you. 😛
It's been a while since I actually laughed out loud...
August 22, 2013 at 1:53 pm
hisakimatama (3/21/2013)
August 22, 2013 at 1:50 pm
You'd be suprised what you can find these days 🙂
August 22, 2013 at 1:46 pm
rohit.kumar.barik (8/22/2013)
I need to implement under data flow task. as i need to dynamically compare the values.
The script component is located in the data flow task.
August 22, 2013 at 1:35 pm
Sean Lange (8/22/2013)
Koen Verbeeck (8/22/2013)
Jack Corbett (8/22/2013)
Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:
Aw fudge....
August 22, 2013 at 1:34 pm
There is no direct alternative for patindex in the derived column. So you can either use a script component with .NET, or stick with SQL.
August 22, 2013 at 1:30 pm
Yelena Varshal (8/22/2013)
You can use package variables.
Use @@Rowcount to get the number of rows returned by the query
http://technet.microsoft.com/en-us/library/ms187316.aspx
Assign this @@Rowcount value to a package variable
Very, very curious how you would...
August 22, 2013 at 1:26 pm
This question is way too broad to be answered in a simple forum reply.
You can start by reading the Data Warehouse Toolkit by Ralph Kimball.
A quick search on Amazon should...
August 22, 2013 at 1:21 pm
Unfortunately it is not straight forward to work with multi-value parameters.
SQL Server Reporting Services Using Multi-value Parameters[/url]
August 22, 2013 at 1:19 pm
Jack Corbett (8/22/2013)
Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on me:w00t:
Aw fudge. I was hoping you...
August 22, 2013 at 1:14 pm
jasona.work (8/22/2013)
I'm almost tempted to start reading this topic from page 1...
August 22, 2013 at 1:13 pm
Jack Corbett (8/22/2013)
Koen has provided some very solid advice (as usual).
Aw shoo, you make me blush :blush:
😀
August 22, 2013 at 1:11 pm
Hugo Kornelis (8/22/2013)
This reply has been left deliberately emoticon-lessSee?
I can do it!
Nice to see you're following the 12-step program to an emoticonless life 😀
August 22, 2013 at 1:07 pm
Viewing 15 posts - 5,071 through 5,085 (of 11,678 total)