'm trying to import a text file but the primary key column contains duplicatres (tunrs out to be the nature of the legacy data). How can I kick out all duplicates except, say, for a single primary key value
TIA,
Barkingdog
Duplicate primary keys in input file
Hot Topic
- Sum of distinct count measure values returns same as distinct count. Need advise.
- NewID
- Problem with select from 2000 to 2005
- How can calculation members in mdx script win those in session and query scope?
- Return results of stored procedure
- SSIS package runs in Development Studio but not as a job
- Combining established columns into one
- negative values on a measure
- Debugging Parent / Child Packages
- Slow changing Dimension
SQL Server
- Error: SQL Server Internal Error. Text manager cannot continue with current statement..
- Tutorials on MDX Querries
- SSIS OLE_DB Command Error
- TransferDatabase task in SSIS
- Problem with select from 2000 to 2005
- Standby Server Running SQL Server 2000 and 2005 side by side
- Error in Merging partitions in AS 2005 from DSO
- Cross-dimension Security Dilemma
- Table Dependencies
- Question using Render method
Duplicate primary keys in input file
uncleschmidty
SORT component has the ability to eradicate dupes. Have you looked into using that
-Jamie
MarkA
No, but I will.
BTW does SORT allow me to send those dups to an "erorr" file so I can see I can further investigate those "bad" records
Barkingdog
Option
No, you can't do that. But you could easily use an AGGREGATE followed by a conditional split to get all those where the key appears more than once.
-Jamie