SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
6 answers
One of the answers was accepted by the question author.
MSFT Oracle Connector (SSIS) fails to install
Host Windows 10 Visual Studio 2022 Running this install: MicrosoftSSISOracleConnector-SQL22-x64.msi What would cause this fault below? This installed without error: MicrosoftSSISOracleConnector-SQL19-x64.msi
asked 2024-02-02T17:56:36.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 5%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Mark Covian
21
Reputation points
answered 2024-02-12T15:45:44.48+00:00
Mark Covian
21
Reputation points
0 answers
SQL Agent SSIS job step fails with "The login is from an untrusted domain and cannot be used with Integrated authentication"
A user raised an issue with me today where a SQL Agent SSIS job step was failing with: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication The SSIS step was using an SSIS subsystem proxy rather than the…
asked 2023-09-15T16:28:42.2066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
161
Reputation points
edited a comment 2024-02-12T11:07:43.8033333+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
0 answers
SSIS: Import data from three databases / tables into one table using "Foreach Loop" -> Which Data Source inside Data Flow Task?
Good day, I have three different databases on three different SQL Server. Inside each databases there is a table which I'd like to import info a new table (new database server, new database). In the future I'll have more databases and more different…
asked 2024-01-05T06:48:29.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 61%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Stev Wagner
0
Reputation points
commented 2024-02-12T10:51:21.5933333+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
0 answers
Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"
We got this error when it was processing a tabular model partition in SSAS from an SSIS package. This is the JSON that process the partition: { "refresh": { "type": "full", "objects": [ { "database":…
asked 2024-01-10T18:43:53.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
Irama Abello Moreno
0
Reputation points
commented 2024-02-12T10:47:41.44+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
0 answers
SSIS Custom Object Type Transform Issue
I created a new tool for SSIS with a boolean data type output column, but when I test the tool, I received values "<Missing Reference>" on a column. The code I used is below. Can someone help me identify the problem? public override void…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,346 questions
asked 2024-02-05T20:50:53.3933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 96%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Radwan Alchen
0
Reputation points
commented 2024-02-12T10:29:57.0466667+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
3 answers
SQL Server error: systemassertion check has failed
Dear colleagues, Since some days ago one of our data insert process on SQL Server (based on SQL Intgeration Services) is failing with the error provided below. We have followed all the suggestions displayed on the message (running DBCC CHECKDB, install…
asked 2024-02-12T09:14:48.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 49%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gonzalez Comas Alfons (F4E)
0
Reputation points
answered 2024-02-12T10:23:55.5766667+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
0 answers
Running SSIS package in cmd with config file but encounters error
Hello there. I have created several SSIS packages to import CSV files into a SQL Server database. Inside the packages, the connection to the SQL Server database is defined. And running with dtexec cmd it works fine. I have saved the InitialCatalog,…
asked 2023-12-08T06:24:55.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 23%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYX%3C/text%3E%3C/svg%3E)
Yu, Xueke (JP - AB 余 雪柯)
0
Reputation points
commented 2024-02-12T06:03:11.3333333+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
2 answers
How can I view the defintion of the ssisdb project stream fetched from SSISDB.internal.get_project_internal stored procedure?
I have access to SSISDB database but not to the project saved in Integration Services Catalog. So I cannot view the project definition. Is there a way I can use the binary stream returned by the stored procedure SSISDB.internal.get_project_internal to…
asked 2024-02-08T12:52:11.3466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 35%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Viola Rodrigues
0
Reputation points
commented 2024-02-09T07:12:22.5366667+00:00
Viola Rodrigues
0
Reputation points
1 answer
Installing SSDT 15.8 for visual studio 2017 failing to install
Hello, I am trying to install SSDT 15.8 for visual studio 2017 on windows 11 and keeps on failing. VS 2017 is installed with Data Storage and Processing option. I have tried uninstall/install of VS 2017, frame work 4.8 multiple times without any success.…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
179 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,357 questions
asked 2024-01-22T22:17:06.7333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HP
21
Reputation points
edited a comment 2024-02-09T05:45:16.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
27,791
Reputation points Microsoft Vendor
2 answers
Using Powershell run SSIS Package(.dtsx file)
I am trying below code(in .dtsx) :- Clear-Host # Define the path to the 32-bit dtexec.exe $dtexecPath = "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\dtexec.exe" # Define the path to the SSIS package (.dtsx file) $packagePath =…
asked 2024-02-07T07:31:30.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 38%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jerry_2424
0
Reputation points
edited a comment 2024-02-09T05:32:56.82+00:00
Jerry_2424
0
Reputation points
3 answers
SSIS package no longer running in 64 bit mode.
I have an ssis package, that is deployed to the catalog and run as part of a sql job (sql server 2022). The job is no longer running. The package is giving the below error: An integration services class cannot be found. Make sure that integration…
asked 2024-01-31T21:55:14.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Cohen
0
Reputation points
commented 2024-02-07T18:39:14.46+00:00
David Cohen
0
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS project supported in VS2022?
Got error opening SSIS project in VS2022 and read from articles from internet (dated Nov 2021) that VS2022 does not support SSIS project yet. Would like to check if SSIS project is STILL not supported in VS2022. Thanks.
asked 2022-02-22T02:16:19.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 4%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Leau Bee Lin
91
Reputation points
commented 2024-02-05T21:23:08.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,116
Reputation points
1 answer
SSIS: Second Execute SQL Task can not access the global temp table built by the first Execute SQL Task
I have an SSIS project where I need to build a temp table from sql server 1 and access it from sql server 2. Here is what I tried and I boiled it down to a simplied version: I have the first execute sql task to built a global temp table from ole db…
asked 2024-01-28T23:51:11.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 12%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
Yu, Ying
0
Reputation points
edited the question 2024-02-05T12:37:24.09+00:00
Tianyu Sun-MSFT
27,791
Reputation points Microsoft Vendor
1 answer
not able to write SQL command for ODBC source in SSDT 2017
Hi All, I am using SSDT 2017 and trying to write SQL query in ODBC source. But I cannot see the SQL query pane itself. Could some on throw some light on this issue please. PFB screenshot.
asked 2021-01-22T11:29:58.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sree
11
Reputation points
edited a comment 2024-02-05T09:24:47.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 40%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Salendra, Nagaraju (Cognizant)
0
Reputation points
1 answer
2007 Office System Driver Data Connectivity Components
I need 2007 Office System Driver Data Connectivity Components download but it says Microsoft took it down. I need it because you don't fully support SSIS in Visual studio 2022 yet. So I'm using Visual studio 2017 to build my SSIS packages with Excel…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,438 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
asked 2024-01-31T15:58:06.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Micah Holmes
1
Reputation point
commented 2024-02-01T14:07:10.8666667+00:00
Micah Holmes
1
Reputation point
1 answer
One of the answers was accepted by the question author.
how to fix an error : Windowed functions cannot be used in the context of another windowed function or aggregate.
below is the query : DECLARE @InputValue INT = 840; SELECT @InputValue AS InputValue, SUM((CASE WHEN @InputValue >= PRRangeUpto THEN (LEAD(PRRangeUpto, 1, @InputValue) OVER (ORDER BY PRRangeUpto) - PRRangeUpto) * PRRate …
asked 2024-02-01T08:48:54.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 28.000000000000004%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Priyanka Awasare
20
Reputation points
accepted 2024-02-01T09:30:39.67+00:00
Priyanka Awasare
20
Reputation points
2 answers
SSIS sets numeric columns as Unicode String in Excel Destination
ExcelDataConversionIssue.JPGI'm creating a SSIS package with Source SQL Server Table and destination Excel. The source Numeric data type taking as Unicode String in Excel Destination by default. But my requirement is the Excel Destination data type…
asked 2024-01-31T14:31:14.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 37%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Rahman, Neyaz
0
Reputation points
answered 2024-02-01T05:47:41.01+00:00
ZoeHui-MSFT
33,386
Reputation points
2 answers
One of the answers was accepted by the question author.
Findstring issue SSIS
I have a string like (first)0001ABC_Leo, i want to extra the value with 0001ABC. I tried with findstring but it doesn't work. Please help！Thank u in advance.
asked 2024-01-29T08:20:30.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SLi
105
Reputation points
edited an answer 2024-01-31T15:08:57.4933333+00:00
Yitzhak Khabinsky
25,116
Reputation points
2 answers
How to load the Xml file as an XML Column datatype through ssis
Requirement- I want to load the xml file directly into the column as an xml data type through ssis package. Please share the screenshot of each component to be used in the ssis and complete process. I referred internet and this community. Xml…
asked 2024-01-29T20:51:56.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rahul
251
Reputation points
answered 2024-01-30T13:16:19.9+00:00
Yitzhak Khabinsky
25,116
Reputation points
3 answers
One of the answers was accepted by the question author.
Loading XML file into XML column using SSIS
Hi everybody, I believe I already asked this question before, but I have a need for it again and could not easily find info, also hoping for new ideas. I want to be able to pick an XML file from a directory (XML file will be read from a variable)…
asked 2022-05-27T14:47:15.743+00:00
Naomi
7,361
Reputation points
commented 2024-01-29T22:17:42.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
335
Reputation points