I want to dynamically import tables from Maria db to SQL Server using a SSIS package. Let’s say table starting from common name example_table – how can we dynamically create tables in SQL Server using a SSIS package and insert the data into those respective tables in SQL Server?

enter image description here

I have the following SQL Statement in a SSIS Execute SQL Task:

I’m looping over excel files in a folder using the foreach task, reading the file (using the variable loaded by the foreach task), the first row is the header, and loading data into SQL table.

We’re trying to deploy SSIS package containing MicrosoftSSISOracleConnector-SQL22-x64 to SQL Server 2022 Enterprise edition. The error message is

We’re trying to deploy SSIS package containing MicrosoftSSISOracleConnector-SQL22-x64 to SQL Server 2022 Enterprise edition. The error message is

When I executed the SSIS package, I received the following error:

I have an SSIS custom component which was developed sometime ago, we are migrating our databases and SSIS packages to SQL Server 2022 and I am getting the following error when trying to use the custom component:

I have been trying to create two dififernt task that are supposed to create two different Global tables (need parallel creation of two Global temp table) on the same DB server using same OLE DB connection,But i can find only one of the table is getting created.

I have an SSIS package which I built in VS 2022 then deployed locally to a SQL Server 2019 instance.