Get the Error Column Name in SSIS
This article will show how you can get the column name for error rows in an SSIS 2016 Data Flow task.
2018-10-29
11,637 reads
ErrorColumnName
RE: Query to remove duplicates from a table ? ?
If you have a unique id in the table you could try this:DELETE FROM namesaddressesWHERE id NOT IN (SELECT id FROM ((SELECT DISTINCT id, firstname, surname, address1, postcodeFROM namesaddresses)))Or if there is no RI on the table you could even Try something like this.SELECT DISTINCT firstname, surname, address1, postcodeINTO ##tempFROM namesaddressesTRUNCATE TABLE namesaddressesINSERT INTO namesaddresses […]
2005-04-28
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers