Skip to main content
Stack Overflow for Teams is now Stack Internal: See how we’re powering the human intelligence layer of enterprise AI. Read more >
36 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
54 views

I want to insert into DB2 Database from SQL server using SSIS. The insert should happen multiple times in a day. Approximately need to insert 1 million records and needs to inserted short span. Tried ...
Maevrick's user avatar
  • 1
1 vote
1 answer
41 views

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 ...
Walters's user avatar
  • 131
0 votes
0 answers
53 views

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 ...
DickMille's user avatar
  • 1
1 vote
1 answer
624 views

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 ...
Reeds Official's user avatar
  • 13
0 votes
0 answers
20 views

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 ...
Yaduvamshi Birudukota's user avatar
  • 1
1 vote
1 answer
269 views

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 ...
Kristy JN's user avatar
  • 13
1 vote
1 answer
1k views

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 ...
Gidda's user avatar
  • 25
4 votes
2 answers
5k views

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 ...
Srijan Dixit's user avatar
  • 41
0 votes
0 answers
424 views

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 ...
Yonabout's user avatar
  • 5
0 votes
1 answer
362 views

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 ...
user3115933's user avatar
  • 4,483
0 votes
0 answers
99 views

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 ...
Geoff Codd's user avatar
  • 15
0 votes
1 answer
2k views

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 ...
Dan Wilkin's user avatar
  • 23
3 votes
5 answers
1k views

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(...
Big_Dwarf90's user avatar
  • 77
1 vote
2 answers
1k views

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 ...
Janet Barnett's user avatar
  • 121
3 votes
1 answer
218 views

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 ...
user3073172's user avatar
  • 41
1 vote
2 answers
479 views

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" ...
x1ras's user avatar
  • 125
4 votes
1 answer
1k views

In SSIS,I want to split the data after lookup based on whether any no match record is found or not .IF no match record has atleast 1 row or count it should process certain action. I used row count ...
cheers519's user avatar
  • 455
0 votes
0 answers
27 views

Conditional Split Expression: REPLACENULL(AddressLine1Txt,"") != REPLACENULL(OldAddressLine1Txt_1,"") || REPLACENULL(AddressLine2Txt,"") != REPLACENULL(OldAddressLine2Txt_1,"") || REPLACENULL(...
Syed's user avatar
  • 1
2 votes
1 answer
997 views

This is a bit of a conundrum I am trying to solve using SSIS and a conditional-split transformation. I have a .csv file that contains attribute data in one row for each unique user and the values for ...
user avatar
2 votes
2 answers
323 views

The flow I have to implement does the conditional splitting according to the last two characters of a column value. For code-maintenance and performance reasons, I need to do the splitting in C#. How ...
Bruno C's user avatar
  • 319
0 votes
1 answer
331 views

In the SSIS I have the conditions seen in the image. When I run the package all conditions process except the ActivityChange. If I run the package again Activity Change is executed. Both ...
crystalnoob's user avatar
  • 27
0 votes
1 answer
66 views

I am trying to follow the process below to transform data from flat file to DB. I also have an update_dt_tm column in the source. I need to put a condition that if updt_dt_tm is between last 10 mints ...
Doodle's user avatar
  • 479
0 votes
2 answers
46 views

I have to extract data from Flat files and load into a staging database ex: I have this flat file without column header and i would like to get each row into a seperate column Text file data: This ...
Hadrian's user avatar
  • 175
2 votes
1 answer
965 views

I have a Conditional Split task in my workflow which directs the data to one of three different destinations. All my data should go to one of these three destinations. If there is data that does not ...
Hoppy's user avatar
  • 770
0 votes
1 answer
72 views

I have 1 SSIS Conditional Split with 2 conditions, which I need to combine. Both conditions are looking for the same date. [DateFinished] > (DT_DBTIMESTAMP)"2016-09-01" [DateTBFinish] > (...
David F's user avatar
  • 265
-1 votes
1 answer
615 views

I've got a data flow task which has a conditional split which then leads to two different flat file destination. The thing that is puzzling me, is why do I have different 'available destination ...
Graham Reavey's user avatar
  • 25
0 votes
1 answer
771 views

When I run my SSIS package, I receive a #Name? in a column cells where no value is present, so I created a Conditional Split using the following condition, ISNULL(columnname) || LEN(columnname) == 0. ...
David F's user avatar
  • 265
1 vote
1 answer
3k views

I am trying to add a condition to a Conditional Split Transformation in SSIS but the double quote character at the start of a string in the condition is throwing an error. Here is my condition: (...
user2989759's user avatar
  • 299
0 votes
0 answers
380 views

First time posting a question here. Useless times this forum helped, but now, I fell my R skills are not strong enough to do the job. My problem is: I have a Spatial Data frame with multiples ...
Huub's user avatar
  • 1
0 votes
1 answer
2k views

Let's say I have two columns, one of location and one of dates, some of which are missing. City Date 1 Sheffield 19/05/1985 2 Sheffield 21/06/1986 3 Sheffield <NA> 4 ...
Nick's user avatar
  • 859
3 votes
1 answer
875 views

I am new to SSIS, so please excuse me if need to clarify my problem. We have 2 date columns, Release Date and Approved Draft Release Date. Currently, when a date is manually entered into the ...
David F's user avatar
  • 265
4 votes
3 answers
3k views

I'm trying to run an Excel table through an SSIS Package and 3 nodes in, it has a Conditional Split. I'm using a previously known working spreadsheet with some data added to it. The error I'm getting ...
Tyler C's user avatar
  • 633
5 votes
2 answers
5k views

I have seen this question and I tried what it suggested, but without any success (see Attempt 1 below). I have tried the below conditions in my Conditional Split without success. I have checked that ...
Tim Hutchison's user avatar
  • 3,653
1 vote
1 answer
6k views

I am trying to update records from an SSIS conditional split to destinations after comparing them but I am stuck on NULL values. I have a source table with 128 columns that needs to be compared to ...
OwenS's user avatar
  • 323
4 votes
1 answer
2k views

Good Day All, I have a select query where i pull the data from sql ie select invno , date_received from sales What i want to do is split the file into multiple files using conditional split. I don't ...
Kallie Reyneke's user avatar
  • 67
3 votes
1 answer
2k views

It's one of my practice stuff, setting the condition to split the scariness of rollercoasters. However, it didn't work properly as it did not split the default output which is set as "Not scary". I ...
Lancer Xue's user avatar
  • 118