Stack Overflow
Stack Overflow

Questions tagged [ssis-2019]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2019 is a part of SQL Server 2019 Data Tools

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2019 is a part of SQL Server 2019 Data Tools

47 questions
0
votes
0 answers

Column expression translation

This is an excel condition but I want to be written out in the derived column expression field =IF(Z2<0,"Late",(IF(AND(Z2>-1,Z2<16),"0-15 Days",(IF(AND(Z2>15,Z2<31),"15-30 Days",(IF(Z2>30,"30+Days",Z2)))))))
Safe
  • 1
  • 3
0
votes
2 answers

SSIS - IF AND STATEMENT

how can this if and statement be written in derived column. IF(AND(AD2>-1,AD2<16),"0-15 Days",(IF(AND(AD2>15,AD2<31),"15-30 Days",(IF(AND(AD2>30,AD2<91),"30-90 Days",(IF(AD2>90,"90+Days",AD2))))))) how can this be written in derived column
Safe
  • 1
  • 3
0
votes
0 answers

How can I fix an error when opening project?

My question is regarding Microsoft Visual Studio 2019. When I want to open my projects I'm getting an error. Who has ever faced such a problem? Below is this error: An error occurred in 'FirstProject' while attempting to open…
Nodir
  • 1
0
votes
1 answer

Loop through table while records keep getting added to the table

I have a table (FilesToCopy) with a list of filenames. id filename 1 c:\temp\file1.txt 2 c:\temp\file2.txt 3 c:\temp\file2.txt One by one the files get copied to another location (eg c:\test). I can loop through this table easy…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

How to use an SSIS Variable Value or Project Parameter Value as an expression body and then evaluate it to another Variable

I have an SSIS Project (Visual studio 2019 - Project Deployment Model) which contains 100 SSIS Packages. The name structure of each package is TableName_Table.dtsx (For example: If my table name is Employees then the package name will be:…
Panos_Koro
  • 45
  • 6
0
votes
0 answers

How to write NULL IN SSIS expressions

Requirement: Fullname = if type is "Y" then Name else NULL I tried expression type == "y" ? Name : "NULL" The field came as NULL as a string but would need as IS NULL Any help is much appreciated. Thanks in Advance
sindhuri lokesh
  • 3
  • 2
0
votes
0 answers

Getting the Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005

I am creating a new SSIS package, about 25 data flows. From Oracle database to SQL Server. IT always fails. Each container has about 8 data flows. When I run it, I always get the same error for different data flows. These are the errors: [Pull…
Roostam
  • 55
  • 1
  • 1
  • 7
0
votes
3 answers

Create files and folder to network drive using SSIS

I have created SSIS packages which creates new folder using file system task at output location and then creates data files in that folder using data flow task. I have created one network drive which is mapped to azure blob. So I pass the network…
MetaData
  • 116
  • 11
0
votes
1 answer

Split comma separated string columns into several rows in SSIS?

I want to achieve the output in 2nd table based on the input from the first table. I want to do this via a SSIS package.
Siva Bommana
  • 37
  • 5
0
votes
1 answer

Visual Studio 2019 SSIS dtexec config file Azure Blob Key

My question is around : storing Azure blob key in config file. Below is the picture of my package overview. I'm trying to pull data from Oracle source and put a flat file on Azure blob storage (in csv format). That is the scope of this SSIS…
junketsu
  • 533
  • 5
  • 17
0
votes
1 answer

SSIS Foreach Loop enumerate different SQL Server views data into a single staging table

I'm trying to setup a SSIS package to load multiple views data into a single staging table. All the views have same column structure and needs to be loaded into a staging table which also has same column structure. Purpose: we have 30 different…
gopi nath
  • 186
  • 3
  • 15
0
votes
2 answers

Better performance to load 6.5 million records from flat file to OleDb destination (i.e. database table)

Scenario I am using Visual Studio 2019 to load data from flat files (txt files) into SQL Server 2019 database tables. These are staging tables. I have 10 text files and need to make one package per file to load data in 10 different tables (staging)…
LV6001
  • 17
  • 4
0
votes
1 answer

SSIS ForEach Loop Container only processing one row

I have a simple job that grabs Employee IDs and sends them to an API call, which only accepts one Employee ID at a time. I have this setup using a ForEach Loop Container being fed by an Execute SQL Task. The job runs as expected, but it is only…
jdids
  • 561
  • 1
  • 7
  • 22
0
votes
2 answers

Substring from-to

I am working on a SSIS(2017) solution to read and load data from these 3 excel file names: message_EDF_100420202.csv message_UltaBIO_10042020.csv message_SEIDV_10042020.csv What I need to do is get only EDF or UltraBIO or SEIDV as a new column…
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
0
votes
1 answer

SSIS sending query with data parameter to Oracle cloud VS-2019 and MS Oracle Source

Already checked this post: SSIS and sending query with date to Oracle And I'm using variable query per below thread SSIS - Using parameters in Oracle Query using Attunity Oracle Datasource Tool used: VS-2019 Data flow: MS Oracle Source (for…
junketsu
  • 533
  • 5
  • 17
1 2
3
4