Viewing 15 posts - 8,926 through 8,940 (of 11,678 total)
Great question. You got me at "unique value for every row".
October 25, 2011 at 11:43 pm
Very interesting question, but some more explanation on the precedence would have been nice.
October 25, 2011 at 11:36 pm
Nice straightforward question, thanks.
October 25, 2011 at 11:31 pm
Phil Parkin (10/4/2011)
Maybe in another five years, the answer will instead be "select the desired value from the scope dropdown menu from within the variable's properties" 🙂
Luckily, you won't have...
October 5, 2011 at 12:46 pm
You can use a script component as a transformation that will increment a counter for every row and puts the result in the output buffer.
You can find an example here:
http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspx
October 5, 2011 at 12:33 pm
subasuga (10/4/2011)
NTILE just divides the dataset into the given number in NTILE(int) accordingly. But i want to divide the dataset (whatever lines there may be) to 5 - 5 rows..
I...
October 4, 2011 at 5:03 am
Anand.A (10/4/2011)
how to pass table value to variable in ssis
Here you go:
October 4, 2011 at 3:52 am
What is the error?
Try == instead of =
October 4, 2011 at 3:37 am
Sha_ (10/2/2011)
I'm not sure if I'm going this correctly, but I am trying to assign a variable in a script task using c#. I've added this:
public void Main()
...
October 4, 2011 at 3:34 am
Each time you restart the SSIS package, the variable value will be reset. So I would store something like that in the database.
(Or just retrieve it from the table itself...
October 4, 2011 at 3:32 am
Try the NTILE function:
October 4, 2011 at 3:30 am
Viewing 15 posts - 8,926 through 8,940 (of 11,678 total)