Forum Replies Created
Viewing 15 posts - 7,051 through 7,065 (of 13,876 total)
-
RE: Question on activity diagram for source to destination flow
DF1 starts, executes and finshes and then DF2 does the same. How you diagram that is up to you.
-
RE: Question on activity diagram for source to destination flow
mcfarlandparkway (6/13/2016)
There is precedence constraint between two data flow tasks.Once first data flow task is finished transferring data from source to target its coming to second data flow task.
OK. Then...
-
RE: Question on activity diagram for source to destination flow
If there are no precedence constraints between the two dataflow tasks on the control flow tab, they will execute in parallel. Does that answer your question?
-
RE: CTE Replacement for Bi-Directional Recursion
michael.french 172 (6/13/2016)
Phil,I totally agree with points 3 & 4. With points 1 & 5, they are crucial to handle the recursion efficiently as coded. As for point 2, since...
-
RE: CTE Replacement for Bi-Directional Recursion
Wow. Not sure about the error, but I have some quick comments about the proc:
1) If you create the index after the first insert rather than before, it is likely...
-
RE: CTE Replacement for Bi-Directional Recursion
Can you post the proc?
-
RE: alien linked servers
FridayNightGiant (6/13/2016)
I don't know what you mean by alien in this context.Looks like an alien server:
-
RE: CTE Replacement for Bi-Directional Recursion
Does your proc start with
SET NOCOUNT ON;
? If not, please add it and try again.
-
RE: CTE Replacement for Bi-Directional Recursion
...however SSIS cannot read column metadata from a stored procedure.
You can get around that. You need to specify WITH RESULT SETS in your OLEDB source query and all will...
-
RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters
GilaMonster (6/13/2016)
Y.B. (6/13/2016)
Also Phil is right...better to make use of a MERGE here anyway.I disagree MERGE is NOT atomic (it should be, it isn't) and hence both it and the...
-
RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters
fabriziodb (6/13/2016)
kapil_kk (6/13/2016)
Hi,Why are you doing deleting and insertion on the same id value?
what you want to accomplish from that.
the goal is to update text valus if a record with...
-
RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters
Two procs trying to delete and insert the same @Id at the same time? Why would you expect anything other than a PK violation?
-
RE: Restoring a database (without effecting original) - to test the retore process...
jellybean (6/13/2016)
Thanks for the advice. Forgive me but how do you create a different SQL instance lets call it "TestInstance"Another instance = another install of SQL Server.
-
RE: Need ssis expression
komal145 (6/10/2016)
thing is agebucket column has "(other)" as value and "65+" this is not working:(how to check if this values exists just palce this value in the column?
This is important...
-
RE: Are the posted questions getting worse?
Brandie Tarvin (6/10/2016)
Ed Wagner (6/10/2016)
WayneS (6/10/2016)
Phil Parkin (6/8/2016)
And why not ask them to make it idempotent while you're at it:IF COL_LENGTH('dbo.mytable', 'col1') IS NULLBEGIN
...
Viewing 15 posts - 7,051 through 7,065 (of 13,876 total)