Building an SSIS EXPRESSION to test if a variable is empty

ssis ssis-2012
Deepak picture Deepak · Jul 22, 2015 · Viewed 9.1k times · Source

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

@User::AccountID != ''

Answer

V2k picture V2k · Jul 22, 2015

Use this

!ISNULL(@[User::AccountID])

Does it solve your problem?

Related questions

Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a …

Read More
SSIS Package not wanting to fetch metadata of temporary table

I have an SSIS Package, which contains multiple flows. Each flow is responsible for creating a "staging" table, which gets filled up after creation. These tables are global temporary tables. I added 1 extra flow (I did not make the package) …

Read More
SSIS - How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename

Any help is much appreciated. I am trying to create an SSIS package to loop through files in the folder and get the Path + filename and finally execute the stored proc with parameter as path+filename. I am not sure …

Read More