Capture null/blank values in an update statement

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Capture null/blank values in an update statement

Author

Topic

koln5
Starting Member

29 Posts

Posted - 2007-09-13 : 15:54:05

I have built a SSIS package that bascially updates two columns in table A...the update statement reads;

update Table A
set Colum 1 = ?,('?' is a variable)
Column 2 = ?

In my SSIS package, I would like to be notified/capture, if one or both variables are null....How do I do that ?..error log ?

The package runs fine both ways (if variables are null or not)

Thank you

mohit_sme
Starting Member

13 Posts

Posted - 2007-09-13 : 19:39:52

You can use Derived column or conditional expression to check the value of your variable and take action. Or even you can use expression to make your query and then you can check the value of your variable.

IsNull (VarName) ? 'Variable is NULL' : 'Variable is NOT NULL'

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources