Viewing 15 posts - 166 through 180 (of 601 total)
Could be missing something but is there a reason you aren't doing this all in one data flow?
Seems to me your outer "loop" is a deconstructed data flow
January 29, 2015 at 1:55 pm
Well, yes that is half of it. Now you should be able to query the records that violate the would be constraint as this seems to confirm the constraint...
January 23, 2015 at 1:47 pm
Build a staging table without the constraint, change that to the destination, and then try to copy over with an insert select and see what error message you get from...
January 23, 2015 at 12:12 pm
girish.nehte-1109699 (1/23/2015)
I am having a limited knowledge in SQL. Let me explain my scenario in detail. I have to write a Stired Procedure with the following functionality.
Write a simple...
January 23, 2015 at 9:35 am
It would be a huge help if you constructed an example for us where there was DDL for a sample table, insers of sample data , and then the...
January 22, 2015 at 11:59 am
Correct.
January 21, 2015 at 3:04 pm
Only thing I can think of that would trip you up would be package encryption settings. If your logins for the VMs are local instead of windows auth,...
January 21, 2015 at 10:20 am
J0shu@ (1/16/2015)
A higher level question with regards to implementation strategy. When implementing a SSIS package, should the priority of process be put on the SSIS side as much as...
January 17, 2015 at 8:19 am
J0shu@ (1/16/2015)
January 16, 2015 at 9:29 am
cstg85 (1/16/2015)
January 16, 2015 at 9:26 am
Polymorphist (1/9/2015)
Folks i'm dead in the water here - can anyone help at all? Nothing I try works and I have a feeling i'm overlooking something very simple.
Forgive me...
January 15, 2015 at 9:50 pm
It appears that it does a count and as long as the serial number and test type match. Is it possible to get it to count just the rows...
January 15, 2015 at 9:45 pm
Edit: its my fault, copy and paste on my query cut off the top of it. Also think I was missing one table and duplicating one as I did it...
January 15, 2015 at 8:16 pm
Here is what I used as testing tables and the query:
Testing Data
-- attn table
CREATE TABLE [dbo].[Attn](
[AttnID] [int] NOT NULL,
[MacroID] [int] NOT NULL,
[ProductNumber] [varchar](30) NULL,
[TestType] [varchar](20) NULL,
[SerialNumber] [int] NULL,
[TestDateTime] [datetime] NULL,
[Operator]...
January 15, 2015 at 4:40 pm
There seem to be some problems with the test data. Different number of columns and missing quotes on the insert from attn to start
January 15, 2015 at 4:30 pm
Viewing 15 posts - 166 through 180 (of 601 total)