SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,600 questions
1 answer
Connection Manager not getting Iniialized
Hi, I'm currently writing a C# code in Script Component which is making a connection to MSSQL DB using ADO.NET Connection Manager. But it returns a NullReferenceException every time when I run it. I have tried the sample code as mentioned in the link …
asked 2024-09-04T15:02:14.76+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, 89%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Mittal, Umang
0
Reputation points
answered 2024-09-04T17:02:17.94+00:00
Olaf Helper
43,896
Reputation points
1 answer
Can i make data marts in SSAS?
I followed kimball approach but the problem is I didn't make data marts before star schema. Now my question is can I make data marts in SSAS or is it mandatory to make these marts before schema in kimball approach?
![](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(268.8, 80%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
![](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(291.2, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
2 answers
Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16
I'm getting the following error when attempting to open an Oracle source, destination, or connection manager in VS 2019. The text version of the above screenshot and message details are in the code block below. We began encountering this error after…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,019 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,558 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.
209 questions
asked 2024-06-20T18:12:19.3033333+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(70.4, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Amanda Hansen
0
Reputation points
commented 2024-09-03T13:36:57.44+00:00
Amanda Hansen
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Passing Variables to Oracle ODBC Source in SSIS 2019
Hi All, I have an SSIS package developed in VS 2019. It has an ODBC Oracle source with millions of records in a table. It transfers data to a SQL Destination. I'm trying to transfer 1 million record at a time by dynamically generating the SQL to use…
asked 2021-05-12T17:03:02.737+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(70.4, 23%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Deepak
121
Reputation points
commented 2024-09-02T07:24:53.5233333+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, 93%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hédel Nuñez Bolívar
0
Reputation points
1 answer
SSPI handshake failed with error code 0x80090346, state 46
Logon SSPI handshake failed with error code 0x80090346, state 46 while establishing a connection with integrated security; the connection has been closed. Reason: The Channel Bindings from this client are missing or do not match the established…
asked 2024-08-24T19:08:01.97+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, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Abhishek Kulkarni
0
Reputation points
commented 2024-09-02T02:07:46.5433333+00:00
LucyChenMSFT-4874
4,090
Reputation points
6 answers
Error Fix (Database engine service failed in sql server 2022 and 2019)
Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…
asked 2022-11-23T00:01:59.227+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, 54%, 16%)' 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)
Nelson Nwachia
51
Reputation points
commented 2024-09-01T23:34:28.0066667+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(153.6, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Chinedu Okechukwu
0
Reputation points
2 answers
Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).
I'm working on configuring Azure SQL Server authentication using Microsoft Entra Integrated. Here’s my setup: I have an Azure SQL Server with an active database. My laptop is connected to Azure AD. I’ve opened SQL Server Management Studio (SSMS),…
asked 2024-07-29T14:52:57.4433333+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(67.2, 76%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sam H
0
Reputation points
commented 2024-08-29T23:59:57.23+00:00
Oury Ba-MSFT
18,601
Reputation points Microsoft Employee
1 answer
What are the performance concerns or the issues that we might face when updating AutoAdjustBufferSize property to true from False in SSIS package task
Hi , We want to improve the performance of one of the task in the SSIS package . So , when we tried different approaches we found out that the performance increased when we update the below parameter in one of the SSIS dataflow Task. Before : …
asked 2024-08-26T18:42:04.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(230.39999999999998, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Nalam, Leela Naga Vivek
0
Reputation points
answered 2024-08-27T02:53:11.6733333+00:00
ZoeHui-MSFT
36,101
Reputation points
1 answer
How to resolve when Package failed in this scenario?
I have 10 excel sheets in the folder. I want to loop all these by using ForEachLoop Container. Package failed after loading data from first 4 excel sheets and I need to load remaining 6. How can I load data of remaining 6 excel sheets only into tables?
asked 2024-08-24T15:52:05.9733333+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(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ramana Kopparapu
286
Reputation points
answered 2024-08-26T06:08:44.7233333+00:00
ZoeHui-MSFT
36,101
Reputation points
1 answer
How to make a script to send mail using MFA within a SSIS package
Hello, everyone. I have a Visual Basic script within a SSIS Script Task to send mail inside the organization. We are usinng Microsoft Azure to manage the users accounts. Now, Microsfot is enforcing the MFA. Now we're getting this error: This is the…
asked 2024-08-24T17:46:35.1633333+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(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Geraldo Peralta
86
Reputation points
commented 2024-08-25T20:26:25.95+00:00
Geraldo Peralta
86
Reputation points
0 answers
Cannot find SQL Server Data Tools in Start Menu after installing Visual Studio 2022 on Windows 10 (Build 17763)
I have 64bit-Windows 10 Build 17763 (maybe the problem ?) and installed Visual Studio 2022 to get SQL Server Data Tools (selected from Options of Data Storage and Processing) for using in SQL Server BI. After the installation, I can't see SQL Server Data…
asked 2024-08-23T10:14:58.29+00:00
Working Soft
0
Reputation points
commented 2024-08-25T14:48:52.5733333+00:00
Working Soft
0
Reputation points
5 answers
make first letter capital of the word
Hi Expert, how to make first letter capital of the word create table main13( First_lastname Nvarchar (100)) insert main13 values('18 - EW MEMBER; OLD MEEMBER'), ('18 - VOYGER'), ('1 - ONE DAY') EXPECTED Output
asked 2022-03-24T15:34:05.797+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, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,411
Reputation points
commented 2024-08-25T13:36:00.7433333+00:00
Ramana Kopparapu
286
Reputation points
6 answers
SSIS2019 Unexpected termination
We upgraded to SQL Server 2019 and upgraded all SSIS project to target server 2019 . When we run SSIS package it runs for some time and then it crashes with Unexpected Termination. Below is reported in event viewer and there is no error in execution log.…
asked 2021-12-16T17:03:13.257+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, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Divyesh Patel
16
Reputation points
commented 2024-08-23T19:01: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(220.8, 2%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Andy Birenzi
0
Reputation points
3 answers
SSIS communication link failure tcp provider timeout error 258
Hello, I have a SSIS issue which is similar as this topic https://social.msdn.microsoft.com/Forums/en-US/94509c56-c702-4c6d-a5e2-1899a0dc68ef/shared-memory-provider-timeout-error-258?forum=sqlintegrationservices But the answer doesn't work for me. In my…
asked 2023-05-13T15:58:12.9733333+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(131.20000000000002, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL0%3C/text%3E%3C/svg%3E)
LiLiang-0529
5
Reputation points
edited an answer 2024-08-22T16:22:18.3666667+00:00
LiLiang-0529
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Does SSIS support creating centralized error handling package or DLL that can be used in various SSIS packages?
I have a few SSIS packages that have common process for sending email alerts, error handling, file import retrigger etc. When they have an error (validation issue with data, or an actual OnError , connectivity issue etc) then they all do the same thing,…
asked 2024-08-20T13:28:27.9733333+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, 44%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pranaya Rajalingari
20
Reputation points
commented 2024-08-22T14:42:56.9866667+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(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
53,316
Reputation points
1 answer
Is it possible for me to use a Data Governance tool like Alation to extract Data Quality metrics from SSIS? If so, how do I go about with this?
Hello! I am using Alation as a Data Governance tool, and SSIS as its Data Quality supplement. I am wondering what forms of integration is there possible with the two tools like the one I stated in my title, and whether SSIS has APIs (e.g. POST API) for…
asked 2024-08-21T08:52:38.91+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, 66%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
Louis Teo
0
Reputation points
answered 2024-08-22T07:46:42.0933333+00:00
ZoeHui-MSFT
36,101
Reputation points
1 answer
Error in Getting SharePoint online data through SSIS
Hi, I am using SSDT 2015 and trying to pull SharePoint Online data through oData connection. Providing service account to oData connector in place of personal account due to multifactor authentication. Service account is working as expected. But when…
asked 2024-08-21T12:49:12.43+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(22.400000000000002, 23%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gangwar, Pradeep Kumar
0
Reputation points
commented 2024-08-22T04:55:53.5266667+00:00
Gangwar, Pradeep Kumar
0
Reputation points
1 answer
How to resolve "A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal""
Integration Services Catalog was just created and we are trying to deploy a project to the new catalog. We get the following error message : Reviewed documentation on this error and completed the following trouble shooting steps: Temporarily…
asked 2024-08-20T19:25:13.6+00:00
Hannah Milam
0
Reputation points
commented 2024-08-21T17:16:23.8533333+00:00
Hannah Milam
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Extracting Last Name before comma
The name in the file are coming in two different format : Ahad,Ali Abdul -- Format 1 Doe John, West -- Format 2 I am using the following derived column expression: FINDSTRING(my column," ",1) != 0 ? (SUBSTRING(my column,1,FINDSTRING(my…
1 answer
One of the answers was accepted by the question author.
I am trying to connect with Oracle database in VS2022. When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'.Please help on this
I am trying to connect with Oracle database in VS2022 to create SSIS package. I have installed microsoft connector both 32 and 64bit.When i try to create connection it says 'There was an error trying to establish Oracle connection with database server'.…
asked 2024-08-19T05:35:11.7533333+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, 98%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Priyanka R
20
Reputation points
accepted 2024-08-19T15:29:28.5733333+00:00
Priyanka R
20
Reputation points