Viewing 15 posts - 9,451 through 9,465 (of 13,879 total)
Lowell (1/10/2014)
January 11, 2014 at 5:23 am
sharmili.net (1/10/2014)
why should not use OLEDB cmd since its processing each row..or any other specific reason is there?
That is the reason.
January 10, 2014 at 1:55 am
Inserts are best done using a dataflow.
Updates are best done as a set-based operation - meaning that the OLEDB command is NOT the way to go. One possibility is funneling...
January 10, 2014 at 1:40 am
sharmili.net (1/10/2014)
Hi Everyone,I want to update the table in a database, performance vice which transformation is best to use?
Thanks in advance.
sharmi
"Vice"? What is that?
January 10, 2014 at 1:10 am
harsimranjeetsinghwasson (1/9/2014)
and this result set is used to preparing...
January 10, 2014 at 12:24 am
What would the SSIS Syntax and could you tell me in a little more detail the steps that I take to accomplish this if not too much trouble?
Can you expand...
January 10, 2014 at 12:20 am
dwain.c (1/8/2014)
Phil Parkin (1/8/2014)
January 9, 2014 at 12:47 am
A few tasty techniques in that function Dwain. I have a quick follow-up question for you: as the function does not reference any external tables or views, does 'WITH SCHEMABINDING'...
January 8, 2014 at 10:59 pm
Luis Cazares (1/8/2014)
What about importing last column as a string and using a derived column to validate and convert value into int?
+1 that's what I'd do too.
January 8, 2014 at 10:31 am
DaveDB (1/7/2014)
Hi Phil,Thanks for the tip. Didn't even notice the apostrophes 🙂
No problem. My colleagues love the fact that I'm an amateur proofreader as well as a SQL Server professional:w00t:
And...
January 7, 2014 at 12:45 pm
DaveDB (1/7/2014)
I wrote a stored proc that basically aggregates some data based on how many Monday's, Tuesday's, Wednesday's etc in a current month (date range parameters)....
January 7, 2014 at 12:34 pm
I can't see any way of doing this directly, without using an additional param.
But logically, within your proc, can you assume that the nesting level can either:
1) Remain the same
2)...
January 7, 2014 at 12:22 am
rswinehart (1/2/2014)
If you feel you cannot create a naming rule that would always work,...
January 5, 2014 at 8:34 am
There are some issues that you will face with this solution.
Let's assume that you have the packages developed & deployed. You have 12 SQL Agent jobs created. You have built...
January 5, 2014 at 8:32 am
Sowbhari (1/3/2014)
January 5, 2014 at 8:03 am
Viewing 15 posts - 9,451 through 9,465 (of 13,879 total)