integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
je suis incapable de déployer les packages ssis car je n'ai pas le catalogue ssisdb après plusieurs essais je trouve que l'origine de problème le manque de la fonctionnalité integration services j'ai essayé de modifier l'installation en ajoutant cette…
SSIS Foreach Loop with Conditional Data Flows/Flat File Connections?
I'm setting up a process to bulk insert daily flat files into a staging warehouse. The flat files are not very clean. The files for the first 40 days contains 20 column and the days after contain 22 columns. How can I set up my foreach loop to switch…
Query does not return any results
Hello, I am running the following query on SSIS on the AdventureWorks2012 database.. select c.CustomerID as CustomerAK, p.Title, p.FirstName, p.MiddleName, p.LastName, p.Suffix, em.EmailAddress from Sales.Customer c join Person.Person p…
Parallel Processing in SSIS
Dears I have the following scenario in SSIS. There are two packages, Outer.dtsx and Inner.dtsx. the Inner package is called inside the Outer package in the workflow. To increase the performance, as the workload is heavy, I added a sequence container,…
I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager.
I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager. I would like assistance with someone that is an expert in Visual Studio. Steps to recreate the problem. Open visual studio 2019. …
metadata issue
hi , i'll post the rest of the question once i see this new forum doesnt bounce me out
Delete command for Oracle table has warning : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
I have created an ssis package that processes data on sql server and loads results to an oracle table. I am using an execute sql task to delete existing records in the oracle table before reloading the table. The execute sql command has oracle…
SSIS Sequence Containers
I have a SQL Server Integration Services package that has multiple sequence containers. If one sequence container fails, does the package stop? Is there a setting so that subsequent sequence containers will run even if one sequence container fails. …
How to log Connection string in SSIS
Hi, I have a package which runs from a SQL Server and connects to dozens of other instances on the network before running various scripts. I am getting a lot of SSIS Error Code DTS_E_CANNOTAQUIRECONNECTIONFROMCONNECTIONMANAGER Is there any way to…
How to import password protected Excel file into sqlserver using ssis
Hi All, I want to import password protected excel file into SQL Server using SSIS. Please help me
SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.
Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute this package using DTExec utility. "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec" /ISSERVER…
Can I deploy to SQL Server 2014 SSIS Catalog from Visual Studio 2017?
We are testing Integration Services Catalogs with SQL Server 2014. We are trying to find a way to deploy from Visual Studio. When we try from Visual Studio 2017 Pro (with data tools) we receive the following error. ![18800-image.png][1] I'm trying…
How to map IDs in different formats from source to destination
Hi, My source data is in postgreSQL and my target data is in Common Data Service (D365). On source, I have employees with these IDs: 1 2 ... On target, the IDs are a little bit more complex. How can I map these IDs? I need to know that…
Migrate SSIS packages, projects in visual studio from 2016 to VS 2019
I am new , involved in upgrade/migration of the SSIS projects , packages created in VS 2016 to VS 2019. I have installed the free Visual Studio 2019 Community version and Integration services project. and Sql Server management studio - 2019. I have…
SSIS - Excel Macro
Hello, I have an SSIS ETL that moves excel files from a local folder and inserts the data into a SQL database. I'm running into some issues with a the excel files being in two different formats breaking the ETL mappings. I've created an excel macro…
SSIS - Send Mail Task
Hello, I created an SSIS ETL that Loops through a local folder, inserts excel file data into a SQL db, then archives the file. I'm trying to add a Send Mail Task to the process but I can't seem to get it to work. I can get the email to run but it…
Unexpected Termination - SQL Agent - excel Import
Hi experts, According my research over google, this issue has been active since 2018. Unfortunetally I haven't found the right answer. I hope somebody could help me. I have a package in SSIS which loads an Excel file data into a Table. At the…
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
I require a specific version of SSDT for my development environment due to the limitations of server software and other collaborators' environments. It has to be exactly SSDT version 14.0.60629.0 for Visual Studio 2015. I can not find a place to…
we hope Microsoft can develop databases like mysql
We would like to provide the installation version and the installation free version; MySQL only needs to read the configuration file to run without complex registry key.
SSIS Scale Out and its services on local group policies
As per MS recommendation, scale out master service and worker service accounts should be member of which local group policies ?