SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,732 questions
5 answers
SSIS not inserting all rows from ODBC (oracle) to SQL server 2019
I have an issue with migration to SQL server 2019. My Source is Oracle and my Destination is Microsoft SQL Server 2019. My package consists of a simple Data Load task; ODBC Source Connection(oracle)/ and OLE DB Destination connection(2019 SQL…
asked 2021-04-05T06:10:44.777+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, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kumar, A. be
16
Reputation points
commented 2024-02-18T08:42:25.26+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(278.4, 87%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CF
0
Reputation points
1 answer
SSIS Excel output from SP with a Temp table
I have an SSIS pkg that goes through the following steps: Pull data from Server A And Server B Put the data in Server C Server C has a Stored procedure that combines and compares the data from Server A and Server B Output in server C from…
asked 2021-10-04T16:30:37.543+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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%3C/text%3E%3C/svg%3E)
ojmp2001 ojmp2001
121
Reputation points
commented 2024-02-15T22:33:03.3366667+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(192, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Stevens, Victoria R
0
Reputation points
1 answer
Problem when editing a file created with SQL Server Integration Services in Visual Studio
When copying the conversion destination and conversion source of an SSIS package created in SQL Server using Visual Studio, the copy source is safe, but the data is added to the copied table without being deleted (the copy source table is deleted by…
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,629 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,613 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,732 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
asked 2023-11-28T05:22:14.12+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(246.4, 78%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
yamayama
0
Reputation points
answered 2024-02-14T07:34:12.2333333+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, 55.00000000000001%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Krishna Shah
0
Reputation points
3 answers
IN SSIS How to change SQL Authentication to Windows Authentication
HI I was trying to deploy the packages in to server it is erroring out with the below error . TITLE: SQL Server Integration Services The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account…
asked 2022-05-24T17:50:21.357+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, 17%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dinesh Shetty
1
Reputation point
answered 2024-02-14T07:09:31.4833333+00:00
Krishna Shah
0
Reputation points
2 answers
SSIS : Connecting SharePoint Site through OData Source
Hi All - I am connecting to a SharePoint site and i have edited the site at end like below and at the end i have added _vti__bin/List.svc also i am able to access the sharepoint site through my account. When i selected the Odata source and passed the…
asked 2023-07-13T00:04:27.4866667+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(284.8, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kkran
831
Reputation points
edited an answer 2024-02-13T12:09:48.6333333+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(76.8, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPZ%3C/text%3E%3C/svg%3E)
pankaj (ZappySys Team)
0
Reputation points
4 answers
One of the answers was accepted by the question author.
Calling a Restful API in SSIS and returning output
Hi All, I have a requirement to call a restful API fetch the results. Request will be in xml form and so the response also. I'm using VS 2019. Please let me know if you have any steps to implement this in c# script task or sample code. Thanks in…
asked 2020-12-01T17:24:37.1+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(160, 28.999999999999996%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VickyD
81
Reputation points
edited an answer 2024-02-13T11:39:41.62+00:00
pankaj (ZappySys Team)
0
Reputation points
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,454 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,261 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,454 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.
172 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,182 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,271
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
24,946
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,271
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