Skip to content

Sqljunkieshare

  • Home
  • About

Tag: SSIS

How to remove duplicates rows in SSIS data flow task from a Flat file source or Excel source, Rawsource

February 22, 2012February 22, 20121 Comment

Hi , Using a simple trick you can easily eliminate duplicate rows when using Flat file or Excel source or Raw source or any where in the Data Flow task























Simple and easy trick you can using any where in the Data Flow task

Thank you

SQLJUNKIESHARE

Recent Posts

  • Create RMAN Catalog and Register a Database in 12c
  • Setup SQL Agent alerts for User Error Messages
  • Failed to initialize sqlcmd library with error number -2147467259 [solved]
  • Log SQL Errors using Extended Events
  • Quickly Backup a Table and Import later
  • QuickTiP: Setup TNS less connection to Oracle in SSIS
  • FIX:OLE DB provider for linked server returned message “Query timeout expired”.
  • Simple powershell script to Bulk Load csv into a SQL Server table.
  • [FIX]The DELETE statement conflicted with the REFERENCE constraint FK_subplan_job_id. The conflict occurred in database msdb, table dbo.sysmaintplan_subplans, column job_id. The statement has been terminated
  • [solved] Docker and Windows 10 hyper-v Containers, byLinuxVM’ failed to start.. . Virtual machine ‘MobyLinuxVM’ could not be started because the hypervisor is not running

Categories

  • Administration
    • DBCC
    • Docker
    • Power Shell
  • Aurdino
  • Database Design – SQL server 2008, 2008R2 & 2012
    • SQL 2016
  • Hadoop
  • Oracle
  • R
  • SQL
    • Built-in T-SQL Functions (Updated SQL 2012))
      • Scalar Functions
        • Configuration Functions
        • Date time functions
        • String Functions
    • SQL SERVER 2012
      • TSQL 2012 New Features
    • SSIS
    • SSRS
      • Data Visualization
  • SSAS
    • MDX
  • Uncategorized

Sqljunkieshare

Sqljunkieshare

Blog Stats

  • 786,234 hits
Blog at WordPress.com.
Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy