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
0
votes
0 answers

Read Excel sheet into data table using ssis script task date column returns null

I am using ssis script task to load excel sheet into a data table. i am using below code to read the sheet. Here an InvoiceDate column cells formatted as Date(dd/mm/yyyy) in excel all the columns(30/04/2020) read correctly but invoicedate one cell…
Saravanan Ponnusamy
  • 3
  • 2
0
votes
1 answer

SSIS: script task version 15.0 script that is not supported when deployed in active batch

Error: Description: There was an exception while loading Script Task from XML: System.Exception: The Script Task "ST_b7d198f240cd42ed864706faee2f4f58" uses version 15.0 script that is not supported in this release of Integration Services. To run…
swathi
  • 91
  • 1
  • 9
0
votes
1 answer

Import Excel records in SQL Server 2016 via VS2017 SSIS / Error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Good day ! OK so I've made researches to find a solution to my problem, and tried everything and still... I have to upload records from Excel to SQL Server. First I created a SQL Connection Manager, with the dynamic variable @[User::FilePath] as an…
MChalut
  • 57
  • 6
0
votes
1 answer

SSIS/SSRS -- I am getting this error, when I am creating a new project for SSIS in VS 2017

New to Reporting Services, I am getting this error when creating a new project
bensonissac
  • 635
  • 5
  • 10
0
votes
0 answers

SSIS Error - Parsing Query from SQL Task Fails Due to 80040153, Invalid Value for Registry

Problem Statement I have a lot of SQL Server environments locally. When trying to parse a SQL task with very basic truncate table dbo.table syntax, I get the following error message. I should note that when I execute the task it works fine despite…
Ray's Web Presence
  • 464
  • 1
  • 5
  • 15
0
votes
1 answer

SSIS Error Importing XLS File - External table is not in the expected format

I'm trying to open the following XLS file in SSIS: https://drive.google.com/file/d/1E_fNSlRTMuoYnH7VERFB8hXbcxssKSGr/view?usp=sharing I can open it in Excel, without any error or warning from Excel. But When I try to open it in SSIS or even In…
Cristian Avendaño
  • 427
  • 3
  • 17
0
votes
1 answer

SqlServer 2017 SSIS - SSISDB & MSDB Understanding

I'm new about SSIS. First of all, Installed SqlServer-2017 Installed SSMS version 17 Installed SSDT standalone (this was hard) Installed SSIS After all installations done. There are two components for SSIS; SSIS via login via SSMS (server…
rkapukaya
  • 77
  • 1
  • 8
0
votes
1 answer

SSIS is rounding off the decimal value when reading from the flat file

I have a flat file with the below value: AI9983|01|20170802|119965.57|0.000000|0.000000||| AI9983|01|20170803|119713.62|-0.210019|-0.210019||| I read the file, the value 119965.57 gets stored as 119965.60 the value 119713.62 gets stored as…
Praveen.e
  • 1
0
votes
0 answers

Determine comma or dot as decimal seperator in Visual Studio (SSIS Tools)

In my SSIS project I'm running a calculation. This calculation changes the decimal seperator according to the users regional settings. My question is if there's anyway to override this so I can select that this project or this package is supposed to…
Jacob
  • 45
  • 5
0
votes
1 answer

How can I detect if there is any file in a folder using SSIS?

I receive every day a file with a specific pattern and extension, which I want to run under certain process. I want to check if there is any file in my folder, because otherwise I will do another task. So far I found that you can use a Script Task…
Christian Villanueva
  • 5
  • 2
0
votes
0 answers

SSIS filter ADO .NET source query based on results from another query

A newbie to SSIS here, so if you are able to help.. please add as much detail to your answer as possible :) My goal is to be able to parameterise my ado.net source based of values already in a table in my destination DB. I've managed to test the…
OluwaT
  • 13
  • 4
0
votes
1 answer

Load data into multiple excel sheets depending on conditions dynamically

I have a situation please help me out. I have to create multiple sheet in one excel file with different queries. Like i have to check if the particular column is null then the record against this query should be in excel file in new sheet and i have…
ETL - BI
  • 59
  • 9
0
votes
1 answer

SSIS sysssislog table - Is Starttime or EndTime logged as UTC?

The documentation doesn't say much other than starttime datetime The time the package began to run. Does this log as UTC ?
Geezer
  • 513
  • 5
  • 17
0
votes
0 answers

What is needed to call SQL Server Stored Procedure from Salesforce?

I've been asked to execute/call Stored Procedure from Salesforce. I'm using SQL Server 2017 Enterprise. What do I need to execute/call a SQL Server stored procedures from Salesforce?
AjFmO
  • 395
  • 2
  • 4
  • 18
0
votes
0 answers

How to Execute flat file source by ssis catalog

I have a ssis pacakage which was in designed in 2008 and i have upgraded it to 2017 having flat file source. I want to execute via ssis catalog (SSMS). How to add file name in ssis catalog?
Sneha Yadav
  • 21
  • 3
1 2 3 4 5 6
7
8