• Home
  • Blog
  • About
  • Contact

"platform to share ideas and knowledge about SQL"

NULL value for empty field when importing flat file in SSIS

SQL Basic Raj Leave a Comment

When importing data from text file you may need to apply NULL to the field where no values present (blank). Not doing so the package may fail. Consider a scenario;…

Read more »

How to get error description in SSIS dataflow

SQL Basic Raj Leave a Comment

In SSIS, there is no direct method to get the error description when error occurred during data Load and transformation. We can only redirect the failed records along with Error…

Read more »

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Categories

  • Data warehouse
  • How to topics
  • Index
  • Partition
  • Performance & Troubleshooting
  • quick bite
  • SQL Basic
  • SSIS

Topics

Compression Data warehouse Date DBCC DMV Error Handling Fact How to topics Identity Index JOIN OUTPUT Query Performance ROLLBACK SELECT SQL Server misc SSIS Table Table Partition Table Value Transaction TRUNCATE

Contact Us

  • Email
    contact@intellectSQL.com

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Site Links

  • About
  • Blog
  • Contact
  • Home
  • Privacy Policy

Contact

  • Email
    contact@intellectSQL.com

RSS blog – feed

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

About intellectSQL

intellectSQL is a platform to share ideas and knowledge about SQL, Data engineering, warehouse and more …

© 2025 intellectSQL
  • Home
  • Blog
  • About
  • Contact