Questions tagged [ssis-2014]

SSIS 2014 is Microsoft SQL Server Integration Services 2014, and is part of SQL Server 2014. 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. Please add the SSIS tag.

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
3k views

How to resolve COM server application local activation permission for machine account

I am trying to enable SSIS package logging to event logs. When an attempt is made to write to the event log the following error appears in the system event logs: The application-specific permission ...
2
votes
0answers
165 views

SQL Edition Downgrade Impact on Jobs

we’ve made a downgrade from Enterprise Evaluation Edition to Standard and we saw the over night jobs all running much longer these are ETL packages and SQL Stored Procedures to load data from ...
2
votes
0answers
241 views

SSIS upsert from CSV File Source

I'm trying to determine the most effect way to do an upsert in SSIS with CSV source 100+ columns 1 x CSV Source (loop through multiple CSVs same structure 100 + columns) 1 x Staging Table Destination ...
2
votes
0answers
640 views

SQL Agent - PSexec remote commands causing SSIS packages to hang

First post here, so please be kind! I have a bit of a problem with a set of SQL Agent jobs (SQL Server 2014, running on Windows server 2012 R2) that I am trying to setup. Each job is a multiple step ...
1
vote
1answer
36 views

Directory Verification with For Each Loop in SSIS

How can we check if a directory is valid or not inside for each loop . I am having multiple files at some location and i want to load that file but before this i want to check if the directory is ...
1
vote
1answer
1k views

Protecting Virtualized SSIS and SSRS servers

I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them ...
1
vote
0answers
236 views

Dcom Error running a SQL Package

This is the first time I have come across this type of error. I am running a process task and it runs fine until I add it to the scheduleer ( sql agent). Date 3/2/2017 4:13:05 PM Log ...
1
vote
0answers
64 views

“Fire and forget” in SSIS

I need to run pairs of packages from one job. First packages needs to run linearly. Second ones in parallel. I want to use configuration table for those packages, and use SSIS foreach container to run ...
1
vote
0answers
54 views

SSIS Guarantee that all data will be moved to target when running data flows in parallel

My package has the following two tasks which run in parallel. DF - Move source data to target loads a copy of all source data to target via OLEDB Dest - Target and also loads a copy of source PK ...
1
vote
1answer
3k views

SSIS: To run the package outside of SQL Server Data Tools you must install expression task of integration services or higher

Me and my colleague using the same version of .Net framework (4.5) and installed SSDT in visual studio 2013. He prepared a package (not so complex) and can able to execute the same from SSDT without ...
0
votes
0answers
90 views

Is this an OLEDB Connection String from an SSIS package and how can I tell what generated it?

Inside of an SSIS package (.DTSX) I found a connection string similar to this: Data Source=<some-datasource-name> Initial Catalog=<table-name> Provider=SQLNCLI10.1 Integrated Security=...
0
votes
1answer
232 views

SQL Server kicking off multiple SSIS processes for same job

I've seen this bug before and I don't know what made it go away in the past. I have a test server that has three jobs that each kick off their own SSIS package. In production this works fine and ...
0
votes
0answers
47 views

Identify ssis packages that call ssrs reports

We are migrating our SSRS reports server database from SQL SERVER 2008 R2 to SQL SERVER 2014 and as I understand it this means all SSRS reports will receive a new id. Hence any SSIS packages that ...
0
votes
0answers
358 views

Help with SSIS Framework- Resolve Referrences in Data Flow

LineageString and StageKey are both unmapped. SSIS is giving me an error between the OLE DB Source and the Add metadata. Add Metadata.Inputs[Derived Column Input].Columns[LineageString] has lineage ...