CODEWITHSUNDEEP
ssisssis-2012
Deepak
Deepak

Reputation: 123

Building an SSIS EXPRESSION to test if a variable is empty

I am building an expression in expression builder to do the following, but this gives me an error:

@User::AccountID != ''

Upvotes: 4

Views: 14764

Answers (2)

V2k
V2k

Reputation: 354

Use this

!ISNULL(@[User::AccountID])

Does it solve your problem?

Upvotes: 7

Rahul Sharma
Rahul Sharma

Reputation: 453

you can use ISNUll in expression builder :

https://msdn.microsoft.com/en-us/library/ms141184.aspx

Upvotes: 0

Related Questions