Top Clicks

  • download.cnet.com/Optille…
  • sqljunkieshare.files.word…
  • go.microsoft.com/fwlink?P…
  • sqljunkieshare.files.word…
  • sqljunkieshare.files.word…
  • sqljunkieshare.files.word…
  • sqljunkieshare.files.word…
  • sqlserverpedia.com/wiki/W…
  • sqljunkieshare.files.word…
  • sqljunkieshare.files.word…
+

Sqljunkieshare

Menu

Skip to content
  • Home
  • About

Tag Archives: raw source

Posted on February 22, 2012 by akhil393 Tagged blank rowsdata flowexcelraw source CommentsNo Comments

How to remove blank rows or empty rows in SSIS Data Flow task from a Flat file source or Excel Source, 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


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
































Simple and easy trick

Recent Posts

  • Creating, querying, tuning hierarchical ROLAP cubes in Oracle
  • How to get name of the day or day of the week in SQL Server ,Oracle and Mysql
  • Column information of all the tables in a database (SqlServer2008 R2, MySQL, Oracle)
  • ISNULL , COALESCE in SQLSERVER, NVL in ORACLE, IFNULL() in MYSQL
  • Data Cube: A Relational Aggregation Operator : Microsoft research paper
  • How to summarize your data using ROLLUP and CUBE in TSQL
  • you will ‘%_[^LIKE]%’ like
  • watch out for nulls .. know ur environment
  • Genrating Non-Uniform random numbers between a range using TSQL
  • How to generate a simple calender table for a year using recursive CTE

Categories

  • Administration
  • Database Design – SQL server 2008, 2008R2 & 2012
  • Oracle
  • 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

Blog at WordPress.com. | Theme: Silesia by NattyWP.
Follow

Get every new post delivered to your Inbox.

Powered by WordPress.com