All Questions
31
questions
0
votes
1
answer
670
views
Using SSIS Project Parameters in SQL Agent Jobs
I'm using SQL Server 2019 and attempting to set up project parameters for my SSIS projects. I've set up project-level parameters within the package itself and those parameters do appear in SSMS for me ...
- 167
1
vote
0
answers
2k
views
SQL server job agent fails to execute SSIS package, the package runs fine manually
I have a job which executes two packages. Step 1 is a package which is no longer executing under the job agent although it was executing fine before the server reboot. The package executes fine ...
1
vote
1
answer
700
views
Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer
I am new to MSSQL. I have a question about executing MSSQL Stored Procedure.
Let me briefly talk about my development environment first:
PC400 (Computer/Server A), where SQL Server 2012 is installed
...
- 11
0
votes
2
answers
2k
views
SQL Server Agent not running SSIS package
I have followed many articles to create an SSIS pipeline package, deploy it and schedule it.
I'm trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database ...
0
votes
1
answer
2k
views
How to recover missing SQL auto-recover files in SSMS (Microsoft SQL Server Management Studio) after unexpected shutdown
SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not all of them, especially one in particular. ...
- 137
2
votes
1
answer
738
views
Installing SSIS package outside of SSIDB catalog
I'm trying to simplify deployment of a SSIS package to a remote server. At the moment, I have
Local Visual Studio SSDT and SSIS package that has 4 connection managers - DEV environment
Remote server ...
- 143
0
votes
1
answer
2k
views
SSIS cannot deploy package to SQL server - An error occurred during decryption 15466
After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
=============================...
- 101
0
votes
0
answers
74
views
Failing to connect to Integration Service with SSMS on one VDI but on another it works fine
I have two VDIs with the exact same version of SSMS installed. On one, I can log into the standalone Integration Service of a remote server running SQL Server 2017, on the other I cannot.
Every ...
- 1
0
votes
1
answer
465
views
How to get SSIS to stop waiting/processing at task above time limit?
So I have a couple SSIS packages that are run sequentially, scheduled through SQL Server Agent. Right now, I'm getting some errors where certain input data steps just wait indefinitely-- i.e access ...
- 113
1
vote
1
answer
1k
views
Execute SSIS (package) in SSMS using T-SQL and return a value
Using VS (2019) I created an Integration Services Project to code an SSIS package. The goal was to call a Web API from an SSIS package using input variables like username/password/url and so on. I ...
- 11
1
vote
0
answers
528
views
I manage to connect to Azure Analysis Services from SSMS, but not from SSIS
I'm new to the Microsoft Server Suite.
I've downloaded SSMS and connected to Azure Analysis Services from it. I'm able to query my data using mdx without any problems.
However, I actually intend to ...
- 11
0
votes
0
answers
3k
views
Installing Oracle 32 or 64 bit on a Windows Server 2019 to Import data into SQL server and use with Power BI
I am an Oracle noob and really struggling with this concept of 32 and 64 bit business with Oracle.
All I really want to do, is import data on a daily basis from an Oracle 12c DW into a local 2019 ...
- 1
0
votes
2
answers
1k
views
why there is no incremental backup in sql server [closed]
How i can change my database backup type from full backup to incremental backup? Is that possible? Why there is no option for incremental backup type.
2
votes
1
answer
2k
views
Imported SSIS package fails if imported with SSMS on the SQL server, but works when imported from a remote PC
I am facing a strange issue on SQL Server 2017 Enterprise edition running in AWS on EC2.
When we are on the SQL server and we import an SSIS package using the locally installed SSMS connected to ...
- 314
0
votes
1
answer
2k
views
Changing the connection string in SQL Server
We deployed the packages from an old server to a new server. How to change the connection string i.e initial catalog or server name parameter from Agent job -> Configuration -> Connection ...
- 11