Questions tagged [conditional-split]
SSIS DataFlow Task Transformation component, used to split data based on specific conditions. It is similar to a `SELECT CASE`
conditional-split
35
questions
1
vote
1
answer
22
views
SSIS Conditional split triggering wrong script component PostExecute method
I have a SSIS package that is being developed in Visual Studio 2022 targeting SQL Server 2019 and I have a weird problem.
I have a data flow that refreshes a bearer token meaning it retrieves the ...
- 131
0
votes
0
answers
39
views
Possible reasons for an SSIS conditional split into the same destination table?
I've been given the unenviable task documenting the catalogue ingest process of our data warehouse. All was going well until the end where I came across the use of a conditional split inside of an ...
1
vote
1
answer
263
views
How to remove specific rows from data in SSIS
I am working on a SSIS package.
I have imported data from multiple sources.
Then I used UnionAll to combine the data.
I have an XML file, this file contains the rows that I have to remove. There is ...
0
votes
0
answers
19
views
Can we store just a clause of a WHERE condition into a variable in SSIS?
I want to change the clause of my where condition dynamically from the config file. So if I store the clause into a variable I can do it, I am not able to figure out how.... Need a solution for this
I ...
1
vote
1
answer
205
views
SSIS - send different emails to employees depending on employee situation
I'm fairly new to SSIS.
I have a pretty complex SQL query (that I don't want to replicate & maintain 3 times), whose result is a table with 2 columns:
emailAddress, formLetterNumber
What I want to ...
- 13
1
vote
1
answer
870
views
SSIS Conditional Split Error - The data type DT_BYTES cannot be used with binary operator "=="
While configuring a conditional split component with the following expression:
[VersionStamp_Source] == (DT_I8)[VersionStamp_Destination]
I am getting the following error:
The data type DT_BYTES ...
- 25
4
votes
2
answers
3k
views
SSIS Conditional Split Error - The expression evaluated to NULL, but the "Conditional Split" requires a Boolean results
It is my first time using this software. I am trying to split the value but it is showing this and I do not have any null have when I see my source but when I preview it, it shows null value in the ...
- 41
0
votes
0
answers
358
views
Using a variable as the input for a Conditional Split control
Might be going about this completely the wrong way - happy to be shown the error of my ways.
In a nutshell, I've got 50-odd files of mixed types (csv and excel) that I want to import (each file to its ...
- 5
0
votes
1
answer
282
views
What is wrong with my Conditional Split in SSIS?
I have created an SSIS package which extracts data from an Excel file and outputs the results into a table in my database.
As this package will be run on a daily basis, I need to extract only those ...
- 4,373
0
votes
0
answers
96
views
SSIS Conditional Split Not Working as Expected
I have the following Conditional Split set
Not Posted : O_Variance != 0 && O_L_Revenue_nSAP == 0
Need Investigating : O_Variance != 0 && O_L_Revenue_nSAP != 0
Posted : O_Variance == 0
...
- 15
0
votes
1
answer
1k
views
Conditional Split in SSIS - SQL
I'm quite new to SQL Databases, but I'm trying to add a Conditional Split in my Data Flow between my Flat File Source and OLE DB Database to exclude records containing some special characters such as ...
- 23
3
votes
5
answers
901
views
SSIS Expression to handle NULLs in multiple columns
I have an OLE DB source that has some nulls, it has 50 columns and I'm trying to extract the rows that have NULLs to Bad data destination, the expression that I had for the conditional split is
ISNULL(...
- 77
1
vote
2
answers
1k
views
SSIS query with rowcount conditional split writes 0 rows
I have an OLE DB source with a simple query that writes a flat csv file to the network. If I do only that, row(s) are written from the source to the file fine. But, I only want to do that if there ...
- 111
3
votes
1
answer
204
views
Use query as conditional split expression in SSIS
How to use the query below in conditional split , nxdt is a date column; it has values like 11/30/0002 00:00:00.000000. Hence used below query to filter out and need to use the same in my package
...
- 41
1
vote
2
answers
379
views
Is there a way to stop a conditional split after a certain date?
I have an SSIS package with a conditional split that essentially checks if one number is bigger than another.
The number is actually a financial period but this is stored as an int in a "yyyymm" ...
- 125