Package dependency SSIS
Hi, Developers constantly ask for changes to table structures (column name, PK, FK) in SQL Server. I need to know which packages of the SSIS project should be changed if any database table is changed There are more than 100 packages I can't do it…
Replicate a database on-premise with muiltiple server to Azure SQL
I have done a copy of my onpremise database on Azure Sql but now my problem is the onpremise database is connected to diferents database from providers, and now i want to to the same connections in my Azure Sql For example PRIMAVERA and MEXICO (the…
Median aggregation in SSIS
Hi, I have a table of that have 3 columns, column A, column B and column C. Column B can have multiple records of column A. What I need to do is to add another column that contains the median value of column C based on column B. The thing is, the…
Convert SSIS Packages to MSSQL Stored Procedures
I have been tasked to convert a SSIS package to stored procedures. The package runs in less than 60 seconds. The package builds staging files from DB2 to MSSQL and then runs the MSSQL Merge statement. Unfortunately, if I try to use an OPENQUERY to…
I'm trying to source data in a comma-delimited file from an Azure Gen2 Storage account using Flexible File Source task. The connection succeeds but Preview of data is blank.
I'm trying to pull data from ADLS Gen2 using the SSIS Flexible File Source task. I'm getting blank results when trying to view the data in the Columns tab of the dialog.
cast COM object of type error using SSIS ODBC Connection to PostgreSQL
hi I have one doubt in ssis how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL I want load data from postgres to sql server using ssis package . In ssis solution I have 50 plus dft for loading data …
Unable to reference Custom Class library in SSIS Script Component
I have a .Net Standard 2.0 Class Libary which I am unable reference in my SSIS Script Component. I am using Visual Studio 2019. The Library has the following settings. Whenever the script references the library I get an error indicating the…
finding the invalid character
In my SSIS project in Visual studio 2019, I am receiving this error. An error occurred with the following error message: "System.Xml.XmlException: ' ', hexadecimal value 0x03, is an invalid character. Line 44, position 4. I believe I have…
Truncation may occur due to inserting data
I recently changed the flat file source in the data flow task. Following that change, I am noticing below error for most of the columns and SSIS package no longer executes. Can someone please let me know what might be going wrong? Also I see these…
SSIS Package assessment Uisng Data Migration Assistant
We have successfully created a small SSIS package that extracts data from CSV and stores it in the SQL Server database. The next task is to carry out an assessment of the Integration Services using the Data Migration Assistant. I am following…
Script Task:Error: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0
Hi All, I create a SSIS C# Script task to pull data from oracle server. I'm using default "Oracle.DataAccess,.DLL" from oracle 11g 32 bit. when i run that package normally its work fine. but after deploy package in SSIS DB package not working…
Error Testing Connection from SSIS to ADLS Gen2
I'm trying to connect to ADLS Gen2 from SSIS using an Azure Storage Connection Manager using a service account & Service Principal authentication. I'm using the Key Vault client ID for the application ID and secret key for the Application key. I'm…
Fail to update an existing SSIS package
Hi, We are running SQL Server 2016. Lately, I have already updated an existing package in a SSIS Solution as the request of sorting sequence has been changed. When I run the package in Data Tools, the output Flat File is correct. Then I Deploy…
ssisdb database not there
hi all, I just installed sql server 2016 and ssis I do not see the ssisdb in the list of databases, please advice
SSIS solution edited on VS 2019 Enterprise can't be opened on VS 2019 Pro
I've had to switch from VS 2019 Enterprise to VS 2019 Pro as the Enterprise eval licence expired. (I had to install a separate instence of VS 2019 Pro). The SSIS solution and packages that worked fine on the Enterprise version won't open in the Pro…
processing encrypted files with SSIS (flat file source)
Any recommendations on how to process (file-level) encrypted data with SSIS? We'd like to avoid any un-encrypted content on disk, and instead read the encrypted data into memory (or the database,) decrypt using .NET, then proceed with transform &…
Code review checklist and Secure best practices for SQL, SSIS
HI. Is there a document for : Code review checklist for SQL, SSIS and Secure best practices for SQL, SSIS ? Could anyone please point to these ? Thanks
How to know what row crashed my SSIS DataFlow -> ScriptComponent?
Hi, I am with a problem that my C# script componente is crashing with the message: "The column has a null value" But I am executing a data flow over a table with more tem 100.000 rows and more than 60 columns. This simple message is…
SQL Server SSIS package performace issue
Hello All, Using SQL Server SSIS package Trying to export MS SQL table data into oracle table it is taking 1hr for 50 lac row (Table Name - EMP, Column ID, and Name) For the same table SSIS IMPORT taking only 1 min. I need help or suggestion how…
SSIS Source Control Azure Dev Ops Git repo help
HI All. I have recently moved an SSIS project from VSTS into an Azure DevOps git repo. The project is a simple one with a master package calling several child packages using "Execute package Task " with reference type = "Project…