Content
SSIS : Connecting SharePoint Site through OData Source
Hi All - I am connecting to a SharePoint site and i have edited the site at end like below and at the end i have added _vti__bin/List.svc also i am able to access the sharepoint site through my account. When i selected the Odata source and passed the…
How to fix SSIS (dtexec) System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException
We have a very old SSIS package that runs fine on Windows Server 2012 R2. We are decommissioning the Windows Server 2012 R2 vm and have a Windows Server 2016 vm. The SSIS package accesses Oracle. I can see within the script portion of the dtsx…
Package source SSIS Catalog with Windows Authentication only
hi all, anyone know that SSIS Catalog source on SQL Agent Job setting give us option Log on as Windows Authentication only.. great appreciation for all answer regards, Urbel
Validate multiple columns in a csv file
Am loading a CSV file to a landing table , the problem is i have to check if some of the columns in the file are numeric or not , if they are not numeric the file should be sent to the error folder .If not they file must be processed to the landing table…
SSIS - Derived task expression help to check if numeric
hi all, my data is coming from excel to sql via ssis package. now in my excel , sometimes due to formula i am getting data like #ERROR,#DIV/O,-,N.A,n.a and etc.. Now i want to put condition that,If data is numeric then leave as it is and if it is…
SQL and SSIS : Extract part of file name in SQL / SSIS.
Hi All - I have five SSIS packages and each of these packages source is a csv file. Each packages access the shared folder path respectively and loads the data into the SQL database table. Below are the file naming conventions of the files : …
SSIS : Read flat file header and load data into table.
Hi All - I have a package the reads the csv file and loads the data into the SQL table. But in SSIS i have checked in option of 'Headerrowstoskip' =1. My table is static and below is my table structure. Earlier, the requirement was not to read the header…
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…
what is cost for deploying on ssis server to onpremises to other server
what would be the cost for deploying on ssis server to onpremises other server
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536
We have moved our SQL Database to SQL Server on Azure VM. I have already ran these USE SSISDB GO EXEC sp_changedbowner 'sa' Alter database SSISDB SET Trustworthy ON I am trying to deploy the package and create a folder but I still gettign…
Getting error while deploying SSIS packages through powershell
When we tried deployment of SSIS packages to sql server with sql login credentials instead of windows authentication through powershell, I am getting below error "The operation cannot be started by an account that uses SQL Server Authentication.…
How to load CSV file with last row in bad format
Hi everybody, I have data like this: "629","New Orleans Medical Center","70444","28113","PIKE","LA","20230630","20230701" "629","New Orleans Medical…
SSIS package targeting SS 2019 enforces 4.7 but want to change it to 4.7.1 atleast across all SSIS packages
It looks like SSIS packages targeting SS2019 enforces 4.7 .Net framework. However, I really want to enforce 4.7.1 or higher. I Can go and change at the script task level, but I guess that is not ideal if I have 40+ SSIS packages with 3 or more script…
Visual Studio SSIS project execute script task : C# version
I have a SSIS project and there is a script task inside it . but i am wonder if I can change the C# project version of it ? it always keep at framework 4.5
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…
Getting issue "Unable to fetch cdc processing range" in sql server
I am getting the below issue continuously for the job which points to SSIS package to capture and populate the changes to audit tables and lsn state variable values getting changed to TFREDO instead of TFSTART or TFEND Error -"Possible reasons:…
Reliable data provider to read SAP data inside a SSIS solution
Hi, I need to evaluate a more reliable data provider for reading SAP data in a SSIS vers. 2017 solution respect to the ODBC SAP HANA. Any suggests to me, please?
Export Column Transformation in SSIS is not working.
I use Export Column Transformation to read data in a data flow and insert the data into a file in SSIS (Visual Studio 2019). When I open Export Column Transformation Editor and there are no options, see below. Does anyone know what the issue is?
Can I use case condition in SSIS
I can use case when in tsql, is it possible to use case condition in SSIS?
Null values in package
I've created a package with SSIS, contains flatfile as source and load the data to sql server table, however it could not keep the null values, please advice.