Stack Overflow
Stack Overflow

Questions tagged [ssis-2014]

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

38 questions
0
votes
1 answer

Check if there are files in the source folder

I am using an SSIS package that removes the rows from the SQL table before importing. Before I run any tasks, I want to check if there is a file in the source folder. If the file exists, we will run our other SSIS tasks. Otherwise, we can complete…
hana
  • 101
  • 10
0
votes
0 answers

Automatically created Excel file

I have an SSIS package for importing excel files into the database. In my source folder, I got an automatically created excel file, and I did not create that file. Even after I delete it, the file will be created again, and it shows that my user…
hana
  • 101
  • 10
0
votes
1 answer

How to use an SSIS Variable Value or Project Parameter Value as an expression body and then evaluate it to another Variable

I have an SSIS Project (Visual studio 2019 - Project Deployment Model) which contains 100 SSIS Packages. The name structure of each package is TableName_Table.dtsx (For example: If my table name is Employees then the package name will be:…
Panos_Koro
  • 45
  • 6
0
votes
1 answer

Devops deployment passing arguments\parameters to a SQL Script

I am trying to run a script that creates Environment variables for an SSIS package. Depending on the destination i.e. SIT, UAT or PRD I want my script to use different variable values depending on the destination. In my script I have a variable…
user1790316
  • 1
  • 1
  • 3
0
votes
0 answers

Deployed SSIS package throwing error. Works fine in local

I have to edit a SSIS package written by somebody else. On loading the package in Visual Studio I was getting error "Failed to decrypt protected XML node". I resolved this error by setting property Protection Level to "Do not Save Sensitive Data" at…
sandy
  • 283
  • 2
  • 7
  • 17
0
votes
0 answers

How do I generate the input /output columns dynamically in SSIS script component (transformation) using BIML

How do I dynamically generate script component(transformation) input and output columns using BIML? I have created microsoft-ssis.blogspot.com's 2015-02 sample The problem with that approach is the input and output columns for script component are…
user2261767
  • 9
  • 1
0
votes
1 answer

Procedures shipped with SSISDB causing issues with Filtered Indexes

SQL Server 2014 I believe. Procedures in SSISDB have QUOTED_IDENTIFIER set to OFF for some reason, and was wondering if anyone had any frame of reference as to why this might be, and if it might be important. Unfortunately I don't know if changing…
drexasaurus
  • 60
  • 6
0
votes
0 answers

How may execute SQL Server tasks can be called in parallel?

Context: I have around 30 independent stored procedures that are currently executing in series through the SSIS package. I believe by taking advantage of parallel execution in SSIS I can gain some performance. How to figure out the number of Execute…
N.Dinesh.Reddy
  • 522
  • 2
  • 7
  • 15
0
votes
1 answer

Fast load error output doesn't redirect entire batch

Context I am developing a simple SSIS package that contains a Data flow Task with: 1 OLE DB Source 2 Lookup Transformations 1 OLE DB Destination 1 OLE DB Destination for error output rows I am using the FastLoad option in both OLE DB Destinations…
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
0
votes
0 answers

I am struggling to have a 24 hour Mysql Connection from SSIS

I have an SSIS job that connects to mySQL db, it runs from 01:00 to 13:00 daily for every 15 minutes, but it return Zero rows once it hits 02:00 and does not fail and I have to run the SSIS job for it to start working propely again, I want to know…
Marvin Butji
  • 1
  • 1
0
votes
1 answer

How to secure sensitive data for SSIS packages after deployment?

We have a SQL Server 2014 with SSIS, three software department of our organization needs to deploy their ssis packages to the same server and each department is responsible for their sensitive data and not allowed to share passwords which are…
Alireza Salehi
  • 87
  • 1
  • 9
0
votes
0 answers

SSIS data flow task or store procedure?

Which is the faster way to load data from a table in one server to another table present in a different server? Data flow task or a stored procedure in an Execute SQL Task? Say, the table has around 100 million records and has necessary…
AswinRajaram
  • 1,519
  • 7
  • 18
0
votes
0 answers

SSIS Catalog - Powershell - Access Package Variables

As the title suggests, I’m looking to get access to the variables in a package, when it is stored in the SSIS Catalog, using powershell. The reason I’m looking to do this is that Package Variables allow me to initialise and pass objects from…
illustro
  • 143
  • 6
0
votes
1 answer

SSIS 2014 - column mirroring

I have a table like below: Col1 | col2 | col3 |col4 | col5 and now after reading this table i want to split it into two parts: part 1 will have : col1 | col2 | col3 | col4 part 2 will have : col1 | col2 | col3 | col5 I want all rows from the source…
Beginner
  • 71
  • 1
  • 3
  • 10
0
votes
2 answers

SSIS Foreach loop through text files with "crosswlk" in the name

In my Foreach loop I only want to process files that have crosswlk in the filename. Unfortunately this is in the middle of the filename and I can't do crosswlk.pgp. I have Googled this a bunch and most solutions say to do some C# in a script task…
Rich Uchytil
  • 457
  • 1
  • 7
  • 16
1
2
3