Viewing 15 posts - 31 through 45 (of 1,345 total)
There's no easy way to do this in sql.
However there are many.
For code consolidation use a inline function.
But you need to figure out what you want to do when there...
April 22, 2013 at 10:15 am
Are you talking on execution, or is your app creating Ssis packages?
April 19, 2013 at 1:21 pm
Looks like that functionality is SSMS 2008.
I started using SSMS 2012 a while back and it does not do this. SSMS 2012 is fully compatible with 2008 instances, I'd advise...
April 19, 2013 at 11:14 am
Yeah, you need to create an expression.
Its fairly easy tho.
Add a new parameter, call it something like 'strUpdateSQL'
change it to a string.
Make sure you Properties Pane is open (F4)
Click on...
April 19, 2013 at 8:38 am
You could do this using workflow and Expressions.
But I wouldn't. I try to make all packages do a simple job or task, then chain packages together. Helps testing, isolation of...
April 17, 2013 at 2:21 pm
I have had no problems using execute sql task to populate a variable. How do you have it configured?
Also in your data flow task you can instead place a Row...
April 15, 2013 at 9:57 am
Year Function will return an Integer, so
Year([Date]) >= 2009 should work.
Are you getting any errors?
April 10, 2013 at 8:44 am
Not sure what you mean by this, can you please provide examples
April 8, 2013 at 4:10 pm
Don't know if you have this figured out yet or not.
Lets break down the expression
Cost == "DRU" ? Values : NULL(DT_I4)
Cost=="DRU" is the expression or if statement if you will.
So...
April 7, 2013 at 10:14 am
Also in your Destination Container make sure the Table Lock box is checked.
You may also want to look at removing all indexes from your destination table.
This may speed the load...
April 4, 2013 at 11:24 am
You can design your package in a way to figure this out.
Use a sql task to query and stuff the resultset into a variable
IF EXISTS (SELECT * FROM NewDatabase..Table)
...
April 4, 2013 at 11:08 am
A tablix is going to display 1 row for each row in the dataset unless you create a row group.
That's all there is to it.
Your probably getting some cool display...
April 4, 2013 at 9:44 am
Not if you load it into a staging table in SQL first then use SQL to complete the transform to the final table as I suggested.
Lynn Pettis
Sure it would but...
April 3, 2013 at 3:35 pm
Depends,
Does the data get updated on any of the existing rows?
Does the Source table have a key column that you can use to tell if the data is in the...
April 3, 2013 at 3:34 pm
Lynn Pettis (4/3/2013)
April 3, 2013 at 3:12 pm
Viewing 15 posts - 31 through 45 (of 1,345 total)