Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssis]

SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server

77 questions
1
vote
1 answer

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 is visible (in Stored Packages > MSDB) in SSIS,…
CJM
  • 730
  • 3
  • 12
  • 28
1
vote
1 answer

odbc connect to cluster node error

I recently installed SQL Server Integration Services onto one of the nodes of a single cluster thats running windows 2003 enterprise. When I attampt to create a system odbc connection to the database on the cluster, i get a connection failed error.…
phill
  • 327
  • 3
  • 13
  • 20
1
vote
2 answers

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'm loading data from a local SQL Server instance…
Kevin Babcock
  • 243
  • 1
  • 4
  • 12
1
vote
1 answer

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 application log: SQL Server Scheduled Job…
DaniellaMercuryFan
  • 249
  • 1
  • 8
  • 17
1
vote
1 answer

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 advance.
Manjot
  • 333
  • 1
  • 3
  • 17
1
vote
1 answer

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 connection to the database and other key words are working…
hadEnoughOfKeyboardGangstars
  • 133
  • 5
1
vote
1 answer

How do I filter duplicates from a sharepoint list using ssis

I have successfully connected a sql data base to a sharepoint list using ssis. The problem is that every time I run the project all the data gets dumped into the list and causes duplicates. Is there a way to not import the duplicate entries?
Jeff
  • 11
  • 1
1
vote
2 answers

Can SSIS transfer data from a SQL Server 2005 database to a 2008 database?

I need to transfer data on a regular automated basis from a database running on a SQL Server 2005 instance to a remote database running on a SQL Server 2008 instance. I'm new to database administration and using SSIS. Is it possible to configure an…
Andrew Corkery
  • 113
  • 2
0
votes
2 answers

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 out periodic email alerts. On the SSIS 2008 system,…
xarzu
  • 109
  • 5
0
votes
1 answer

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 getting this error in Job Agent: "Excuted as…
SKK
  • 21
  • 1
  • 2
0
votes
1 answer

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 database) access using our admin-{user id} account. …
JustBeingHelpful
  • 1,964
  • 7
  • 37
  • 53
0
votes
2 answers

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?
Sri Paruchuri
  • 11
0
votes
1 answer

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 documentation. For this and various other reasons,…
HorusKol
  • 751
  • 5
  • 13
  • 31
0
votes
1 answer

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-administrator . ERROR: Failed to decrypt protected XML…
Pawan Pandey
  • 121
  • 3
0
votes
1 answer

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 importing new leads. Now, how do I set up the…
VanDerSpar
  • 153
  • 1
  • 5
1 2
3
4 5 6