All Questions
Tagged with sql-server-2017 ssis
19 questions
0
votes
1
answer
84
views
SSISDB rename for maintenance
We have an SSISDB database that has become too large and we wanted to do some maintenance on it. I've read that you shouldn't rename the SSISDB database as it would break links to existing packages, ...
- 101
0
votes
1
answer
507
views
Aggregate each row and create new monthly column for the weeks to a month
I appreciate all your help. Below is my query and request.
Here is my staging table:
CREATE TABLE MyTable (
[WC] nvarchar(255),
[Requestor] nvarchar(255),
[MTR#] nvarchar (255),
[Date Added] ...
- 3
0
votes
1
answer
444
views
SQL Server user running SSIS package getting EXECUTE permissions error when they have that permission
We have a user running an SSIS package from Visual Studio.
The step that is failing is it is trying to run a stored proc but the error within Visual Studio is "The EXECUTE permission was denied ...
- 101
0
votes
1
answer
208
views
Finding and locally deleting deleted records in a million-record table
I'm trying to incrementally load data from a remote server to a local one (using SSIS and linked server). Remote table has 1.7 million of records, increasing every hour. So far, I have been able to ...
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
2
votes
1
answer
3k
views
SSIS - Setup OLEDB Connection to SQL Server Always On Listener
I am trying to connect to SQL Server 2017 Always On from an SSIS package (built in SSDT 2017).
I am using an OLEDB Connection Manager. 'Application Intent' is set to READWRITE. However, where do I ...
- 533
7
votes
1
answer
2k
views
SSIS Package Not Being Deployed
I have an issue with an SSIS package, that when deployed via VS2017 to the integration services catalog is not actually being deployed. This is an individual package deployment, and not a project ...
- 71
1
vote
0
answers
199
views
Remote Connection to SSIS
I have just created a new SQL Server with SQL Server 2017 (14.0.1000) and SSIS (14.0). I am able to remote connect with the admin user on that server whom I did all of the setup/configuration with, ...
- 237
1
vote
1
answer
5k
views
Trouble Connecting to SSIS in SQL Server 2017 (14.0.1)
Setting up a new server with SQL Server 2017 (14.0.1000) and I just installed SSIS (14.0). As of right now I am unable to connect to SSIS from SSMS and receiving the following error message:
...
- 237
0
votes
0
answers
425
views
SSIS OData Package Fails on SQL Server 2017
Awhile back, I created several SSIS packages, in SSDT 2015, that were deployed to a SQL Server 2016 SSIS instance. They were scheduled with agent jobs and run using basic auth.
Currently, in both ...
- 1,126
4
votes
0
answers
987
views
Why is my SSIS package not getting updated?
I have a Integration Services project within SSDT that has multiple packages. When I right click a single package and choose deploy, SSDT says the operation completed successfully.
However, when I ...
- 13.2k
1
vote
1
answer
551
views
How to prevent concurrency issues in a ssis package?
Have a SQL Server 2017 Server.
Have several SQL Server jobs that call a single SSIS package using the SYNCHRONIZED flag.
In the package there is a data flow that runs a stored proc (please see below)...
- 33
1
vote
1
answer
4k
views
Can I upgrade SSIS 2008 packages directly to SSIS 2017 SSISDB?
I'm planning a mifgration of a SQL Server 2008 instance running the DB engine and SSIS.
The SSIS is deployed to the file system.
Am I able to copy those SSIS packages to a directory on my new ...
- 388
3
votes
0
answers
759
views
Import Oracle unicode data with OLE DB Source and destination in SSIS 2015
My issue is identical to this post on mssqltips.com, however my issue is importing from Oracle, not Excel.
I get all the way to the bottom where I need to map the output columns from my data ...
- 1,133
0
votes
0
answers
949
views
Attunity Connectors for SSDT are not showing in VS 2017 (SSIS Toolbox)
I'm trying to add a connection manager using the new Attunity drivers I downloaded but I'm not seeing it as an option.
This Microsoft page does not list the latest SSDT version (15.x) as one of the ...
- 1,133
3
votes
1
answer
780
views
Database Engine and SSISDB architecture advice
I'm seeking some architecture advice involving the database engine and Integration Services components of SQL Server 2017. We have an existing SQL Server environment which is due for an upgrade and ...
0
votes
1
answer
2k
views
TSQL or SSIS for Direct Insert Speed Performance
I am moving data from Table A into Table B. Tables have the exact same DDL, table structure, and are straight inserts. We are Not transforming or modifying data.
If TSQL Server and SSIS have the ...
user162943
0
votes
1
answer
818
views
SSIS Transfer Login Task Error
I have created an SSIS Transfer Logins Task. I have selected the SourceConnection and DestinationConnection and both valid and active.
I have selected certain Windows group accounts to transfer ...
- 67
3
votes
1
answer
576
views
SSIS 2017 Scale Out functionality and use cases
SSIS 2017 has a scale out feature that distributes executions across multiple SSIS worker instances. I think get the big picture, but just wondering how it divides up the work across the worker ...
- 103