Stack Overflow
Stack Overflow

Questions tagged [ssis-2016]

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

96 questions
0
votes
1 answer

Problem to pass variable parent to child in SSIS 2016 on Datafactory Azure

The pipeline works on DataFactory Azure (SSIS 2016) with no call child package. When my parent package called child package, the variable child doesn't replace by a variable parent. Why?
David
  • 1
  • 1
0
votes
1 answer

Jenkins Bitbucket SSDT Continous Integration DevOps Process

CICD Process with Jenkins, Bitbucket, SSDT(SQL Server Data Tools). Please list out the steps to perform CICD Process. Including what plugins i need to install in Jenkins for SSDT(SSIS-ISPAC file) or SQL Database Solution(DAPAC file)
user1810575
  • 823
  • 3
  • 24
  • 45
0
votes
1 answer

SQLServer:SSIS Pipeline 13.0 is missing in Performance Counter

i want to monitor my SSIS packages performance through Performance Monitor but SQLServer:SSIS Pipeline 13.0 is miss in Available Counter section. See screen shot below how can i add it?
Ankit Tyagi
  • 175
  • 2
  • 17
0
votes
1 answer

SSIS 2016 SMO Transfer error: An error occured while transferring data. See inner exception for details

We are using SMO to transfer tables over from one server to the other on SQL Server 2016. For a while now, the transfer succeeds only one out of 3 times on 1 server only, and we always get the same error message, which doesn't say much: An error…
MChalut
  • 57
  • 6
0
votes
1 answer

Reorder SSIS Variables in Variables Window

Let's say I have the following variable names in the SSIS Variables window: donut apple salad I want to reorder them in the least painful way as possible to apple donut salad In other words, I want them alphabetical, is there a way to do this?
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
0
votes
1 answer

SSIS Excel Destination Nothing Happens when I hit New for Name of Excel Sheet

I have an Excel file that does not exist. I am hoping to create the excel file and worksheet; however, the "New..." button does not work when I click on it. All it does it make the "Excel Destination Editor" screen disappear. The Data Access mode is…
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
0
votes
2 answers

SSIS package gives error after deployment SQL Server 2012

I created a package in Visual Studio 2015. It works fine. Basically I am using a script task that generates Excel spreadsheet and sends it to different users. After I deploy the package to SQL Server 2012 and then try to execute it from there - I…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
1 answer

SSIS 2016 bids connection deployment issues

I have a package that simply pulls data from a SQL source and dumps into another. Source system uses SQL credits to login. Environment 1: QA . Pull works correctly. Deployed to SSIS and ran the job manually and via SQL job agents and runs…
junketsu
  • 533
  • 5
  • 17
0
votes
1 answer

SSIS Execute process task and Powershell for expand files

I am trying to execute an powershell script (the script is unzipping the folders in source path with the same name as the .zip folder) powershell script: param([string] $sourcepath) $sourcepath = "F:\Worflow\" function unzip ($file) { $dirname =…
user3255656
  • 45
  • 1
  • 9
0
votes
0 answers

How to handle double quotes in Excel column in SSIS?

I have a text in Excel like this {sampletext C" (USD"} When i am trying to open the excel in notepad then am getting the data like this {"sampletext "C" (USD"} and then i set the delimiter as none. now am getting the data like {"sampletext "C"…
Vengatesh .s
  • 3
  • 2
0
votes
0 answers

SSIS2014 How to get the status of Destination component in the same DataFlowTask

I am working with SSIS 2014. I have several dozens of millions of rows coming from Attunity Oracle Source component, which its source query has 20 columns and it is time consuming. For some reason, I need to insert 2 columns of the same query in…
OscarSosa
  • 89
  • 1
  • 1
  • 6
0
votes
0 answers

Is it possible bulk insert to always encrypted table using SSIS Bulk insert task?

I need bulk insert to a Always Encrypted table using SSIS Bulk insert task because if it is minimize the modifications for existing packages. Otherwise it will be change for all Bulk insert tasks in existing packages.
rbamila
  • 3
  • 1
0
votes
1 answer

How to use IN inside the split task for SSIS package?

I need to split the flow of data inside the data flow task of ssis based on a string comparison. For example inside the split task i'm using this code "ISNULL(FINDSTRING("a,b,c,d",a,1))" which would return true(coz the findstring function returns 1…
Gowtham Ramamoorthy
  • 896
  • 4
  • 15
  • 36
0
votes
0 answers

Error during inserting data from SQL Server to DB2

I have made a simple DataFlow task in SSIS to move data rfom SQL Server to DB2 on AS400. The connection is OK. I'm able to view and map the columns. The package compiled find. However, I'm getting below run time message.That is just after the…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
0 answers

How to execute SSISDB from external service (WF)

We have SSIS package deployed to SSISDB: We can to execute from SSMS (while providing parameter inputs), as well as script this execution in TSQL. We can run the SSMS standard reports for SSISDB to see progress and logs, and we can query the…
Martin Thøgersen
  • 1,538
  • 18
  • 33
1 2 3 4 5
6
7