Has anyone resolved the "Database Engine recovery handle failed" and "firewall warrnig" error during SQL Server installation on Windows 11?
I am encountering critical issues with installing both SQL Server 2017 or SQL Server 2022 on my Windows 11 Home (x64) machine. Below is a summary of the problems and the steps I have taken to resolve them: Issue Summary: Warning: Firewall warning…
SQL Server Integration Services and Azure Data Lake Store Connection Manager
Is it possible a SQL Server Integration Services (SSIS) package can use the Azure Data Lake Store Connection Manager to connect to an Azure Data Lake Storage Gen2 ?? From what I read the article below refers only for Gen 1 but and about the Gen 2? Link…
How to fix sql server agent job failure while extracting data from a excel file and storing in a sql db using a ssis .dtsx package?
I am getting following error when running ssis .dtsx package from sql server agent job. This package is extracting data from a excel file and storing in a sql DB. please find following error: The step did not generate any output. The return value was…
Azure Blob Download Task error
Greetings!!! I am using the Azure Blob Download task to copy files from Azure Data Lake Storage Gen2 on to a local directory on-premise. But, when I do this I run into error. Error Message: [Azure Blob Download Task] Error: Download task has stopped with…
I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.
I got an error that I cannot connect to SQL while demoing olap. I cannot connect to SQL and it asks me to enter "user id" and "password"
Access is denied while connecting SSIS
Hello, While trying to connect SSIS 2019, I am getting below error.. Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied." By default, only administrators have…
Number of query values and destination fields are not the same
Hi All, I received the TXT files from my vendor every morning. My objective is to convert this TXT file into Excel (.xlsx) file for my internal customer. I would appreciate it if you can point me in the right direction to resolve the issue. Thank you; I…
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 …
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
How to develop a package for creating a table, loading data from source document and drop table again?
Hi all, Hope you are doing well. Data getting from Source docs regularly. First need to create table Load the data from Flat File Source Drop the Table Finally.... Can anyone tell how to design the SSIS package with above logic?
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…
how do i know if microsoft ODBC Driver 13 for SQL Server is running TLS 1.2 or higher
how do i know if microsoft ODBC Driver 13 for SQL Server is running TLS 1.2 or higher
ssis package upgrade fail
I am trying to upgrade my SSIS packages from sql 2016 to 2019. The steps I did is opened the project in Visual Studio 2022, and then set the targetversion to 2019. And then Upgrade all the packages. It completed without any errors. But when I open one of…
Is It Possible To Call HTTPClient From SSIS Script Task?
Hi, I have the following code in my SSIS script task: However, if I put a break point on the client.SendAsysnc, the code goes right by it. Then if I take out the break point and do a break point after execution, the SSIS project just stops running. …
How to Use a Dynamic Connection String During SSIS Package Validation in Visual Studio 2017 Package Deployment Model?
Is there any event handler or task that can dynamically change the connection during the validation phase of a package when executed through the Execute Package utility? I have two variables in my configuration file, DriverName1 and DriverName2. I want…
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
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…