Skip to content

Sqljunkieshare

  • Home
  • About

Tag: raw source

How to remove blank rows or empty rows in SSIS Data Flow task from a Flat file source or Excel Source, Raw source

February 22, 20121 Comment

How to remove blank rows or empty rows in SSIS Data Flow task from a Flat file source or Excel Source, Raw source


Here I have a flat file source which has some blank values
































Simple and easy trick

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

  • 791,140 hits
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×
    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