MartinIsti MS BI blog

Sign in | Help
  • Home
  • About
  • RSS
  • Atom
  • Comments RSS

Search

Tags

  • 445
  • 446
  • Analysis Services
  • BI
  • column order
  • conversion
  • CRM
  • data type
  • DATE
  • Default Member
  • deployment
  • Dimension
  • Drillthrough
  • dtexec
  • dtutil
  • exam
  • Excel
  • export
  • filter
  • identity
  • insert
  • logins
  • MDX
  • MSDB
  • NULL
  • OLAP
  • Oracle
  • OrderBy
  • Page Viewer web part
  • parameter
  • Parameters
  • process
  • Reporting Services
  • Reports
  • roles
  • ROW_NUMBER
  • script
  • ServiceAccount
  • SharePoint
  • Snowflake
  • split
  • SQL Server
  • SSAS
  • SSIS
  • SSRS
  • Star
  • sysdtspackages
  • T-SQL
  • Visio
  • web service

Navigation

  • Home
  • Blogs
  • Photos
  • Downloads

Archives

  • October 2010 (2)
  • June 2010 (4)
  • March 2010 (1)
  • February 2010 (2)
  • June 2009 (1)
  • April 2009 (3)
  • March 2009 (4)
  • February 2009 (4)
  • December 2008 (5)

BI blogroll (the ones I read)

  • Teo Lachev's Weblog
  • Chris Webb's BI blog
  • SSIS Junkie
  • MS BI blog
  • Marco Russo (SQLBi.EU)

Contact

  • My email

Browse by Tags

All Tags » split (RSS)
  • conversion
  • NULL
  • SSIS

SSIS Nugget - from NULL to NULL but different datatype by MartinIsti

It's so simple yet I spent quite many painful minutes with that. The issue is that I have flat files to use as sources. They have 1 header row and 0 or more detail rows. Since I cannot divide the file in the connection manager for the header row ...
Filed under: SSIS, split, NULL, conversion
Powered by Community Server (Commercial Edition), by Telligent Systems