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

1
vote
1answer
122 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 ...
1
vote
2answers
20 views

Issue with getting data from XML file by using SSIS

I'm getting the data from XML file on the internet like below: <?xml version="1.0" encoding="ISO-8859-1"?> -<exchangerates type="Exhange rates" xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
0
votes
0answers
9 views

How can I transfer a table with unknown columns from SQL to Jet

When supplied with a table name in a variable (e.g. "SHIPPING"), how can I use SSIS to pull data from that table in SQL Server and push it to a Jet database into a table with the same name and data ...
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
266 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
21 views

SQL Server 2014 (12.0.4439.1) to SP2 (12.5000) service start failure

In what seems to be eerily familiar to the oh-so-famous SSISDB SP1 fiasco, I've hit a snag while upgrading our DEV server to SQL 2014 SP2. The base version was SP1+CU5 (12.0.4439.1). We have SSISDB ...
4
votes
0answers
52 views

Large Variation in Bulk Insert time

So I have a simple Bulk Insert process to take data from our staging table and move it into our datamart. The process is a simple data flow task with default settings for "Rows per batch" and the ...
1
vote
0answers
19 views

How can I get the actual SSAS error when processing a cube from a SQL Agent job?

I have a SASS cube on one server and a SSIS package on another server that triggers processing the cube. The SSIS package is executed via a scheduled SQL Agent job. I have enabled error reporting for ...
0
votes
1answer
68 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 ...
0
votes
0answers
6 views

Generic Rowset Error Causing SSIS package to Fail

A vendor-provided stored procedure on a SQL 2012 instance and DB in compatibility mode 110 performs several ETL steps and returns a single resultset from a temp table. Execution of the sproc takes 3-5 ...
0
votes
0answers
40 views

SSIS all executions report query

At first - hello DB specialists! I'm trying to prepare a query, which in result give me a specific information about SSIS jobs and errors if occurs. I found some hints on google and finally I have a ...
1
vote
1answer
28 views

location of DTSX package

I need to know the location of a DTSX package which is stored in "file system", It is visible under Stored pacakges-->filesystem-->Package1 in Integration services . I tried to do a windows search ...
0
votes
1answer
31 views

SSIS: Import Excel file to SQL Server

Is there a Excel version for this article? I have been searching for this past days but there is no luck. https://www.simple-talk.com/sql/ssis/ssis-basics-introducing-the-foreach-loop-container/
0
votes
1answer
180 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 ...
0
votes
2answers
983 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 ...
1
vote
1answer
325 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 ...
0
votes
2answers
34 views

Passing a list to a SQL query in SSIS

I need to be able to pass a list of undefined size that will contain numbers like so ('1900'),('1920'),... to and OLE DB source in SSIS. as of right now I am trying a lot of different things that ...
1
vote
1answer
1k views

Error when trying to deploy SSIS package

I am trying to deploy my 2012 SSIS project to the Integration Services catalog on the SSIS server (also 2012). I am getting the error below. I checked that there is plenty of space in SSISDB and ...
1
vote
1answer
56 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 ...
7
votes
1answer
76 views

SSIS proxy/credentials not working from within SQL Agent job step

I have been looking around and found similar questions but nothing specific to what I am having trouble with. Problem: I cannot get the SSIS proxy and SQL credentials configured correctly to ...
3
votes
2answers
10k views

SSIS OLE DB Error on package execution

Good day, I have an SSIS package that runs on scheduled job for a while now. all was okay, until very recently, i started receiving some failed job executions. When I investigated it, I found the ...
1
vote
1answer
607 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; ...
1
vote
1answer
38 views

Integration Services License requirements [closed]

Not sure this is something which people will know on here are not. We currently have a BI setup where we have Integration services on one SQL instance and the data warehouse database on a separate ...
1
vote
0answers
22 views

SSIS: Is it possible to process excel file with dynamic column headers

SSIS: Is it possible to process excel file with dynamic column headers. For instance: Excel file has 5 columns and we process that and save data in a table for all the 5 columns. Now, the scenario ...
0
votes
1answer
528 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
2answers
131 views

How to change Zeros ( 0 ) to NULL in SSIS?

I would like to change some Zeros into NULL using SSIS 2008. In that context I tried "conditional split" where I have set the columns test in question with the following expression: REPLACE((DT_WSTR,...
2
votes
0answers
34 views

SSISDB Retention Period

I have looked into articles to get the size of SSISDB down. One good way to do this was set the retention window for logging lower, currently down to 150 from the default of 365 days. I would like ...
1
vote
1answer
4k 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
181 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 ...
0
votes
1answer
20 views

How to import long strings at different column positions with SSIS?

Our provider stores our survey data in the following format Columnnames for each survey Example: |v1 |v2|v3|t1 |CompanyName|v1|v2|v3|t1| Data for each person One dataset for ...
1
vote
0answers
27 views

Retrieve data from OLTP MySQL to SQL Server DWH using SSIS

I'm running a BI solution currently reading data from an OLTP SQL Server 2008 to a SQL Server 2012 data warehouse. The ETL phase is implemented with SSIS and runs twice a day. This phase relies on a ...
1
vote
4answers
12k views

SSIS Package Truncation may occur due to inserting data from data flow column

I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database. The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 ...
1
vote
1answer
32 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
240 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 ...
3
votes
2answers
251 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 ...
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
57 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. ...
2
votes
1answer
32 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
154 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
21 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
0answers
18 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
60 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
65 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
31 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 ...
3
votes
1answer
290 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
65 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
244 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
34 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
39 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 ...