Home Forums SQL Server 2008 SQL Server 2008 - General SSIS Conditional Split not working when run on SQL 2008 R2 using SQL Server Agent RE: SSIS Conditional Split not working when run on SQL 2008 R2 using SQL Server Agent

  • March 20, 2013 at 4:27 pm

    #1599183

    The source is a small CSV file with something around 10 rows. I'm using a flat file connection.

    The conditions are checking two string fields for different value combinations. There are three conditions total:

    CreditDebit == "CREDIT" && TransCode != "750"

    CreditDebit == "DEBIT"

    CreditDebit == "CREDIT" && TransCode == "750"

    The first two conditions are met when running via BDIS and SSIS directly, but pass no rows when run via SQL Agent. There's nothing in the source file that meets the third condition.

    The account used by the SQL Agent is a dedicated Windows-integrated account. We use a Windows-integrated account because both the source and target files reside on other servers.