SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
2 answers
One of the answers was accepted by the question author.
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…
asked 2020-08-24T22:55:22.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
accepted 2020-08-25T14:22:40.233+00:00
Anonymous
2 answers
One of the answers was accepted by the question author.
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. …
asked 2020-08-21T15:50:11.927+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Michael Henderson
111
Reputation points
accepted 2020-08-24T14:01:18.757+00:00
Michael Henderson
111
Reputation points
2 answers
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…
asked 2020-08-18T09:15:19.207+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZO%3C/text%3E%3C/svg%3E)
zoe Ohara
286
Reputation points
commented 2020-08-24T08:51:23.703+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
4 answers
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
asked 2020-08-19T07:36:18.593+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
vaishu
1
Reputation point
commented 2020-08-24T08:44:21.667+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
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…
asked 2020-08-17T16:26:02.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sarang Deshpande
1
Reputation point
commented 2020-08-24T07:50:34.407+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
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…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,614 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
asked 2020-08-19T19:42:28.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alhowarthWF
296
Reputation points
commented 2020-08-24T07:16:06.173+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
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…
asked 2020-08-20T14:11:24.923+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ana Alves
1
Reputation point
answered 2020-08-21T10:35:06.083+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,606
Reputation points
1 answer
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…
asked 2020-08-21T02:30:26.403+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 57.99999999999999%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vijay Rao
1
Reputation point
answered 2020-08-21T09:15:27.66+00:00
Cris Zhan-MSFT
6,606
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
asked 2020-08-18T13:46:27.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Mullady
221
Reputation points
accepted 2020-08-19T15:20:14.327+00:00
Tim Mullady
221
Reputation points
2 answers
One of the answers was accepted by the question author.
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…
asked 2020-08-17T14:35:07.65+00:00
Tim Mullady
221
Reputation points
accepted 2020-08-18T17:58:15.073+00:00
Tim Mullady
221
Reputation points
3 answers
One of the answers was accepted by the question author.
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…
asked 2020-08-18T07:01:13.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alejandro Lopez
21
Reputation points
answered 2020-08-18T14:40:38.573+00:00
Alejandro Lopez
21
Reputation points
4 answers
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…
asked 2020-08-07T19:50:07.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JMac
1
Reputation point
answered 2020-08-14T03:14:20.227+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
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.
asked 2020-08-08T09:49:09.703+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 19%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
kim wu
1
Reputation point
answered 2020-08-10T02:01:53.493+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
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 ?
asked 2020-08-04T18:26:45.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 3%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Damodhar
1
Reputation point
answered 2020-08-05T01:37:44.487+00:00
Monalv-MSFT
5,896
Reputation points