Skip to main content
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
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
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
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
0 votes
0 answers
427 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
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
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
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
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
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
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
2 answers
47 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
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
0 votes
1 answer
778 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
0 votes
0 answers
383 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
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
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
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