SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

learn more… | top users | synonyms

0
votes
1answer
1k views

execute [SSISDB].[catalog].[create_execution] with 'execute as"

We are testing a 3rd party tool to schedule/execute jobs in our environment so trying to test launching SSIS packages within the integration service catalog. I have found examples of the code to run ...
1
vote
1answer
198 views

SSIS Script Task doesn't appear to run when scheduled

I have a script task inside SSIS which does not appear to run when the job is triggered from SQL Server Agent. I say does not appear to run because I don't know if it's the SQL Script task or some ...
1
vote
1answer
23 views

Documenting SSRS and SSIS jobs that are the Job Activity Monitor

We are running a SQL Server 2014 database using SSRS as a reporting tool. We have data coming in via SSIS jobs and linked servers. We have developers creating various SSRS jobs and scheduling them. ...
1
vote
1answer
28 views

Create a XML file from an XSD in SSIS using TF XML output destination

I am currently trying to create a xml output based on a xsd. The tool i am using is Visual studio 2012. I have pragmatic works installed in it. So I am trying to make use of the TF XML output ...
1
vote
1answer
209 views

“Unspecified Error” when executing SSIS Package

I am executing an "Initial Load" SSIS package, which truncates all ETL tables first, then re-populates them by pulling data from a remote server. I get the dreaded "Unspecified Error" at a different ...
0
votes
1answer
163 views

How to specify localhost for SSIS package source server?

I have a job running on SQL Server 2012, where one of the steps is of type "SQL Server Integration Services Package". For the "Package source" I choose SSIS Catalog. For the "Server", if I type in the ...
3
votes
2answers
168 views

SSIS Data Flow data access mode - what's the point of 'table or view' vs fast load?

Using the SQL Server Business Intelligence Development Studio, I do a lot of flat file to OLE DB destination data flows to import data to my SQL Server tables. Under "Data access mode" in in the OLE ...
1
vote
1answer
304 views

SSIS append trailer with Script

I am trying to add a footer to a flat file output. I have 2 data flows in my control flow. One creates the file from the DB. It goes from OLE DB Source to Flat File Destination. The second control ...
4
votes
4answers
6k views

Not able to create SSISDB catalog

Getting the error below while trying to create a catalog in sql server 2014 integration services. Any idea what I missed in installation or anywhere else? The catalog backup file 'C:\Program Files\...
1
vote
1answer
51 views

SSIS package succesfully completes but does not import 100% of records from flat file into table [closed]

I have a fixed width text file. I have created an SSIS package that imports the file into a table in a SQL 2014 server. When I open the file (with notepad++) i see that it contains 259,735 records. ...
1
vote
1answer
595 views

SSIS Package Execution From Visual Studio Unit Test

Hello I am attempting to run a test which contains the following code: string pkgLocation; Package pkg; Application app; DTSExecResult pkgResults; ...
2
votes
1answer
30 views

Tablediff utility output file encoding

The problem happens when sql server tablediff utility generate a file with differwnces between source and destination and when ssis execute the sceipt file which contains arabic letters are inserted ...
3
votes
2answers
152 views

“Upsert” trigger writing mass duplicates from SSIS

I have a problem with an "upsert" trigger, being triggered by a SSIS package with fastload. (FIRE_TRIGGERS is enabled) CREATE TRIGGER [dbo].[MP_VOL_UPSERT] ON [dbo].[vwMP_VOL] INSTEAD OF ...
0
votes
0answers
19 views

Drivers issue for OpenRowSet

Recently, we move our openrowset code to production environment. SP uses OLEDB 15.0 Package use OLeDB 12.0 It is working properly on QA environment. But before going to Prod we uninstalled 12.0 ...
0
votes
2answers
802 views

Data Flow Transform Not Automatically Mapping Columns

I'm in the midst of creating a set of SSIS 2014 packages (using Visual Studio 2013) importing data from 50 tables. Since most of the tables are being filtered on the same column and I'm importing all ...
0
votes
0answers
15 views

SSISDB Catalog in sql server [duplicate]

I have SSIS feature installed but in what case I should configure SSISDB ? To my knowledge all sys.ssispackages resides in MSDB in SSIS. But my set up is new and it is AOAGs set up so just want to ...
0
votes
0answers
23 views

