InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:50:46 GMT20http://www.sqlservercentral.com/Forums/Topic1368809-148-1.aspxOption - 1: You can make use of LookUp and Condition Split Transformation to achive this.Option - 2: You can do this by Creating a Procedure. A. Load all the data's to Staging Table.B. Create Procedure and load latest data's, by Comparing Staging and Fact table data's and then load the latest data's.Wed, 10 Oct 2012 00:40:53 GMTsqlusershttp://www.sqlservercentral.com/Forums/Topic1368809-148-1.aspxThanks Rhythmk..I have loaded unmatched data via ErroroutputRegardsSqlstudWed, 10 Oct 2012 00:31:44 GMTsqlstudhttp://www.sqlservercentral.com/Forums/Topic1368809-148-1.aspx[quote][b]sqlstud (10/4/2012)[/b][hr]Hi,Need to transfer data from database Db1 (Db1.sampletab1) to database Db2 (Db2.sampletab2) using ssis 2005.Condition:If matched data, leave as it is.If unmatched data, then insert the records into DB2.sampletab2 Is this possible in SSIS 2005? If yes, could you please let me know the steps?CREATE TABLE [dbo].[sampletab1]([pKey] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,[SasId] [nvarchar](max) NULL,[Name] [nvarchar](max) NULL,[TypeId] [nvarchar](max) NULL,[UserName] [nvarchar](max) NULL,[CreatedDateTime] [datetime] NULL,[CompletedDateTime] [datetime] NULL,[Boolean] [bit] NULL,) insert into sampletab1 values('sdf','werwer','s233','xzfdsdf',12/11/2011,14/11/2011,'TRUE')RegardsSqlStud[/quote]Very much possible.You can simply handle it by writing except query or you can also use conditional split.However few query here.1. How you are recognising new record means what is the unique field.2. Why are you leaving existing record as in ideal scenario we usually update the old records i.e. genearally we use UPINSERT logic for this type of scenario.Thu, 04 Oct 2012 22:56:44 GMTrhythmkhttp://www.sqlservercentral.com/Forums/Topic1368809-148-1.aspxHi,Need to transfer data from database Db1 (Db1.sampletab1) to database Db2 (Db2.sampletab2) using ssis 2005.Condition:If matched data, leave as it is.If unmatched data, then insert the records into DB2.sampletab2 Is this possible in SSIS 2005? If yes, could you please let me know the steps?CREATE TABLE [dbo].[sampletab1]([pKey] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,[SasId] [nvarchar](max) NULL,[Name] [nvarchar](max) NULL,[TypeId] [nvarchar](max) NULL,[UserName] [nvarchar](max) NULL,[CreatedDateTime] [datetime] NULL,[CompletedDateTime] [datetime] NULL,[Boolean] [bit] NULL,) insert into sampletab1 values('sdf','werwer','s233','xzfdsdf',12/11/2011,14/11/2011,'TRUE')RegardsSqlStudThu, 04 Oct 2012 22:22:43 GMTsqlstud