View Complete Post
I have a process which reads from 2 tables (using two connection managers) and "merge join" them to a third table by using left outer join.
This process is implemented on SSIS 2005 and SSIS 2008 identically, however, for some reason I get
less records at the third table at the 2008 process.
I have two sets of data which are residing on different sources and i want cartisian product of it. Is it possible to do a cross join in SSIS.
I noticed this has been posted before - but could not get it working with the information on that post so here goes:
I have a T-Sql query that INNER JOINs 2 tables on one field - this returns 6,383 records.
(the one table contains 6,383 records and the other table 12 records)
However when I try to implement a data flow task with two data sources (one for each table) and sort the and then try to use the Merge Join transformation to sort and join them on the exact same field the result is 11,073 records.
What is going on here? logically this does not make sense to me ...
I have the scenario (using a third party component) where certain columns must not be present as input.
I am doing a Full Outer - Merge Join.
This results in:
but now in some cases the LeftPK may be null in other cases the RightPK may be null,
so i'm creating a derived column to check:
ISNULL(LeftPK) ? RightPK : LeftPK
and call this the TruePK
this all works however now i'm left with 3 columns
LeftPK; RightPK; TruePK
Is there some kind of transform (other than script task) that i can use to get rid of Left and Right PK columns before sending input to next third party component?
I'm working with SQL 2008 SSIS.ÃÂ I'm trying to join two tables onÃÂ email fields.ÃÂ For test purposes I have copied some of the email addresses from table A to table B to insue I have matching values.ÃÂ The OLE DB Source componentsÃÂ each use a SQL query that sorts the output by the email addresses in ascending order.ÃÂ ÃÂ For each of the two source components I've set the IsSorted property to True and set the Output Columns SortKeyPosition property to 1.ÃÂ Within the SQL query I've also added trim functions to eliminate any possible extra spaces.ÃÂ Since for testing purposes table B's email addresses are copies of email addresses in table A thereÃÂ is no issue with case.ÃÂ ÃÂ When linking the two outputs using the Merge Join flow component I do not get any matches.I've tried sorting using a Sort component rather than within the OLD DB Source query, but it seems to lock up on one of my flows (about 1.5 million records) and won't proceed.At this point I don't know what else to try.ÃÂ
I have an XML file like this:
<detail value1="hello" value2="world" />
how to merge two columns of a table using SSIS.
eg. EMPLOYEE.FIRSTNAME and EMPLOYEE.SURNAME to EMPLOYEE.FULLNAME
I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?
Thanks in advance.
I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table.
How do I join those two tables and get that field value in the existing select query.?