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 …
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
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?
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
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…
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),…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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 : …
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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?
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
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…
![](https://techprofile.blob.core.windows.net/images/KJtSuKBytE--1kwc1cjb_g.png?8DCAD9)
![](https://techprofile.blob.core.windows.net/images/KJtSuKBytE--1kwc1cjb_g.png?8DCAD9)
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
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.…
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…
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,…
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
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…
![](https://techprofile.blob.core.windows.net/images/UmgyEhxoZkyXrsqvW7bmPg.png?8DC744)
![](https://techprofile.blob.core.windows.net/images/UmgyEhxoZkyXrsqvW7bmPg.png?8DC744)
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…
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'.…