SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,869 questions
3 answers
One of the answers was accepted by the question author.
Execute SSIS package containing project parameters from command prompt
Hi. How to run SSIS Packages, which contains package parameters through command prompt ?
asked 2020-10-01T14:32:07.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(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
venkatesh padmanabhan
181
Reputation points
accepted 2020-10-02T03:40:29.893+00:00
venkatesh padmanabhan
181
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS on Basic Availability Group
I have a SQL Server which is running with Standard Edition in one data center. I want to configure Always On (Basic Always On because of standard edition) for SSISDB with DR node in another data center (different subnet). Is it possible to Setup…
asked 2020-09-29T02:36:14.623+00:00
Prince Kumar Rastogi
31
Reputation points
accepted 2020-10-01T11:18:06.417+00:00
Prince Kumar Rastogi
31
Reputation points
1 answer
One of the answers was accepted by the question author.
Retrieve members of group for each server specified - Error: Network path was not found
Hi. I am using scripttask in SSIS to retrieve the members of a group from each of server. I used the below code: DirectoryEntry deComputer = new DirectoryEntry("WinNT://" + ComputerName + ",computer"); …
asked 2020-09-30T15:58:19.103+00:00
venkatesh padmanabhan
181
Reputation points
accepted 2020-10-01T04:05:29.963+00:00
venkatesh padmanabhan
181
Reputation points
2 answers
Web Service Task Error
I have a URL which is returning WSDL when i open it through browser. But when i try with web service task, it is returning me error like " The service is not available on SOAP port". Can somebody help me interpret what it means. And if…
asked 2020-08-18T05:23:47.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(19.2, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Data Learner
1
Reputation point
answered 2020-09-30T15:22:33.817+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
2 answers
One of the answers was accepted by the question author.
Merge two xml and get output xml
Hi All, I need help on merge xml files using SSIS. I have files as below. part1.xml <?xml version="1.0" encoding="utf-8"?> <RequestRoot> <header> <totalRecordCount>2</totalRecordCount> …
asked 2020-09-29T13:37:59.277+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(230.39999999999998, 59%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Papillon28
86
Reputation points
commented 2020-09-30T12:47:01.94+00:00
Papillon28
86
Reputation points
1 answer
One of the answers was accepted by the question author.
'cdc control task' cannot run on the installed version of the integration services.
Hi, I have deployed SSIS package on SQL SERVER 2019 Standard Edition(Version : 15.0.200) and package is using CDC control Flow task. Now, when I execute the package it's getting below error. ""'cdc control task' cannot run on…
asked 2020-09-30T07:37:48.617+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(179.20000000000002, 51%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sandeep Kumar
21
Reputation points
commented 2020-09-30T09:25:45.02+00:00
Sandeep Kumar
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Multicast to two different Flat File Destinations results in Error
So I have a need to output the results of a SQL Server Stored Procedure to two different Flat File Destinations and we are using a Multicast in order to try and do so. When we run the SSIS Package, we get... "The process cannot access the file…
![](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)
2 answers
WSUS Reset node error : unable to connect to the WSUS Server via the remote API. 2016 Standard Edition
I have one Master and Multiple slaves. (One connected to M$ ) Each server have dedicated SQL DB instance. Multiple slave server are able to communicate Master and sync successfully. One of the slave started giving error. The WSUS…
asked 2020-09-09T04:55:57.73+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(12.8, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dinesh Sawarkar
1
Reputation point
commented 2020-09-28T07:31:08.357+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
2 answers
SYNAPSE STUDIO- SQL POOL -(NEW)OPTIONS DISABLED
Hello Community, I have been facing error related to creation of new sql pool via synapse stuido. The (New) options is disabled over synapse studio. Please could anyone let me know why is the reason behind it. THanks, Deepak
asked 2020-09-10T12:54:54.187+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(278.4, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
demo case
1
Reputation point
commented 2020-09-28T07:28:27.253+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
SSIS: Update Version of a Custom Task
Hi there, I developed a Custom Task for usage in the Control Flow in an SSIS-Package. Everything was working fine and I used the Task in some Packages. Now I made some (none breaking) changes to the Task and updated the Version from 1.0.0.0 to 1.1.0.0.…
asked 2020-09-14T13:18:27.247+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, 95%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Marco Kroeger
1
Reputation point
commented 2020-09-28T07:12:58.247+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Create Credentials of the network shared access in SQL server to be used by SQL Agent
How to create 'Create Credentials of the network shared access in SQL server to be used by SQL Agent' Thanks
asked 2020-09-24T11:19:48.797+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(288, 41%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Praveen Channal
1
Reputation point
commented 2020-09-28T07:03:20.537+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
how to filter a multinlingual xml
Hi, I have a multi node XML file which is being used as a source to extract data into a database. I am using SSIS to achieve the same. The XML file is a multilingual XML which has values in multiple languages , for example, please see below. I want to…
asked 2020-09-21T21:17:09.627+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-09-28T06:54:38.23+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
ssis permissions
what minimal permissions are needed to deploy ssis packages to the catalog database.
asked 2020-09-21T22:17:59.34+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(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
commented 2020-09-28T06:53:59.223+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
Extracting part of string and loading
hello folks, i have a column i trying to load into destination but not sure how to do it in ssis? the data is like this below column1 : <div class="ExternalClassDB075A28F1AB44DA882ED25EFAA3FD94">Take trial testimony & attempt…
asked 2020-09-21T15:11:13.61+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(278.4, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Remo522
21
Reputation points
commented 2020-09-28T06:50:39.193+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
create a file without extension -pls help
Hi, I have a little confusing requirement. From a Source database table, I need to extract some data and create a file out of it. Sofar I have created a csv, text or excel files. But now, I need to create a fixed width file (with no extension). For…
asked 2020-09-22T12:41:40.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(96, 74%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
KubirSingh
21
Reputation points
commented 2020-09-28T06:39:44.36+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
ssis handling of oracle and teradata passwords
Hi, This has gotten so bad I have to ask if there is a newer feature in ssis (like maybe vs 2017) that handles oracle and teradata passwords. We work in a secure organization. They don't want us leaving passwords in the packages for security reasons…
asked 2020-09-22T15:30:55.107+00:00
Anonymous
commented 2020-09-28T06:38:03.277+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
SSIS Execute SQL Task error: Syntax error or access violation
Hi All, I am running below code in SSIS Execute SQL Task and Passing an input parameter to code. My connection is OLEDB connection so I am using ? but it is failing with error message: "failed with the following error: "Syntax error or…
asked 2020-09-24T07:02:42.477+00:00
Shivendoo Kumar
736
Reputation points
commented 2020-09-28T06:34:08.54+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
Protocol Error in TDS Stream SSIS when running with SQL Server Agent Job
Hi everyone, I have a SSIS package that pulls data from a source SQL server to a destination SQL server using a OLE DB provider for SQL Server Native Client 11.0. When I run the package in Visual Studio from the destination server everything works…
![](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, 17%, 14%)' 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)
2 answers
SSIS: How to go to next iteration in for each after a Error on actual Control Flow iteration?
Hi, I have a scenario where I have a Master Packet, and this Master call another 12 others .dtsx packets through 'Execute Packet Task' in sequence inside a ForEach loop. I run my Master ETL based on Customer separation...All packets for Customer1, all…
asked 2020-09-15T13:02:06.573+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(25.6, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Luis Lima
61
Reputation points
answered 2020-09-24T09:55:23.84+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
extracting .MPP files in Sharepoint using SSIS
Hello, I am trying to extract an .mpp file from a SharePoint Document folder . I'm able to use the OData Source to connect to SharePoint to see the lists but have no clue how to get to the files. Any assistance would be appreciated. Thanks …
asked 2020-09-22T21:11:06.293+00:00
Dyanna Hess-Miller
61
Reputation points
answered 2020-09-23T19:54:14.837+00:00
COZYROC
101
Reputation points