In this video SQL Server Integration Services(SSIS) Tutorial, you will learn how to use Flat File Source,While using Flat file source to read the blank values from csv/text file how those rows can read as Null values instead of blank. The part of video also teaches how to use Multicast transformation as test and implement Data Viewer to see the rows while debugging SSIS Package.
How to Convert Blank Values to Null in Flat File Source in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial
Check out our other related posts/videos on different SSIS Sources
- How to Load Tab Delimited File To SQL Server Table in SSIS Package
- How to Load Pipe Delimited File into SQL Server Table in SSIS Package
- How to Load Multiple Comma Delimited Files to SQL Server Table in SSIS Package
- How to Load Fixed Width Text File to SQL Server Table in SSIS Package
- How to load Data From Comma Delimited text file to SQL Server Table in SSIS Package
- How to use Raw File Source in SSIS Package
- Fast Parse Flat File Source Property in SSIS Package
- How to Redirect Rows from Flat File Source for Data Conversion Error and Truncation Error?
- How to use Stored Procedure with Parameters in OLE DB Source in Data Flow Task in SSIS Package
Hi ,
ReplyDeleteCould you please provide us source file for data it would be very useful for us .
Thanks