Stack Overflow
Stack Overflow

Questions tagged [ssis-2017]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2017 is a part of SQL Server 2017 Data Tools

116 questions
1
vote
0 answers

Getting SSIS Error Code DTS_E_OLEDBERROR using XML Source Transformation in SSIS 2017

I adding data from a nested XML tag to the same destination source. The data is loading but there is an error on the package. I running my SSIS package locally. I'm really just learning by myself. I used Data Conversion to match the destination…
user3505108
  • 23
  • 2
1
vote
0 answers

C# 5 ReportExecutionService

I am using Visual Studio 2017 and C# 7.3 to execute data driven SSRS 2017 report execution. Visual Studio 2017 requires using C#5 for break points to function properly. I can change to C#5, but I can I can find no documentation on C#5 and…
Steve_Malcolm
  • 53
  • 1
  • 9
1
vote
0 answers

Importing a package with SMTP Connection Manager-SSIS 2017

I am trying to import a package to SSIS 2017 .I have a SMTP connection manager in my package which is causing the issue while I import : OLE received a packet with an invalid extension. (Exception from HRESULT: 0x80010112)…
SuperKings
  • 89
  • 1
  • 9
1
vote
0 answers

In Place SQL Upgrade and SSIS

I am planning an in-place upgrade of a SQL server 2014 to 2017. We have many SSIS packages deployed to the server. Anybody know if the upgrade will convert the deployed packaged to 2017 format or will I have to re-deploy them all? I know that if I…
Davin Studer
  • 1,501
  • 3
  • 15
  • 28
1
vote
1 answer

Problems opening a dtsx file in Visual Studio 2017

When I open a dtsx file in Visual Studio Enterprise 2017 it opens them as just an XML file. I read over this stack overflow discussion but when I do a File->New Project I don't see Integration Services Project as an option. I checked the Visual…
Eric
  • 2,861
  • 6
  • 28
  • 59
1
vote
1 answer

How Do I Delete A SSIS Log Configuration in SSDT

There doesn't seem to be a way to delete certain configurations/connections in SSDT, at least not through Visual Studio. For example, when I create a text file connection for logging I don't see where to edit nor delete it later. I can only…
Trevor Reid
  • 3,310
  • 4
  • 27
  • 46
1
vote
1 answer

SSIS C# script task to open Excel causes invocation error

I have an SSIS package that has a script task, that reads from an Excel. I am getting the below errors and can't seem to find the issue. Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object…
Caveman42
  • 679
  • 2
  • 13
  • 35
1
vote
1 answer

Script Task is not working in visual-studio-2017 (SSDT)

Script task is strange, it's not working. It always says compile error or fails even when I just add some comment!
Jeff_hu
  • 417
  • 4
  • 15
1
vote
0 answers

OLAP connection manager not working with dynamic values from SSIS config file

Could anyone provide suggestion to fix on the below issue in my SSIS package. I have a SSIS package designed to process SSAS cube on automated basis.first step involved is dimension processing and second is processing cube. SSIS package works fine…
Karthi
  • 11
  • 2
1
vote
1 answer

Error previewing SharePoint list with OData source in SSIS package

In an SSIS package, I'm trying to extract data from a SharePoint list. I'm using the OData source connection manager. I put in the proper Service document location. I'm using an Authentication Type: Windows Authentication. When I hit the 'Test…
Cguy23
  • 33
  • 5
1
vote
1 answer

Error Executing SSIS package from ASP.net application

I had a requirement at client side to upgrade SQL server client from 2008 R2 to SQL server 2017. Previously I used SSIS packages build with SQL server 2008 R2, while upgrading the server I am facing connectivity issue when calling the package from…
Akilan Deivasikamani
  • 21
  • 3
1
vote
1 answer

SSIS Package issue after upgrading from 2008 to 2017

I had a requirement to upgrade SQL server client from 2008 R2 to SQL server 2017. Previously i used SSIS packages build with SQL server 2008 R2, while upgrading the server i am facing connectivity issue when calling the package from asp.net…
Akilan Deivasikamani
  • 21
  • 3
1
vote
0 answers

In SSIS toolbox I dont have ODBC destination with 'planet' like symbol

I have visual studio 2017 enterprise 15.9.5 with installed: Developer Extensions for Visual Studio 2017, Productivity power tools 2017, SSDT component. In SSIS Toolbox my ODBC destination icon is System reinstallation didn't fix this problem. All…
CEH
  • 11
  • 2
1
vote
2 answers

Get List of all failed SSIS package on a particuar date

Hi everyone is there any way we can get list of all failed packages on any particular date , can we do this with a SQL query ? We are using SSIS 2017 .
Rahul Sharma
  • 453
  • 3
  • 10
1
vote
0 answers

Not able to upgrade .Net framework version for SSIS Script tasks

I have SSDT 2017 and VS 2017 with .Net framework version 4.7.2, I have few old ssis scripts tasks written with .Net 4.5 now i need to upgrade those with .Net 4.7.2, But when i update script projects with .Net 4.7.2 then it always back reverts to…
Sonu
  • 25
  • 8
1 2 3
4
5 6 7 8