SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
9 answers
running an msdb based pkg conditionally from sql agent
hi we run 2014 std. and develop in vs 2013. our pkgs are still in msdb, not the catalog. i need to set up a sql agent job that runs a package every 5 minutes conditionally. The condition is based on the results of a query. I dont know if/how…
SQL Server Integration Services
SQL Server | Other
14,502 questions
![](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)
![](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(140.8, 31%, 23%)' 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)
4 answers
SSIS package getting error with excel connection manager
64 bit OLEDB .16.0 was installed on server. I was trying to create excel connection manager in SSDT 2017 project with Run64Mode true. Error The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 32-bit driver is not…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-11-02T21:03:06.07+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, 36%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Satya
1
Reputation point
commented 2020-11-06T16:16:26.897+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,586
Reputation points
1 answer
One of the answers was accepted by the question author.
SSIS Expression
Hi, I'm looking for help on SSIS expression. I am passing month and year values to sql query expression. "WHERE extract(year from INSERTDT) = @[User::BatchYear] and extract(month from INSERTDT) = @[User::BatchMonth] and TO_CHAR(jdate,…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
![](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(166.4, 22%, 26%)' 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)
1 answer
SSIS Custom Control UOW (Unit of work) to maintain the transaction
Hello, Currently we are working on SSIS and working on specific case where we need to implement the unit of work design for our custom created controls. The purpose of UOW (unit of work) is to maintain the transaction at root level and controlling the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-30T14:30:24.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(121.6, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sohil
1
Reputation point
commented 2020-11-06T10:01:55.63+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,926
Reputation points
1 answer
How to pass unicode parameters in pacakge level parameter in ssis using sql agent job?
How to pass unicode parameters in package level parameter in ssis using sql agent job? I have swedish character string to be passed in parameter in sql agent job which is mapped to package level parameter in ssis let me know way to pass the same.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-11-02T14:29:48.053+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
commented 2020-11-06T08:25:34.307+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
Cannot uninstall SSIS through control panel
As titled, I cannot uninstall the Microsoft SQL Server Integration Services Project (SSIS) in the control panel. Btw, I have removed all SQL Server & Visual Studio components in this computer, but the SSIS still remains and cannot be uninstalled. …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-11-02T13:04:50.89+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, 83%, 27%)' 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)
Patrick
1
Reputation point
commented 2020-11-06T08:22:56.18+00:00
Monalv-MSFT
5,926
Reputation points
3 answers
Visual Studio 2010 installation error
Hello Everyone - I installed Visual Studio 2010, visual studio SP1 , SQL server data tools (SSDT) 2012, and SQL server 2012 instance. But whenever i open SSIS packages (dtsx file) through Visual studio 2010 i get the below error. How do i resolve this ?…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Developer technologies | Visual Studio | Setup
1,212 questions
Developer technologies | Visual Studio | Other
5,461 questions
asked 2020-10-28T13:22:09.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(284.8, 36%, 37%)' 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)
kkran
831
Reputation points
commented 2020-11-06T08:11:40.137+00:00
Monalv-MSFT
5,926
Reputation points
1 answer
Recommendation on merging columns
Hi, Please could you help me in figuring out how to achieve my task efficiently. Two Flat files, with the exact same columns. Next i have a derived column for each source to create a new column. The value will be "Associate" for the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-29T04:45:45.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(284.8, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
sam nick
366
Reputation points
commented 2020-11-06T08:00:49.483+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
Accessing Sensitive Information in SSIS
I have username and password as package parameters [$Package::user] and [$Package::Pass], which I set the sensitivity property to true (Sensitive=True). These parameters are then used inside a script task (C#) to authenticate a rest call using httpClient…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-29T16:02:12.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(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
commented 2020-11-06T07:58:11.043+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
For each loop container for multiple sources and multiple destinations?
Hello, I have around 50 different .csv files that I need to take off some of the columns and export them in excel format, I was thinking about using for each loop container and I know how to make it loop through the files but now I'm stuck on how to…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
![](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, 27%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
ADF 2011 Pipeline Error
I'm trying to run an SSIS package in ADF via the Execute SSIS Package activity. We are using the SSIS-IR setup with a self-hosted proxy using a self hosted IR and Azure Files. The self hosted IR is able to run normal ADF pipelines. Whenever I try to run…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,363 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,672 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
![](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(307.2, 0%, 39%)' 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)
2 answers
One of the answers was accepted by the question author.
Unknown error when trying to log in to register the on-premises gateway, after successful installation.
Network request returned unexpected error. Response status code does not indicate success: 404 (Not Found) Request Id: a0eae803-f2e4-4858-bbb5-c5d2ede166ce Timestamp: 11/4/2020 5:56:05 PM +00:00 ErrorCode: UnknownError at…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
![](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(252.8, 10%, 34%)' 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
One of the answers was accepted by the question author.
Getting errors when running SQL Job that executes .DTSX packages
Hello, I am running SQL Server 2014. I created three .DTSX packages that all run great when I run them on their own. Each package connects to an Excel file to import data to a SQL table. I created a SQL Job that has three steps to run each .DTSX…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
![](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(121.6, 0%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
3 answers
SSIS 2017 and Salesforce Marketing toolkit from Kingswaysoft
There are couple of child packages which perform data sync from different SFMC Data Extension to Sql Server tables. Feedback of the Data Extension is asynchronous (i.e. download the record from SFMC DE and write back the marker/indicator field to…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-27T10:44:46.253+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, 91%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Subhadip Roy
31
Reputation points
commented 2020-11-04T06:46:54.197+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
How create XML as UTF-8 without BOM using XSLT with SSIS XML task tool?
Hi All, I have edited the XML with UTF-8 without BOM using XML task XSLT operation. The generated output is having BOM. I want to generate without BOM. Here is my XSLT…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-29T16:48:55.087+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(316.8, 72%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pavithra Subramanian
121
Reputation points
commented 2020-11-02T16:30:57.757+00:00
Pavithra Subramanian
121
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS package with Flatfile output
Hello, I created a new SSIS package in Visual Studio 2019 to execute an SQL and write the results to a text file. it is working fine when executing the package in Visual studio 2019 but when deployed in SQL server 2016 it is failing with the below…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
14,502 questions
asked 2020-10-02T19:57:47.33+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, 55.00000000000001%, 20%)' 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)
Srinivas K
21
Reputation points
commented 2020-11-02T15:06:16.3+00:00
Srinivas K
21
Reputation points
11 answers
SSIS export to Excel, Sheet is empty but logging says "Excel-Ziel" wrote 127032 rows, no Errors, just 1 Warning
I create the SSIS-Packet on Visual Studio 2019 and it runs on a SQL Server 2016 (13.0.5622.0). The Export runs with the 64-bit-Version. No Errors, just one warning: Warnung: 0x80049304 bei Data Flow, SSIS.Pipeline: Warning: Could not open global…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-08-26T09:24:52.907+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(192, 85%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES8%3C/text%3E%3C/svg%3E)
SabineWo-8318
116
Reputation points
answered 2020-11-02T07:41:39.83+00:00
SabineWo-8318
116
Reputation points
1 answer
Localhost troubleshoot
I have a sql server 2012 clinicengine working offline It responds very slowly on entering data ;it takes too long transferring data to localhost how can i solve this problem ?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,363 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-27T21:38:15.653+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, 20%, 14%)' 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)
menna hany
1
Reputation point
commented 2020-10-30T09:47:55.08+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
SQL Server for Education Purpose
I have 60 students and as it is Covid season, we are having the classes in online mode. I am supposed to teach them SSIS and SSRS as one of the topics in database technology. Instead of installing sql server in all of the student's computers, can I setup…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,067 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-27T14:02:23.217+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(32, 90%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
thomas thomas
1
Reputation point
commented 2020-10-30T09:45:32.07+00:00
Monalv-MSFT
5,926
Reputation points
3 answers
(SQL Data Tools 2015) When creating a report, how can I merge few columns for rows that have same data? (Picture included)
Hello, below screenshots show how initial data are gathered, what i have so far, and what I intend to accomplish. In second table ("What I updated to so far..." one), Initial Comments and Final Comments are merged and concatenated properly…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,067 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2020-10-09T22:16:51.44+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, 75%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
helloworldfromed
51
Reputation points
commented 2020-10-30T09:40:42.533+00:00
Joyzhao-MSFT
15,636
Reputation points