Best way to learn SSIS
I got a new role where we will use SSIS to migrate data from test system to production. What would be the best way to learn SSIS as I have worked with T-SQL and SSMS. It will be on premise 2019 edition.
Retrieving the COM class factory for component with CLSID {00000000-0000-0000-0000-000000000000} failed due to the following error: 80040154
I have a simple PowerShell script as below $excel = new-object -ComObject excel.application $filePath = 'filename.xlsm' $wb = $excel.workbooks.open($filePath) $excel.Run('Macro') $excel.quit() Stop-Process -Name "Excel" When I trigger the…
SSIS package fails on SSIS server with error file or assembly not found, Microsoft.Azue.Storage.Common 11.1.3
We have SSIS packages working on prem and using file destination task and target server is SQL 2014. We are migrating these to SSIS , SQL server 2016 on Azure VM. We are converting the packages to use flexible file destination to write to adls gen2…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SQL LLM App on Azure
Hello, I have a SQL LLM streamlit app deployed in Azure App Service. We give it a prompt, and the llm generates sql code. The LLM data source is Azure SQL Database. When I run this application locally (without deploying) it works fine, however after…
Visual Studio 2022 - SSIS - Faulting application name: DtsDebugHost.exe, and Faulting module name: KERNELBASE.dll
I downloaded and installed Visual Studio 2022, with extensions including SQL Server Integration Services Project 2022. We used Visual Studio 2019 before. One of the tasks from an existing SSIS package is to read the data from Oracle and write it to a…
SSIS package running fine in visual studio but when trying to run same package its failing.
Dear Team, I want to do simple copy activity using Data flow task in SSIS package, in which my source is a old database using visual fox bro and tables are saved as dbf files . I am using OLE DB connector for visual fox pro to get data from source dbf…
My Visual Studio 2022 keep crashing when I try to create new Ole DB in a SSIS project
Hi, I'm a student and trying to learn SSIS but it seems I haven't learnt anything much since when I create new Ole DB in Ole DB source toolbox, my IDE was just simply not responding. I tried to re-install the SQL Server or Ole DB Driver but it didn't…
How to connect share point location from SSIS package to read and write for Microsoft access file.
Hi, I have mdb file in share point location, So, I have to read the file as source reference and need update the same file as per SQL table in SSIS package. I want create a connection string to get the connection for that URL(http://....) Please help me…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SSIS Package errors opening file on server using newly setup PC, works fine on old PC (same config)
I just recently got my work laptop changed and made sure I have the same software installed. I use Visual Studio 2019 with Integation Services and SQL Server Management Studio. The package is very simple: the source file is a CSV file and destination is…
Integrate Tally Prime to MSSQL Server Management
I have my data stored in Tally Prime and I want to create a data flow on a daily basis into MSSQL Server Management. How am I supposed to do this?
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SQl Server Agent "Unexpected Termination" with no error details
Hi, I have built an SSIS project where one main package refers to and carries out over 30 other packages in succession. Each package does the same job - uses an excel sheet as a source to then update the same data stored in a SQL Server database…
i tired installing VS 2017 , but when i a installing i am getting an error, unable to download even if i have networkmconnection
Hi team, initially i tried opening the Vs2017 in my pc, it got an error saying that " it could not find the denvene.exe in the short cut" i looked in Microsoft help and try to find the exe file ...it also said if the issue persists uninstall…
SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services
Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…
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…
sql server 2022 setup encountered a failure while running job updateresult
Summary.txtDetail_LandingPage.txt
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Sql server agent job fail
The error message is An idle CPU condition has not been defined
How to loop through multiple Sql Server instance, database, and table/view names?
It's been a long time since I write any C# code. I'm trying to query some tables and views from different SQL Server instance, database names, and tables/views. Below is my sample code. public void Main() { // TODO: Add your code here …
SSIS Send Mail Task Fails on Out of office
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…
Unexpected termination - SSIS 2019 export to excel files
I have a SSIS 2019 project, which contains a main package and a few child packages that may export data to excel files (using Excel 2007-2010). The main package calls the child packages based on criteria. The excel files are dynamically generated though…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SSIS Error: ADO NET Source has failed to acquire the connection with the following error message: "Could not create a managed connection
Hello I am getting this error when trying to connect Dynamics CDS. [ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {6F23C652-54D5-487B-AF3D-3354FD263841} with the following error message: "Could not create a managed…