SSIS File System Task Rename File Could not find a part of the path error

I have created an SSIS package that uses a File System Task (move and rename file in one step) that moves and renames a file from 1 folder to another. The package runs fine and it works great (it ...
0
votes
0answers
51 views

Running internal.cleanup_server_retention_window on SSISDB causes t-log to fill up

I have a SQL Agent job that runs internal.cleanup_server_retention_window on my SSISDB to keep it's size in check. The retention period is one day and it's scheduled to run each day. The problem is ...
0
votes
0answers
29 views

Exclude a Variable from getting logged in a CheckPoint file

I have an SSIS package in SQL Server 2014 which uses checkpoint to handle the cases where it needs to be run after a failure. There is a variable in the package that I want to be set to 0 whenever the ...
2
votes
1answer
1k views

SQLNCLI10.x vs 11.x when connecting SSIS 2008R2 to a SQL Server 2012 database

Starting from the question and working backwards. My question: is it OK to use SQLNCLI10.1 as a provider for SSIS 2008 R2 to connect to SQL Server 2012 database(s)? I have a SSIS box running SQL ...
0
votes
1answer
497 views

Issuing Inserts/Updates to Progress OpenEdge via ODBC

I'm attempting to build some ETL to integrate our SQL Server environment with a remotely hosted 3rd party app running Progress OpenEdge. I have a linked server to it set up in SQL Server 2014. ...
3
votes
1answer
232 views

What is the relationship between the SSIS Package Store and Catalog?

I have a server with a working installation of the Sql Server 2012 SSIS Catalog. I need to set up an additional instance including the SSIS Package Store service as an interim step while the packages ...
1
vote
1answer
57 views

Set an SSIS SQL Agent job to unexpected error or failure

I was running a series of SSIS packages in a SQL Agent job on a virtual server when the server was shutdown - hard. The package execution report shows it as still running even though I believe it is ...
0
votes
2answers
209 views

problems when importing csv files into SQL Server using SSIS when the columns are not consistent from quarter to quarter

I am using SSIS to upload a bunch of csv tables into SQL Server Express. The csv files are quarterly data files. They are largely consistent but every couple of years a column may be added or an ...
1
vote
1answer
3k views

SSIS Package Validation Error when Executed From Windows Task Scheduler

I have deployed my SSIS package using the project deployment model to the SSIS catalog and experience a strange validation error when I try to execute the package. I believe this is due to a ...
0
votes
1answer
130 views

Communication Link Failure in SQL

I have an SSIS package that runs daily in SQL agent, there are days that the job is failing due to "Communication Link Failure" but sometimes successful. I search the net for some solutions and there ...
1
vote
1answer
28 views

SQL Server Integration Services 2012 - Legacy deployment

I'm currently reading a lot about SSIS and I have read that there are now two models for deploying a solution : the one using "Projects" and the one using "Packages". Starting SQL Server 2012, a ...
2
votes
1answer
32 views

How do I deploy an SSIS package?

I am very new to SSIS. I have inherited a bunch of databases and SSIS packages. I notice many jobs utilizing many different packages. When I look at an existing job and try to see where a package it ...
5
votes
2answers
38k views

Converting Non Unicode string to Unicode string SSIS

I am creating a package where I will be exporting data from a database into an empty excel file. When I added only the source and destination components and I ran the package I got a conversion error ...
0
votes
1answer
43 views

Running Excel Macro Code by SSIS package configured with SQL Server Job agent

I am trying to execute an Excel macro. It executes successfully on Visual Studio Data Tools 2012. But When I configured this package with SQL Server Job agent and try to execute this, it throws an ...
0
votes
1answer
57 views

How to do data migration between different schemas?

My company is in the process of migrating a customer's data from their third party system into our own system. We currently use a java application that we have developed in house that selects data ...
1
vote
1answer
76 views

Consume Rest Api with SSIS

I try to consume a Rest API (JSON export) with SSIS. Since it seems that a REST source is not supported by SSIS I was looking for a solution but could only find the SSIS JSON Source. Is there a non ...
0
votes
0answers
13 views

SSIS - How to identify which remote server is executing SQL Jobs (task/packages) on our local server?

I have a situation that in SSISDB All Execution report I get an error message related to failing dtsx package. I've found in here some basic information in here: link But it doesn't show the failing ...
0
votes
0answers
15 views

Identifying SQL Job name related to failing package message in SSISDB All Execution report [duplicate]

I have a situation that in SSISDB All Execution report I get an error message related to failing dtsx package. In link below I've found in here some basic information: SQL Server 2012 catalog....
1
vote
1answer
59 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 ...
3
votes
1answer
24 views

Error When Trying to Run MDW Data Collector

I have SQL Server Management Data Warehouse (MDW) set up across multiple instances, all in the same way with the same accounts and permissions. On one server I get an error when trying to run the ...
2
votes
3answers
15k views

How to move a SQL Agent Job to another Server?

I'm moving from SQL Server 2005 to SQL Server 2008R2, and I see there is one job in the SQL Server Agent Jobs that I need to move but I see it also in the SSIS---> Stored Packages\MSDB\File ...
0
votes
0answers
45 views

SSIS - The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

I am trying to use explisit transactions within SSIS. The database I am working with does not have the DTC enabled, so I cannot use SSIS' inbuilt transaction handling. I have execute sql tasks to ...
6
votes
2answers
436 views

SQL Server 2012 catalog.executions to sysjobhistory - any way to join them?

I have exhausted my resources and can't find a foolproof way to join the ssisdb.catalog tables to the jobs that run them. Trying to write some custom sprocs to monitor my execution times and rows ...
1
vote
1answer
30 views

Offsetting reporting Load from one server to another

I have a SQL Server 2008r2 database ( Let's call it "BIG_DB") at 200GB. This server gets hit hard. It is the back end for an application, BIG_DB is a source of a lot of reporting. There are about ...
0
votes
1answer
28 views

What are the minimum requirements for running a dtsx package on a PC?

One of my clients has some very specific needs to get a spreadsheet run through some ETL processes I have created. I have developed an SSIS .dtsx package which imports an Excel spreadsheet into SQL ...
2
votes
0answers
10 views

How to retrieve the distinct domains of a compound domain from DQS using SSIS?

MS Data Quality Services (DQS) has a concept of Compound Domains, which lets you turn say "'99 Chevy Maliboo" into {year:1999, brand:Chevrolet, model:Malibu} SSIS has a "DQS Cleansing" component. It ...
0
votes
0answers
14 views

SSIS package for Table copy dynamically [duplicate]

I wants to copy a table structure along with data dynamically using SSIS 2012 from a DB server to another DB server. The server and database exist physically. The user would provide 5 parameters. ...
5
votes
2answers
8k views

Importing a large column (8000 chars) from Excel using SSIS

I'm trying to set up a regular import of an excel spreadsheet that we get from a vendor. I'm using SQL 2008 R2 SSIS to import it into a table. The problem connection manager is an OLE DB connection ...
0
votes
0answers
25 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 ...
0
votes
0answers
119 views

Failed to execute IS server package because of error 0x80131904 … System.ComponentModel.Win32Exception: The handle is invalid

I have an SSIS package that is executed every 30 seconds by a SQL Agent Job. Every few days, an execution will fail with this message in the Job History: Failed to execute IS server package ...
1
vote
1answer
64 views

SSIS Custom Task with a default Task UI

I followed the tutorial here to build a very simple task and was able to get that task to work. Here are my current tools: Sql Server 2012 Visual Studio 2013 (project is compiled in .net 4.0) Sql ...
1
vote
0answers
44 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
1
vote
0answers
128 views

Oracle 11g SSIS SQL Server 2014 Truncation

We have a nightly SSIS job which downloads data from a Vendor's Oracle system into our SQL Server 2014 system using Oracle's Wallet. On some tables, we've noticed that some VarChar columns have the ...
0
votes
0answers
28 views

SSIS Package Not Populating Excel Correctly

I have an SSIS package that populates the details tab of an excel file. Once it is populated there are two pivot tables that derive data from them. I made a change to the Excel file to add two new ...