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
Questions tagged [ssis-2017]
116 questions
2
votes
0 answers
SSIS add user path to project parameters in Visual Studio DEV configuration
I am using Azure Devops in my project which means my SSIS project is stored in a file location that looks like this: C:\Users\johan\source\repos\Data Warehouse\Scripts. We are using the Project Deployment model.
In Visual Studio configuration…
analyzethat
- 191
- 1
- 16
2
votes
2 answers
USE SSIS package parameter inside script task
I have a script task inside a SSIS package, like this,
public ReadListItemsSPOnline(string siteUrl, string email, string password, int requestTimeout)
{
_clientContext = new ClientContext(siteUrl);
var securePassword…
Vlogs Bengali
- 85
- 1
- 13
2
votes
0 answers
Biml Generated Xml Source (SSIS) has Node_ID column even though the Xml has only 1 node
Using Biml we generate SSIS packages that contain an Xml Source to get data from an Xml file. However this generated XML source includes a column called "Data_Id" even though neither the XSD nor the XML has this column. It generates an error while…
HenkJ
- 21
- 2
2
votes
2 answers
How to connect Excel Source via OLEDB or any other source in SSIS?
Is there any other way rather than "Excel connection manager" to connect Excel as Source in SSIS.
I am asking this question because I have an issue with connecting Excel with "Excel Connection Manager" because in my system Excel 32 bit is installed…
Shahab Haidar
- 625
- 3
- 11
- 25
2
votes
2 answers
Connection manager throw exception when loading .xlsb file using SSIS
I have one .XLSB file (MS excel binary worksheet created using Office 2016) having more than million records. How can I load this using SSIS?
I have both SQL server 2014 and SSDT 2012 & SQL Server 2017 SSDT 2017 on two different PC.
The problem is :…
AskMe
- 2,495
- 8
- 49
- 102
2
votes
1 answer
SSDT Microsoft.AnalysisServices.Server connect throwing "Value cannot be null error"
I am trying to connect OLAP cube server from SSIS using script task(C# .net). I am getting following error
"Value cannot be null".
I am using the SSDT 2017.
The same was working from BIDS 2008. But not working on the SSDT…
kabilan Mohanasundaram
- 399
- 4
- 16
2
votes
2 answers
Importing Excel Data Seems to Randomly Give Null Values
Using SSIS for Visual Studio 2017 for some excel file imports.
I've created a package with several loop containers that call to specific packages to handle some files. I have an issue with one particular package being executed in that it seemingly…
J. Sutton
- 103
- 2
- 7
2
votes
1 answer
How to join two XML files based on an element in SSIS?
I have two XML files, one with 2 elements and the other file with 4 elements. One of them is common between the two files. I would like to pull the contents of both XML files, do a join with the common element (like an inner join between two SQL…
Balaji Pooruli
- 240
- 1
- 3
- 16
2
votes
0 answers
Error creating SSIS 2019 package programmatically
I am able to create package programmatically when it comes to ssis
2016 but when i try to create package programmatically i am getting below error.
could not load file or assembly 'microsoft.sqlserver.dtsruntimewrap,
version=15.100.0.0,…
sam
- 345
- 2
- 4
- 18
2
votes
0 answers
SSIS package upgrade 2008 to 2017
I am very new to SSIS and I am upgrading SSIS package 2008 to 2017.
I have opened Visual Studio 2017 and create solution and add existing package into it.
After adding some warning is showing related to configuration file and script task so how to…
Sneha Yadav
- 21
- 3
2
votes
2 answers
SSIS Build the project and try again
I keeping getting the following error, after adding an annotation in one of my workflow, per below
The package 'x.dtsx' has been modified since the last build. Build the project
and try again. …
fo2bug
- 85
- 1
- 8
2
votes
2 answers
SSIS reading flatfile header column
Can you guys help me (point me in the right direction) on how I can achieve the following in SSIS.
So, I have a flatfile that looks like this
ColumnA ColumnB ColumnC ColumnD ColumnN
1 x APPLE Random1 MoreRandomData1
…
fo2bug
- 85
- 1
- 8
2
votes
1 answer
Convert mmddyy to YYYY-MM-DD in expression task in SSIS
I'm trying to use the below code to convert data from
'010118' to '2018-01-01'
(DT_DATE)(RIGHT(DATE,2) + LEFT(DATE,2) + SUBSTRING(DATE,3,2))
When I run this in SSIS i'm getting conversion error
An error occurred while attempting to perform a…
Gowtham Ramamoorthy
- 896
- 4
- 15
- 36
2
votes
2 answers
Error: Excel Destination.Connections[OleDbConnection] does not have a value for the ID property
I want to write the data from SQL server in Excel destination. When executed the Data Flow Task gets failed due to these error:
[SSIS.Pipeline] Error: The "Excel Destination.Connections[OleDbConnection]" in the connection manager collection,…
Sharan G
- 55
- 7
2
votes
1 answer
SSIS upgrade from 2008R2 to 2017 - script task fails when connecting to OLEDB data source
I'm in the process of upgrading a data warehouse from SQL Server 2008R2 to 2017. After the upgrade, every script task is throwing the same error trying to connect to a logging database.
The task connects to a database via an OLEDB connection…
Eric Brandt
- 7,886
- 3
- 18
- 35