43 reputation
4
bio website
location
age
visits member for 2 years, 1 month
seen Oct 19 at 1:53

Sep
29
comment SSIS Get max value in column and create new column?
Thanks. There's some extra info in here I wanna check out. I'm only fed a text file for both sources which makes it constrained. But let me review.
Sep
25
comment SSIS Get max value in column and create new column?
Yeah I was trying to avoid a staging table if possible and keep it all in SSIS. Actually I need the Union of all records from a or b. Neither set alone contains the full list due to the source suppressing nulls. However your staging approach works regardless.
Sep
25
revised SSIS Get max value in column and create new column?
Possible solution
Sep
25
comment SSIS Get max value in column and create new column?
Both are daily and both are for the same day. The only issue is that Source B does not provide a date (though I know it's for the same day as A). Therefore after the join, some products have NULL date values because they don't exist in A.
Sep
25
comment SSIS Get max value in column and create new column?
In this case item number is the PK. However I am doing a full outer join because items without sales are suppressed from source a, and items without inventory are suppressed from source b
Sep
25
asked SSIS Get max value in column and create new column?
Dec
3
awarded  Tumbleweed
Nov
26
asked Improving User Registration Design
Nov
12
asked Why use asymmetric keys in SQL Server?
Oct
2
asked Structuring group membership
Sep
26
awarded  Editor
Sep
26
revised Integrating intranet web logins with AD emails
added 340 characters in body
Sep
26
asked Integrating intranet web logins with AD emails
Sep
7
awarded  Scholar
Sep
7
accepted SQL Server Transaction Log Initial Data Load
Aug
31
awarded  Student
Aug
31
comment SQL Server Transaction Log Initial Data Load
From what I've read SSIS uses BULK INSERT as its underlying operations? Either way it appears using the bulk operations aren't sufficient and the database needs to be set to bulk logged recovery mode prior to the operation
Aug
30
asked SQL Server Transaction Log Initial Data Load