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
1
vote
1 answer
Migrate SSIS packages using dtsconfig only - 2005 to 2017
UPDATE
I tried the provided solution but still I am unable to upgrade the SSIS packages using just config file so that brings me to next question.
Updated Question-
If I want to migrate SSIS packages,change in dtsconfig alone is enough or I need to…
vish1990
- 272
- 3
- 16
1
vote
2 answers
Parse complex xml to fetch particular node text in c#
Parsing XML file using SSIS / C#
operations like fetching record count from trailer , TIN from body and store into a variable or somewhere temporarily(your suggestions please) for further processing. I don't want to store it in a table.
Please…
Santhana
- 407
- 4
- 16
1
vote
1 answer
SSIS 2017 - Package Parts - "P"s disappear, no longer configurable
I am using the new Control Flow Package Parts for my project, and they are hit-and-miss. Sometimes I can drag them on to my packages fine, and they work as expected; however, I have experienced the following problems, and I would like to know if…
codeMonkey
- 4,134
- 2
- 31
- 50
1
vote
1 answer
Issue in downloading files from FTP to local server using Winscp in SSIS
I am unable to download any files using SSIS (Execute Process Task) and Winscp.
I followed various forums and was able to create a SSIS package. I am not sure where I am going wrong.
Steps I followed:-
Execute Process Task :-
i) In Executable…
mehtat_90
- 586
- 9
- 29
1
vote
1 answer
No column information was returned by the SQL command. SSDT
I'm attempting to create an update query in SSDT. I'm getting
Unable to parse query text.
The query is:
UPDATE CustOrderWithDisp
SET YARDS = CustOrderWithDisp.QUANTITY * Lkp_TestCodes.[Test_GALS] * 0.00495113
FROM CustOrderWithDisp
INNER JOIN…
Russtopher
- 123
- 1
- 4
- 12
1
vote
3 answers
running SSIS package as SQL agent job failed
I created SSIS an project, which exports some data to Excel. In Visual Studio 2017 it works fine, but when I run it using a SQL Server Agent job (MS SQL Server 2017), it throws this error:
"Executed as user: Administrator. Microsoft (R) SQL Server…
WhiteB1
- 51
- 2
- 5
1
vote
1 answer
Create action in Windows Task Scheduler run commands for dtsx packages
I am wondering the correct way to navigate to a dtsx package deployed on my SQL Server. While creating the action, so far I have the Program/script to open SQL.
"CD\C\Program Files (x86)Microsoft SQL…
Clint
- 89
- 13
0
votes
1 answer
Are there any reasons an SSIS Lookup Transformation would give 0 output rows, neither matched or un-matched?
I'm debugging an SSIS package locally in VS2019. I have an odd behavior where a lookup transform against a cache is receiving 22 rows on the input, but both the 'Match' and 'No Match' outputs are showing 0 rows. It does work sometimes, but only when…
Kratz
- 4,280
- 3
- 32
- 55
0
votes
1 answer
SSIS package deployment error, with psql-ODBC driver
I have created an SSIS package to transfer data from MySQL to PostgreSQL, and it is working fine on my local system. However, when I try to deploy the package to a SQL Server and schedule a job, it fails to establish a connection with the PostgreSQL…
0
votes
0 answers
CI Build SSIS solution with 71 projects
We have ssis_EDW solution developed in Visual Studio 2017 (Target SQL Server 2014,2016) having 71 SSIS projects in it. We have Azure DevOps Build Pipeline which is used to build the solution on Azure. Here, we have used Devenv.exe to build the .sln…
Rameshwar Pawale
- 632
- 3
- 17
- 35
0
votes
0 answers
Connection error accord while deploying the SSIS package
While deploying the SSIS package in development server the following error has poppedup.
The connection"{E1583EBF-EC9B-40EC-8D8D-12493BDBF13}"is found. This error is thrown by connection collection when the specific connection element is not…
Kishan
- 1
0
votes
2 answers
Send SSIS package failure notification to Outlook email using no credentials
I'm new to SSIS and would like to send an email notification when a package fails. I'm using script task with the following code:
#region Namespaces
using System;
using System.Net;
using System.Net.Mail;
using System.Data;
using…
SQL_Noob
- 107
- 6
0
votes
1 answer
SSIS - Excel Source
Why when I open the task Excel Source on my SSIS (vs2017) this one generates an automatic empty file with sheet names like "a266ff2a662e84b639da". is possible to disable this action?
task Excel Source
0
votes
1 answer
SQL Agent Environment Variables not usable from Referenced Environment
I am trying to set up a SQL Agent Job in SQL Server 14.0.3436.1 (2017), using the SSIS Catalog as a source for an SSIS Package.
When I add the package, I can choose the environments I have set up, but for some reason I do not get presented with the…
High Plains Grifter
- 1,357
- 1
- 12
- 36
0
votes
1 answer
SSIS C# SQLBulkCopy .csv file Error: Failed to convert parameter value from a String to a Boolean. String not recognized as a valid Boolean
I am trying to create a generic module that will load .csv files into SQL tables. The SQL tables are already created and their names, and the name of the file, will be passed as parameters. This what I have so far...
public void Main()
{
…
MChalut
- 57
- 6