Powershell from SSIS - Empty environment variable
I'm running a script in an SSIS package and I specify an account to run the package in SQL Server Agent. When it runs, I am unable to get the value of $ENV:LOCALAPPDATA Here's my code along with writing out the LOCALAPPDATA value Start-Transcript…
Excel数据导入的问题
我在尝试把excel表格的数据导入到sql的表里,有什么办法可以把前100行导入到A表,101-200行的数据导入到B表这样一次性完成吗
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
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …
Cannot install SSIS, no Visual Instance Studio found
I have Visual Studio 2022, Visual Studio 2017, SSMS 19 installed on my machine, but when I go to install SSIS no instance of VS is found.
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 :…
How to add a folder or root node in SSIS Toolbox?
I want to add a folder or root node in SSIS Toolbox just like the following image, is this possible?
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.
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…
why ssms 20.1 Cannot Open ?
Why my ssms 20.1 that was downloaded on 04/14/24, always run the same popup page message as in the attatchment ? if i choose repaired and wait it finishes and then reboot the computer, the same popup message pops again. Even that I have uninstall the…
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…
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…
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…
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…
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…