Questions tagged [ssis]
SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server
81 questions
1
vote
1
answer
40
views
How do I copy a full Data Flow Task (DFT) to another project if pasting fails with "At least one connection manager could not be pasted correctly"?
How do I copy a full Data Flow Task (DFT) from one project to another if pasting the project connection manager throws the error:
At least one connection manager could not be pasted correctly.
The ...
- 464
2
votes
1
answer
98
views
How can I set MARS to "True" in the connection manager if it switches back to "False" right away after closing the properties? Or why is that?
The connection manager writes to a table. Perhaps once a week, the error is thrown:
Connection is busy with results for another command
SSIS get deployed to Microsoft SQL Server 2016 (SP3-CU1-GDR) (...
- 464
1
vote
1
answer
137
views
Connecting to Multiple Instances of SSIS on the Same Server
I have a server that I inherited that has multiple versions of SSIS installed (11,12,14, 15) on it. See Screen shot
Based on my understanding, in order to connect to a specific version of SSIS you ...
- 173
-2
votes
1
answer
45
views
How can I swap the Merge Join inputs without crashing SSIS?
I have chosen SSIS for SQL Server 2016 since my SSIS Server is just 2016 anyway (SELECT @@VERSION gives Microsoft SQL Server 2016 (SP3-CU1-GDR) (KB5029187) - 13.0.7029.3 (X64)). Perhaps a younger SSIS ...
- 464
1
vote
2
answers
2k
views
How to solve the intermittent failed execution of SSIS package in debug mode
I created an SSIS package with Oracle data source and SQL Server destination ok. In fact through an SQL query I want to export data from an oracle table to an SQL server table. At this level ...
- 11
2
votes
0
answers
81
views
Emptied SQL Server Database broke the Cube
We have a SQL Server hosting our Analysis Services and accessing data from the ERP system by a ETL process. It was some duplicates in the data and therefore the SQL Server database was emptied. After ...
- 71
1
vote
1
answer
994
views
Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager"
I am trying to download data files from a FTP server to local machine through SSIS. But it throws the error
Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP ...
-1
votes
1
answer
5k
views
ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user
Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to ...
- 1
1
vote
2
answers
1k
views
How can I add the server name to the subject line of a SSIS subscription email?
How can I add the server name to the subject line of a SSIS subscription email?
In Microsoft SQL Server Integration Services (SSIS) RDL report files uploaded are often set with the ability to send ...
- 129
0
votes
1
answer
5k
views
Error in job agent when running a package in SSISDB catalog (SQL Server)
I created a simple package in visual studio. Then I deployed this package in SSISDB catalog which is on a different server. I am using Job agent to execute this package with a proxy account. But I am ...
- 21
0
votes
1
answer
2k
views
Requirements to set up "Run as different user" for SQL Server 2016
Our organization has two types of accounts for server administrators. Both are individual user accounts in Active Directory tied to a given employee. However, they only give system (server and ...
- 2,024
-1
votes
1
answer
195
views
SSIS as a Service on a VM
I have an Azure-hosted SQL Database. As is well documented, SSIS is not currently supported on Azure. There are a number of articles about running SSIS and SQL on an Azure VM, but this is ...
- 166
0
votes
2
answers
82
views
SSIS with MySQL and without SQL Server
Our Organization is planning to cut costs on SQL Sever licenses. We use SSIS for our ETLs. Is it possible to install only SSIS with a MySQL server and without SQL Server?
3
votes
1
answer
21k
views
Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"
On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016....
- 173
1
vote
0
answers
545
views
Unable to remotely connect to SSIS catalog
I have an SSIS installation on which I can not connect through our Citrix hosted Sql Server Management studio.
I can connect to it when running SSMS locally.
But if I try to connect remotely, with ...
- 5,607
0
votes
1
answer
60
views
Why is SSIS reading so much data from my hard drive?
We're running SQL Server 2012 on Windows Server 2008 R2 for a our CRM and ERP services.
Unfortunately, the majority of the setup was outsourced to an "expert" company who neglected to provide any ...
- 800
0
votes
1
answer
469
views
SQL Server Agent Service - SSIS package scheduling not working
We have a local admin privilege to our VPN users and we have created SSIS packages but not able to run it through SQL server agent services as its not allowing to run throwing error being non-...
- 121
1
vote
1
answer
124
views
Is it possible to keep 'owner' on file-copy?
When doing a "Operation: Copy file" using a "File System Task", is it possible to preserve the "Owner" attribute on the file?
What happens: The destination file gets the "Owner" as the user running ...
- 153
1
vote
1
answer
3k
views
Connecting SSIS to AWS RDS SQL Server Instance
I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message:
Non-SysAdmins have been denied ...
- 151
0
votes
1
answer
618
views
How do I update Dynamics CRM with from flat file via Kingswaysoft?
I've been trying for some time to update existing leads in CRM via .csv files and the migration tool by Kingswaysoft.
I am trying to update fields based on one key column, updating old leads and ...
- 153
1
vote
0
answers
1k
views
DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
After moving a package to another server, I am unable to run it from a stored procedure using xp_cmdshell or from a job. The package exists in the file system, and I added it to the SSIS Package Store....
- 11
0
votes
1
answer
239
views
SSIS 2014 - map NFS
We are migrating SSIS from SQL 2008 to SQL2014.
Old OS: WINDOWS 2008 R2 SP1
New OS: WINDOWS 2012 R2
I use the Execute Process Task to map an NFS share to a drive.
Executable: C:\Windows\System32\...
- 1
1
vote
1
answer
4k
views
deploy ssis 2012 packages on 2008r2 server
We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this.
Is this even possible and ...
- 35
-2
votes
1
answer
131
views
Processing data faster using ssis and an ssd drive
We have a new local server that processes data using sql server 2008 and ssis. in this server i have dedicated drive to do different things. the c drive is for the os and software. the d drive is for ...
2
votes
1
answer
4k
views
Deploying an SSIS Package - TNS:could not resolve the connect identifier specified
I have an SSIS package which has 4 connections - a WebService, 2 SQL Server connections (across 2 domains), and 1 connection to an Oracle DB.
When the package is run from Visual Studio from a laptop, ...
- 121
0
votes
1
answer
4k
views
SSIS/ETL jobs fail with network related errors, when network is OK
We have a SQL Server 2012 instance that is our main ETL/DW server. The daily jobs consist of about 40+ ETL processes querying other data sources, updating the DataMart, standard ETL and BI processes.
...
- 165
0
votes
1
answer
75
views
SQL Server with one ethernet output and Webserver with another ethernet output
Scenario:
I have one server which is virtualizated using VMWare ESXi. Specs:
Windows Server 2008 R2
SQL Server Standard 2012
IIS 7.5
Hosting a MVC and a Webform application (using Reporting ...
- 101
1
vote
2
answers
4k
views
MySQL ADO.NET Connector & MSSQL Integration Services
Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention.
I ...
- 173
1
vote
1
answer
12k
views
SSIS DSN Not Showing as ODBC Data Source
I have been following the directions here:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4
And ran into a problem where my System DSN ...
- 173
0
votes
2
answers
27k
views
SQL server agent job to execute SSIS package fails, package succeds if run manually
I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
- 8,110
2
votes
2
answers
646
views
Why does SQL 2005 SSIS component install fail?
I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below ...
- 483
5
votes
1
answer
1k
views
Distributed and/or Parallel SSIS processing
Background:
Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
- 51
0
votes
1
answer
2k
views
SSIS package hangs on Setting Source Connection
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via ...
- 101
3
votes
1
answer
13k
views
The package failed to load due to error 0xC0011008 Error Loading from XML
Environment:
Windows Server 2008 SP2 Enterprise Edition 64-bit
SQL Server 2008 SP3 Standard Edition 64-bit
Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
- 2,369
0
votes
2
answers
2k
views
How to copy files to destination system through a specific LAN card?
I want to copy database backup from my running DB Server to Backup server. The source server has two LAN cards connected through their own IP address. One LAN card is used to connect to the ...
0
votes
2
answers
431
views
OpenSSH and remote invocation
Before I ask the questions, I have to provide some context information...
I have a SSIS server which invokes a SSIS package. The SSIS package copies a file to a file server. After the copy action, ...
- 135
2
votes
3
answers
8k
views
How can I make my SSIS process consume more resources and run faster?
I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports.
I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (...
- 327
0
votes
1
answer
1k
views
Error with SharpZipLib in Script Task SSIS 2008
I am trying to create a script which can Zip any file on the fly. For this a DLL SharpZipLib i have used. But unable to run the Package. Following code i found on the internet which i have used as is ...
- 11
1
vote
1
answer
632
views
Edit SQL Server SSIS Package
I ran the Export wizard to output some data to Excel, and I saved the package to run agan later. I now want to edit the SQL used to generate the Excel, but it is not clear how I do this.
The package ...
- 740
1
vote
2
answers
236
views
Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?
I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. I'...
- 243
0
votes
2
answers
1k
views
SSIS Configuration problem: not returning SQL Server Table config values
I have a package that runs fine on my dev machine but in production the Config seems to stop working. I'm using SQL Server Table configuration to pull a value from a table and populate a variable. My ...
- 121
0
votes
2
answers
299
views
Automatically set up user's subscription in SSRS
I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date.
In my report, I include a filter by UserID to limit the data to just ...
- 111
0
votes
1
answer
2k
views
Possible to connect securely to remote MySQL using SSIS?
I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL ...
- 238
1
vote
1
answer
5k
views
SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access
Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
2
votes
2
answers
97
views
SQL 2005 SSIS and Package
If I have a SSIS Package created in VS 2005 and asked to install and setup this package. Does the server that is going to run this SSIS package have to have SSIS installed? I am 99% sure this is yes, ...
CWL
0
votes
2
answers
2k
views
Two way synchronization with SSIS?
Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2.
If it is possible, then how do I handle ...
- 175
0
votes
1
answer
143
views
MSSQL: SSIS 2005 transfer logins task
I created an SSIS package to transfer logins from one server to another in SQL 2005 SSIS project using BIDS.
I want to transfer all packages but skip 3. So I changed the maximum number of error ...
- 333
3
votes
1
answer
4k
views
Execute SSIS package from a SQL Agent on another server
Here's my situation:
I have two servers, Server A has the Database Server installed and the SQL Agent (SQL Server 2008 Enterprise Edition, 64-bit). Server B has a vendor specific application that ...
- 252
1
vote
1
answer
724
views
MSSSQL: SSRS, SSAS, SSIS edition
How can I know which edition of SSRS, SSAS and SSIS service is installed on a server?
Finding database edition is easy but how to find edition for other SQL services?
Any help please?
Thanks in ...
- 333
1
vote
1
answer
394
views
PostgreSQL - Using COALESCE keyword in SSIS
When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set.
I am using a Native OLE DB\PostgreSQL Native Provider as a ...
