SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
1 answer
SQL Server SSIS package performace issue
Hello All, Using SQL Server SSIS package Trying to export MS SQL table data into oracle table it is taking 1hr for 50 lac row (Table Name - EMP, Column ID, and Name) For the same table SSIS IMPORT taking only 1 min. I need help or suggestion how…
SQL Server Integration Services
asked 2020-09-04T00:53:56.307+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(6.4, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
GUPTA, R. (Rajeev)
1
Reputation point
commented 2020-09-11T09:39:31.017+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
SSIS Source Control Azure Dev Ops Git repo help
HI All. I have recently moved an SSIS project from VSTS into an Azure DevOps git repo. The project is a simple one with a master package calling several child packages using "Execute package Task " with reference type = "Project…
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-09-08T07:36:34.57+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(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA0%3C/text%3E%3C/svg%3E)
ApplebyNick-0083
1
Reputation point
commented 2020-09-11T09:30:25.963+00:00
Monalv-MSFT
5,926
Reputation points
1 answer
SSIS OData conn parameterized
Hello, I am having some trouble parameterizing an OData connection to sharepoint. I created an SSIS package that gets a list from sharepoint. I am using an OData conn manager, the auth type is Microsoft Online Services. In VS2019 I provide 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-09-07T14:22:32.097+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, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Richardo Roias
6
Reputation points
commented 2020-09-11T09:30:00.4+00:00
Monalv-MSFT
5,926
Reputation points
1 answer
Attunity CDC for Oracle OCI_FETCH error
We have setup Oracle CDC by Attunity in a SQL server 2016 environment. From the Designer everything runs fine until an actual change happens in one of the included tables in the Oracle database at which point the operation aborts. When looking at 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-09-05T14:25:13.25+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(92.8, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Perusse, Tim PW
1
Reputation point
commented 2020-09-11T09:27:39.347+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
Problem with my OLDB source (Error with the AquireConnection )
Greeting all , while the daily refresh of my data source , i found this error in my SSIS , anyone faced such thing please ? Thanks in advance .
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-09-04T16:40:00.673+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(102.4, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rami Frikha
91
Reputation points
commented 2020-09-11T09:27:19.957+00:00
Monalv-MSFT
5,926
Reputation points
0 answers
Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL
hi I have one doubt in ssis how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL I want load data from postgres to sql server using ssis package . In ssis solution I have 50 plus dft for loading data …
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-09-10T16:25:43.647+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(92.8, 41%, 18%)' 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)
harinathu
6
Reputation points
commented 2020-09-11T03:09:19.343+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
Substring C# Issue
Hi I am working on a C# code where I have a requirement to identify the filename in SSIS Package The files which I receive are in the following formats FL_NamePart1.20200909 FL_NamePart1_NamePart2_20200909 …
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(96, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
3 answers
Finding a program similar to Crystal Reports (used by VB6)
Hi! Not really sure about all the functionality Crystal Reports brought to the table, but it seems that it was in heavy use during the 90's - I do not know that status of this tool today. I am taking over an old VB6-application using Crystal Reports,…
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,066 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-09-02T09:13:46.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(102.4, 14.000000000000002%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
Inkimar
1
Reputation point
answered 2020-09-08T17:55:53.56+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(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,771
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS CSV Loading issue
I am looking for a C# solution to use a script task in SSIS so that I can load multiple csv files to SQL Tables Now If I use a data flow task, then I have to create 1 DFT per file as each file has a different metadata ( unless there is some other…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,360 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
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
3 answers
One of the answers was accepted by the question author.
SSIS Script Task
I have a table which has the list of files in a column Column values are File1.csv, File2.csv etc. Now in SSIS I would like to retrieve the list of files from the above table and then check if each file is present in a directory. If a file is…
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 | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
2 answers
SQL Server SSIS Package - IDE
Microsoft®VisualStudio Pro Sub MSDN version is good for SQL Server SSIS Package development
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-28T17:43:45.037+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, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Pandurangan, Balavenkatesh
1
Reputation point
commented 2020-09-04T09:48:47.423+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
User Account receives primary key violation but not another user
Hi We're trying to set up a proxy user to run an SQL Server job, but there are steps in the SSIS package with are MERGE statements. The user account set up, which has sysadmin rights against the databases, receives a 'Violation of PRIMARY KEY…
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 | Transact-SQL
4,707 questions
SQL Server | Other
14,503 questions
asked 2020-08-28T00:42:41.373+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(281.6, 14.000000000000002%, 37%)' 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)
Mia
1
Reputation point
commented 2020-09-04T09:40:53.747+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
SSIS in SQL Job
Hi, I have an SSIS package with an XML file, and it works correctly, but when I use it (the SSIS package) in SQL job I got an error about the path of the XSD file. How Can I handle it in the Config file or invariable in the SSIS package? I…
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-28T13:21:45.977+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-09-04T09:29:55.433+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
Printing text query results to pdf fails
when attempting to print query results (to text) to a pdf it fails with error: Value cannot be null. Parameter name: moniker. What is the fix for 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 | Transact-SQL
4,707 questions
asked 2020-09-01T12:44:42.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(80, 60%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Buzzy Cheadle
1
Reputation point
commented 2020-09-04T09:19:21.863+00:00
Monalv-MSFT
5,926
Reputation points
1 answer
Unable to start Azure Data Factory SSIS Integration Runtime for my Managed Instance
I'm trying to deploy an Azure Data Factory SSIS Integration runtime for use with my SQL Managed Instance (on the private interface). I keep running into the same issue with this error: Failed to start the integration runtime: SSISintegrationRuntime.…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 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-08-31T11:05:08.297+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, 4%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EJR
26
Reputation points
commented 2020-09-04T08:50:22.727+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
How to check the TFS SSIS version with MSDB SSIS version ? | SSIS2014| TFS
How to check the TFS SSIS version with MSDB SSIS version ? We have all ssis 2014 packages deployed on SSIS server . Now we need to check if they SSIS packages have the same version as TFS version. Is there way to query them together to see the data…
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-18T13:57:26.513+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, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mudassar A
491
Reputation points
accepted 2020-09-04T02:12:12.747+00:00
Mudassar A
491
Reputation points
4 answers
One of the answers was accepted by the question author.
SSIS/SSAS: How to change only the table name without remap the columns, flows and dimensions?
Hi, My company asked me to change the name of some of my SQL Tables( Dimensions ). But the only way that I know to do that is delete the references to the old table and map them again and recreate the OleDBSource/OleDBDestination ( SSIS ) and recreate…
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 Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
asked 2020-09-01T13:36:21.613+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
commented 2020-09-03T19:04:56.393+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
Table replicate using SSIS
Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to 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-08-31T06:54:58.88+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(144, 68%, 23%)' 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)
Sherwin Rodrigues
1
Reputation point
commented 2020-09-03T09:56:49.397+00:00
Monalv-MSFT
5,926
Reputation points
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…
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-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
Monalv-MSFT
5,926
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…
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-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,521
Reputation points
commented 2020-08-28T09:46:43.12+00:00
Monalv-MSFT
5,926
Reputation points