Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
345 questions
2 answers
One of the answers was accepted by the question author.
How to optimize Azure Data FactoryPipeline?
Hi All, Need help on the below requirement... I have to perform ADF migration from 90(source and target Azure MI databases) For Example Source on-prem servers(data server1, data server2, data server3,...data server90) to Target Azure MI Servers(Azure MI…
Azure Database Migration service
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
930 questions
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-11-30T19:07:13.233+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-12-01T15:18:15.527+00:00
Anonymous
2 answers
One of the answers was accepted by the question author.
Derived types are not allowed to be declared in source Xml documents
I'm trying to import XML files into SQL Server 2019, I'm building an Integration Service Package with Visual Studio 2019. When I try to import the file I receive this error: he XML Source PDO was unable to process the XML data. Derived types are 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-27T16:51:21.137+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, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Andrea Caldarone
66
Reputation points
accepted 2020-11-30T15:04:51.777+00:00
Andrea Caldarone
66
Reputation points
5 answers
One of the answers was accepted by the question author.
Best approach for a incremental loading when the source and dest tables are on two different servers
Hello Experts, I need your thoughts on this please.. So I have a source table on Server A and the dest table on server B. There are about more ~2 millions rows in source table. I will be using SSIS package. I have been requested to load 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
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,504 questions
asked 2020-11-26T21:33:10.877+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(35.2, 64%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
jennifer zen
341
Reputation points
accepted 2020-11-29T00:23:15.877+00:00
jennifer zen
341
Reputation points
2 answers
XML files loading through SSIS
Hi All, I have single xml file have multiple nodes. How can I load all the nodes information into single table. Thanks, CMK
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-22T00:23: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(201.6, 91%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
cmk
21
Reputation points
commented 2020-11-27T09:47:59.03+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
2 answers
db_send_dbmail did not recognize parameter in SSIS
Hi all, I'm executing sp_send_dbmail in Execute SQL Task in SSIS. EXEC msdb.dbo.sp_send_dbmail @Anonymous _name = 'DBMail', @recipient = 'my email', @Anonymous = 'Test'; @Anonymous = 'Select * from testtable where…
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-23T20:25:13.537+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, 42%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
M Pham
41
Reputation points
commented 2020-11-27T09:43:16.403+00:00
Monalv-MSFT
5,926
Reputation points
3 answers
Error when targeting SQL Server 2017 after upgrading SSIS using Attunity for Oracle to VS 2019 , SSIS 3.10 using MS Connector for Oracle
The issue is related to the one I have asked before and logged under : https://learn.microsoft.com/en-us/answers/questions/170084/error-after-upgrading-ssis-using-attunity-for-orac.html Visual Studio 2019 Version 16.7.4 SSIS extension : 3.10 …
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-24T15:19:13.8+00:00
Anonymous
commented 2020-11-27T09:15:11.63+00:00
Monalv-MSFT
5,926
Reputation points
6 answers
sql server 2016 migrate ssis packages including environments deployed to catalog
I have ssis packages deployed to ssis catalog. I need to move the projects along with the environemnts to new server sql 2016 can anyone please guide how to accomplish this thanks
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-04T06:16:30.757+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
answered 2020-11-27T09:02:19.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(313.6, 28.999999999999996%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kunal Rathi
6
Reputation points
1 answer
load files into sql server
Hello, I come from the ssis background where I am able to load .csv files one at a time into sql server... Can you please point me to video or a step by step lab/documentation where it sows me how to load .csv files one at a time in a loop into say…
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
SQL Server | Other
14,504 questions
asked 2020-11-24T08:32:10.813+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, 97%, 35%)' 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)
arkiboys
9,706
Reputation points
commented 2020-11-26T09:41:55.563+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
Attunity TeraData Source & Destination components not showing up in SSIS Data flow task
Hi All, I am trying to install SQL Server 2014: Microsoft Connector Version 3.0 for Teradata by Attunity to take advantage of ssis Data flow Teradata Source component but unfortunately component is not showing up. Please let me know if have done any…
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-23T21:45:52.693+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(307.2, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gopinath Desai
46
Reputation points
commented 2020-11-26T09:39:16.127+00:00
Monalv-MSFT
5,926
Reputation points
4 answers
Error 0xC0014009 for a SSIS 2017 package to import data from a SAP HANA 64-bit OBDC source
I'm trying to a SSIS 2017 package that connects a SAP HANA OBDC source. In the dev machine having Visual Studio and the 32-bit ODBC driver, the package functions without any problems inside VS. In the prod machine having a system DSN with 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-11-17T08:16:09.22+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(115.19999999999999, 41%, 21%)' 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)
pmscorca
1,052
Reputation points
answered 2020-11-26T08:19:57.057+00:00
Monalv-MSFT
5,926
Reputation points
1 answer
SSIS 2016 Reading Sharepoint 2013 Lists
Hi I am creating an SSIS package in VS2019 community edition using TargetServerVersion 2016 (if that matters). I have an OData connection going to a 2013 version of SharePoint. This works successfully when connection. I then use an Odata source…
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-23T17:01:26.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(144, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sam Garth
26
Reputation points Microsoft Employee
commented 2020-11-26T03:26:53.337+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
SSDTSetup.exe Error message. SQL
Good evening. I am having this error message when install this program. Could somebody give an opinion about this ? I've tried to install with authorization mode and tried to delete temps in temps folder as well. Thank…
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
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
SQL Server | Other
14,504 questions
asked 2020-11-10T19:12:54.113+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(48, 40%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
MICHELE YU
111
Reputation points
accepted 2020-11-25T07:21:45.587+00:00
MICHELE YU
111
Reputation points
1 answer
One of the answers was accepted by the question author.
Error after upgrading SSIS using Attunity for Oracle to VS 2019 , SSIS 3.10 using MS Connector for Oracle
I have upgraded a SSIS solution from Visual Studio 2013 using Attunity component for Oracle to : Visual Studio 2019 Version 16.7.4 SSIS extension : 3.10 Targeted server version for Deployment : 2019 . ( I have also tried 2017 and have installed…
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-20T14:41:56.19+00:00
Anonymous
commented 2020-11-20T16:38:05.203+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
4 answers
One of the answers was accepted by the question author.
WITH RESULT SETS NONE prior to SQL Server 2012
I am running the following SQL statement through an SSIS foreach loop that reads in server names to return registry information, but it is failing on 'WITH RESULT SETS NONE' for SQL Server versions older than 2012. The error is not unexpected, but…
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
![](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, 95%, 37%)' 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
One of the answers was accepted by the question author.
How to parse 3 rows in a file to a 1 row in a table with 3 columns
I have a log file with these 3 rows: FILENAME Test.log ROW COUNT =10 CREATE DATE =20201119 How can I insert these 3 rows into a log table with these columns: FileName, Count, CreateDate using SSIS? thanks
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
4 answers
One of the answers was accepted by the question author.
Question about SQL Server Manager Studio 2017
Hello, i don't know if you have some french people in your staff, so i'll write my question in the both langage (french and english) I would like to copy and insert a table (ItemResource) from a database (Arcadia_test), to another database (Arcadia). …
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(12.8, 80%, 11%)' 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
How do I change the default server / instance name when using SQL Server Native Client 11 in the Import and Export Wizard?
I have 3 SQL Server instances on my PC (SQL2012, SQL2014 & SQL2016). The services for 12 & 14 are disabled. Currently, when I use the Import and Export Wizard, I want it to connect to an instance on a network server (STX-DEVSQL\SQL2017). 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-11-03T19:29:40.683+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, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Michael Ballard
1
Reputation point
commented 2020-11-20T09:23:50.307+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
SSIS execution log show errors at different row
I have a job that import from a csv file to SQl server table. It failed today with error, the log shows it failed at row 5033 for columnX, conversion error. But if I go to the row, I don't see there is anything wrong with it. the columnX is OK…
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-19T01:46:18.777+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(147.20000000000002, 18%, 24%)' 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)
Anne
281
Reputation points
commented 2020-11-20T08:35:11.16+00:00
Monalv-MSFT
5,926
Reputation points
2 answers
One of the answers was accepted by the question author.
Archiving Large Volume Data With SSIS
SQL Server 2019, VS 2019. Essentially, I have an SSIS package that is taking from a DB source and going through every single table and archiving it into a DB destination that is essentially a carbon copy but for archiving purposes. So far everything…
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-11-18T19:17:36.883+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(134.4, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Anthony Benito
21
Reputation points
commented 2020-11-20T07:21:59.223+00:00
Anthony Benito
21
Reputation points
2 answers
Analysis server execute ddl task is not working
Hi, We have migrated to 2017 sql server. The SSIS package that is working fine in 2012 is throwing the below error in 2017 at Analysis server execute ddl task. "Could not create a managed connection manager" We have the below softwares…
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-11-18T11:16:04.937+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, 59%, 13%)' 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)
Anusha
1
Reputation point
commented 2020-11-20T06:23:59.427+00:00
Monalv-MSFT
5,926
Reputation points