Data insertion

Hot Topic

For each container - performance problem?
SQL Server 2005 Remote Connection Problem... Big Time.
SQL Server 2005 and 2000
Merge Join
Memory Issue with Simple CLR Based Table-Value-Function (TVF)
if/else newbie question (conditionalizing SELECT on old/new db, existence/abscence of a column)
Configure RS in sql express
Query optimization in query that uses CTE.
Errors processing SSAS 2005 Cube against SQL 2000 database
msbuild and sn commands are not recognized on command prompt. please advise.

SQL Server

Access MaximumErrorCount From script Task
SSIS Package runs fine except as a scheduled job
Passing Variables
Source and Destination table equality
nvarchar or varchar in function?
How to turn off logging
carrier return + line feed in a varchar
Where is the package running?
How to connect to Analysis Service Database through reporting service?
Query optimization - joining a view and a Table

Data insertion

Hello,

My project is to update a price table with a text file. 
But sometimes, there are new refs in text file that are not in my ref table.

How can i check it and automate the insertion of those new refs

Thanks a lot


Answer this question

Data insertion

  • elamey

    The LOOKUP component can tell you what rows in the pipeline are not in the lookup table by setting the component to redirect all rows not found in the target to the error output. There's an explanation of this at http://www.sqlis.com/default.aspx 311

    -Jamie


  • Data insertion
Answer this question