SSIS LookUp is not dealing with NULLs like the docs say it should

by

I know this is a late answer, but for anyone searching on this like I was, I found this to be the simplest answer:

In the lookup connection, use a SQL query to retrieve your data and add UNION SELECT NULL, NULL to the bottom.

For example:

SELECT CarId, CarName FROM Cars 
UNION SELECT NULL, NULL

Preview will show an additional row of CarId = Null and CarName = Null that will be available in the lookpup.

More Related Contents:

  1. How can I load a large flat file into a database table using SSIS?
  2. Reporting Services permissions on SQL Server R2 SSRS
  3. SQL group_concat function in SQL Server [duplicate]
  4. Pivot Dynamic Columns, no Aggregation
  5. How to connect to local instance of SQL Server 2008 Express
  6. Export query result to .csv file in SQL Server 2008
  7. varchar(max) everywhere?
  8. T-SQL: Export to new Excel file
  9. T-SQL split string based on delimiter
  10. How to get the last record per group in SQL
  11. How to import text files with the same name and schema but different directories into database?
  12. How to convert float to varchar in SQL Server
  13. How to convert datetime in Persian in SQL Server
  14. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  15. Why is SQL Server 2008 Management Studio Intellisense not working?
  16. T-SQL substring – separating first and last name
  17. SQL Server: Split operation
  18. How to implement polymorphic associations in an existing database
  19. SQL Server Configuration Manager cannot be found
  20. How to deploy SQL Server Compact Edition 4.0?
  21. Temporarily disable all foreign key constraints
  22. Using IF ELSE statement based on Count to execute different Insert statements
  23. Restoring database from .mdf and .ldf files of SQL Server 2008
  24. What is the default transaction isolation level for SQL Server with ADO.NET?
  25. Restrict SQL Server Login access to only one database
  26. Avoiding IF ELSE due to variable been NULL
  27. How do I find the data directory for a SQL Server instance?
  28. Where are SQL Server connection attempts logged?
  29. How to execute dtsx packages through command line
  30. Forcing code-first to always initialize a non-existent database?

Leave a Comment