Questions tagged [ssis-2016]
SSIS 2016 is Microsoft SQL Server Integration Services 2016, and is part of SQL Server 2016. SSIS allows SQL Server to interact with other technologies, including import and export of data to and from other formats, or ETL, and data warehousing.
47
questions
0
votes
1
answer
97
views
SSIS Variables as expressions to generate Start and end dates of a quarter with input year and month passed as variable
Can someone help me create SSIS expressions for variables to generate QuarterStart(DateTime) and QuarterEnd(DateTime) as a variable with year(int32) and quarter(int32) passed on as user variables.
The ...
0
votes
0
answers
52
views
Passing the file path and file name and getting data in SSIS using foreach loop container
Can I do the same without using Foreach loop file enumerator?
If I do the automation to pick file using foreach loop file enumerator i am facing errors like:
Error at Package1: The connection "{...
0
votes
0
answers
29
views
Download files from multiple FTP folders inside particular files in SSIS
I have an FTP server with a folder named CIV.2-130211067212254633.
Inside this folder, there are files with names like 066075254035232083135067074114053142221015071213.Upload.
...
3
votes
1
answer
6k
views
Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite
I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://...
0
votes
1
answer
605
views
How to create Destination table name with Getdate in SSIS OLEDB destination
How to create Destination table name with Getdate in ssis destination task.
I have one table like Test..but i want to create new table like Test_09Feb2023 in OLEDB destination.
0
votes
1
answer
270
views
SSIS package loses .NET provider password even though EncryptSensitiveWithPassword is enabled
I have a new SSIS project developed in VS and intended to run on a SQL Server 2016 instance. The project has the ProtectionLevel of EncryptSensitiveWithPassword set. A package has a connection to a ....
0
votes
1
answer
136
views
SSIS debuging tool in SSMS 2016
I want to trace the execution and see the changes in variables in the package during the runtime. the Microsoft report tool for the SSIS package is not sufficient. I want more details and don't have ...
0
votes
2
answers
583
views
SSIS package randomly fails with "WriteToServer requires an open and available Connection" error
Our SSIS package randomly fails with the following error message:
An exception has occurred during data insertion, the message returned
from the provider is: WriteToServer requires an open and ...
0
votes
1
answer
2k
views
How to make variable update for each instance of for-each loop?
I have a for-each loop that goes through a file directory. These files are transaction information from different clients. When there is an error with a file (i.e. can't be processed), the Event ...
0
votes
1
answer
688
views
Granting access to users to run specific SQL jobs that runs SSIS packages [duplicate]
We need to grant a couple of users access to run only specific SQL jobs that runs SSIS packages. Is there a solution that can be used to accomplish this?
0
votes
1
answer
141
views
Design Sql Server physical configuration from existing VM
We have 4 virtual machines that we used to test our BI platform (PoC), the final dimensions are:
SSIS (16 vcpu), SSAS (8 vCPU), SSRS (4 VCPU) et Data Engine (24 vCPU)
What are the recommendations ...
0
votes
1
answer
1k
views
Agent Job: Execute T-SQL on different server?
While migrating SQL Server databases on updated hardware/software we separated the ETL server from the database server (referred this link).
We were moving our SSIS packages and agent jobs on ETL ...
0
votes
1
answer
601
views
SSIS Package Failing since Database failed over to Secondary (Basic Availability Group)
Our SSIs package running via SQL Agent Job on a dedicated Reporting server had been running fine since deployed more than 3 weeks ago. Due to performance issue we had to fail over the database to ...
0
votes
1
answer
316
views
SSIS: Conditional operator in expression builder ignores previous text
Consider the following simple expression in SQL Server SSIS, where a variable is built with the following expression containing a conditional operator:
"Preamble
"
+
@[$Package::myParameter] == "" ? ...
0
votes
1
answer
276
views
improving join performance on sql server table
I have a table on sql server lets say TableA.
and a another table as TableB.Both of these tables are heavily loaded.
Table A is loaded with records 35883788. It is holding a lot of duplicates on ...