SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
1 answer
How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project
I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…
asked 2020-08-28T14:58:55.027+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(208, 68%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gustavo Branco Goncalves
1
Reputation point
commented 2020-09-02T09:51:05.557+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
5 answers
pkg goes down because a connection cant be found
hi we run 2014 standard and develop in vs 2013. i deployed a pkg that has no connector called xxxxxxxx.yyyyyyyyyyy but i get the error the connction xxxxxxxx.yyyyyyyyyyy is not found...oxc001000e...this error is thrown by connections collection when…
asked 2020-08-26T22:22:34.637+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' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,516
Reputation points
commented 2020-08-28T09:46:43.12+00:00
Monalv-MSFT
5,896
Reputation points
4 answers
dynamic configuration ssdt
HI, i need to know if w can change provider and server name without opening and manually changing in package. i have server name in parameter but not provider (sql client 11.1) i want to change this in 100 package , without opening it , or doing it…
asked 2020-08-25T16:28:55.843+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, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
coool sweet
61
Reputation points
commented 2020-08-28T07:06:23.887+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
Loading files ( CSV different structures) using SSIS
Hi, I have 5 different files with different columns and I would like to load them into SQL tables via SSIS. I have the option of writing 5 dataflow tasks. however is it possible to load them dynamically with just 1 dataflowtask
asked 2020-08-25T04:38:04.257+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(22.400000000000002, 44%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mav
81
Reputation points
commented 2020-08-28T06:43:57.283+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
BCp command failing with error TCP Provider: An existing connection was forcibly closed by the remote host.
Hi, I am running a bcp command using execute process task via SSIS package.The command copies data from sql table into a flat file. The table has around 100 million records. The SSIS package ran successfully for about 2 weeks and then started failing…
asked 2020-08-24T12:52:43.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(176, 94%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jahnavi Sriram
1
Reputation point
commented 2020-08-28T06:43:18.113+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
sql Server agent STATUS Failed. The SSIS package executed successfully
Hello , I am bumping into a strange problem. My SQL Agent job reported failure ( Pic. 1), while the step SSIS Package reported success ( Pic. 2 ) and the package did not show any error message in the log. Any idea how to find out/troubleshooting …
asked 2020-08-21T17:24:17.747+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(3.2, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
B B
1
Reputation point
commented 2020-08-28T06:42:16.45+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SSIS with Attunity Oracle Change Data Capture - future with SQL Server 2019?
We use SSIS with Attunity Replicate with SQL Server 2016 for Oracle CDC and are planning an upgrade to SQL Server 2019. Attunity Replicate was acquired by Qlik in 2019 and the product rebranded Qlik Replicate. …
asked 2020-08-17T11:56:12.497+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(156.8, 66%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
grz
1
Reputation point
commented 2020-08-28T06:35:09.397+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SSIS and determining Day-Of-Week and branching if "Monday"
I want to evaluate the Day-Of-The-Week and then branch to an Execute SQL Task that will derive my @GloabalStartDate and GlobalEndDate Variables to set Friday thru Sunday if the Day-Of-The-Week is determined to be "Monday". Can someone share…
asked 2020-08-17T18:41:37.687+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
221
Reputation points
commented 2020-08-28T06:34:16.437+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
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…
asked 2020-08-11T12:45:34.333+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, 39%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
emna khiari
1
Reputation point
commented 2020-08-28T06:32:28.77+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
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…
asked 2020-08-27T14:46:12.453+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(185.6, 91%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Robert Ong
1
Reputation point
answered 2020-08-28T03:24:47.317+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
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…
asked 2020-08-27T16:18:44.39+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(54.400000000000006, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Edgar Toia Neto
1
Reputation point
answered 2020-08-28T02:50:19.957+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
One of the answers was accepted by the question author.
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,…
asked 2020-08-26T13:24:30.52+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(153.6, 12%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKE%3C/text%3E%3C/svg%3E)
Khidir Elsanosi
21
Reputation points
accepted 2020-08-26T19:27:47.057+00:00
Khidir Elsanosi
21
Reputation points
2 answers
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. …
asked 2020-08-25T21:35:57.49+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(220.8, 60%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Philip Lamphear
1
Reputation point
answered 2020-08-26T08:19:21.553+00:00
Monalv-MSFT
5,896
Reputation points
7 answers
One of the answers was accepted by the question author.
metadata issue
hi , i'll post the rest of the question once i see this new forum doesnt bounce me out
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
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,850 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 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
301
Reputation points
commented 2020-08-24T07:16:06.173+00:00
Monalv-MSFT
5,896
Reputation points