SSIS 2012 is Microsoft SQL Server Integration Services 2012, and is part of SQL Server 2012. 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.

learn more… | top users | synonyms

0
votes
1answer
39 views

SSIS slow performance to insert short rows

(Edit: I changed the post after some more explicative tests) I'm experiencing a lack of performance between a SSIS server (name: Server1) and MSSQL server (name: 7551) when my ETL inserts rows of ...
1
vote
0answers
31 views

Validation Errors in SSIS Package when columns are mapped correctly

I have a SSIS package that I am working on. As soon as I open the SSIS package I am given the following error: Validation error. Populate Organisations Table: Organisation Table destination: '...
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
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
22 views

Calling a SQL Server 2008 R2 stored procedure from SSIS 2012 Execute SQL Task

We have a heterogeneous SQL Server environment including SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. In one 2012 instance, we have an administrative database that we gather metrics data ...
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. ...
0
votes
1answer
42 views

data validation Datawarehouse ETL

Need a suggestion from Datawarehouse and ETL experts. I have a project which has bunch of fact and dimension table, and we wire the facts using surrogate keys to dimension (religiously following ...
0
votes
0answers
191 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 ...
0
votes
0answers
30 views

SSIS Package Error Unable to locate reference column

I have an SSIS package that worked fine until today. For some reason I am getting this error: [UpdateCurrencyRate by MaxTickTime of DAy [2658]] Error: Unable to locate reference column "Currency"...
3
votes
1answer
51 views

Changing database name based on project environment

I have three environments for our BI project (DEV, QA, PROD) and two databases in each environment, source(EDB) and target(EDM) DEV environment: Source = EDB_DEV Target = EDM_DEV QA environment: ...
0
votes
0answers
34 views

How to add SFTP task in toolbar in SSDT 2012

I want to add SFTP Task same like given in https://ssissftp.codeplex.com/documentation link. I tried the same steps and then refresh the toolbar but couldn't see SFTP task. I executed PowerShell ...
1
vote
0answers
15 views

Default Binding and Default Schema is coming blank in local db, after running SSIS package

I am trying to copy database from SQL server 2012 which is hosted on AWS, to my local SQL server 2012 Database, I had tried couple of ways to perform this task, keep on getting similar issue with all ...
1
vote
1answer
216 views

SSIS ODBC: Mapping result set columns to variables returns error “Value does not fall within expected range”

In SSIS 2012, I'm using an "Execute SQL Task" to call a stored procedure that returns a single row with two columns. I'd like to map that result set to two SSIS user variables. Should be easy, right?...
3
votes
2answers
146 views

SSIS - How to parse extensions from path-filename strings

I'm importing a large set (126M rows) of file data from CSVs. Import works fine, except I'm trying to derive a column as I import rather than trying to script it out afterward (due to the number of ...
3
votes
1answer
110 views

Starting SSIS Package through SSIS Catalog

I've developed an SSIS package to load files but it is behaving very strangely. I can kick off the package running start_execution on the SSISDB only when I log directly onto the server. Kicking it ...
5
votes
1answer
96 views

How can I restrict the version of the target DB instance in a SSIS package?

How can I restrict an SSIS Package to only execute on SQL Server 2012? Is there a built-in way to do this (metadata?), or do I need to do a query? (Possibly belongs in a new question): I can get ...
0
votes
0answers
95 views

Error executing SSIS package using SSMS in SQL Server 2012

I am new to SQL server and SSIS packages. I have a simple SSIS package that loads data from Oracle table into SQL table using linked server. But when I execute it using SSMS as scheduled job I am ...
0
votes
1answer
57 views

Change database used for SQL Server Integration Services logging

The SQL Server Best Practices Analyzer noted that my Integration Services' logging table is in a system database. It recommends that I move this to a non-system database. (See here) How do I make ...
9
votes
1answer
710 views

Problem creating a transaction in an SSIS package

I'm working on a package that needs to use a transaction but I'm currently getting the following error: SSIS package "CATS-Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS....
4
votes
2answers
145 views

Is there any way to tell which derived column failed?

In an SSIS dataflow task we have a derived column transformation with approximately 100 columns (basically converting raw input string data into typed variables). When this task fails, is there any ...
0
votes
0answers
40 views

Change SSIS package location

My SSIS Package are located in shared drive with a long path name. To make the packages easier and not to remember long path name, I use "Map my network drive" option and use X: drive as an alias to ...
1
vote
0answers
24 views

How do I save my preferences after moving components around in the SSIS Toolbox?

I'm working with SSIS 2012 (SQL Server Data tools), which runs in the VS 2010 Shell. This is my first time working on a project that required us to install some 3rd party SSIS components. (SSIS-...
1
vote
1answer
256 views

SSIS Blocking itself with IsolationLevel read Uncommited and TransactionOption supported

My Project components have IsolationLevel = ReadUncommitted and TransactionOption = supported. My query is a select on table Y verifying if not exists in table X and the result is written to table X. ...
1
vote
1answer
152 views

VARCHAR2 should perhaps be DT_WSTR when working with SSIS against a Oracle Database?

When using SSIS with Oracle database, it seems to always assume that a VARCHAR2 maps to a DT_STR. However, if my Oracle encoding is set to AL32UTF8, I should be able to store any unicode character in ...
0
votes
0answers
44 views

What does a blank DQS Status column mean?

I'm attempting to use a DQS Transformation in SSIS to harmonize geographic data. For each column being cleansed, there are three output columns- _Source, _Output and _Status. The _Status column ...
1
vote
1answer
95 views

Which technology to synchronise SQL Server and MySQL data?

Which technology should be used if I want to move my data from SQL Server to MySQL server when data is entered to SQL Server row by row and getting feedback from MySQL server? Should it be 1. Linked-...
1
vote
1answer
67 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 ...
0
votes
1answer
183 views

Issue in installing SSIS MS-SQL2012

While installing the MS SQL Server 2012 Enterprise Edition, everything goes through fine but I'm not able to install Integration Services alone. I get the error as following: The following error ...
3
votes
0answers
174 views

What are the possible causes for an SSIS package execution having an “ended unexpectedly” status

I have a SQL Agent job that runs an SSIS 2012 package every 30 seconds to export a small amount of data to a CSV file. There is often nothing to export, but when there is, the business wants it done ...
2
votes
0answers
1k views

How can I eliminate false “connection string format is not valid” messages from SSIS log?

I have a project that uses the SSIS catalog with project-level connection managers. The connection managers' connection strings are overridden at the server using a project parameters file, to enable ...
1
vote
0answers
82 views

Is There A Benefit To Using SSIS Packages Over Linked Servers?

We have a new head DBA, and he has decided he does not want us to use linked servers for development moving forward. In addition he would like to replace all existing code that uses linked servers to ...
1
vote
1answer
4k views

SSIS package hits “login failed for user” when simultaneous operations occur against the same target database

Quick summary We have been working on migrating our library of SSIS packages from SQL Server 2008 hosted on physical Windows Server 2003 to SQL Server 2012 hosted on virtual Windows Server 2012. The ...
1
vote
0answers
902 views

SSIS Package Deployment Failure using SSDT

SSIS fails almost immediately on the final "Deploying project" step of the Deployment Wizard (Package Deployment Model), using Visual Studio 2010 (SSDT) connecting to a SQL 2012 Server: Failed to ...
2
votes
0answers
58 views

SQL Sever Agent Logging

I have created a SQL Server agent job called TestJob which executes an SSIS package called CommunityPackage.dtsx. I have also configured "SQL Server Logging" to sysssislog table for the SSIS package,...
-1
votes
2answers
323 views

How to format SSIS Expression for weekend

I have the following format to account for weekends while naming an excel output. How do I get only the date and not the full startime formatted like 20150429? ((DT_I4)DATEPART("weekday",@[System::...
2
votes
0answers
1k views

Why does an SSIS package fail when executed from the IS Catalog?

When executed via the SQL Server Agent under the same user context, is there any reason a package would successfully run when using the file system (i.e. DTExec.exe), but fail to execute when launched ...
0
votes
1answer
416 views

SQL Server 2012 SSIS : retrieve line number in Flat File Connection Manager

I'm developing a ETL, that uses a FFCM to parse data from a csv and loads it in a SQL Server table. Some float data aren't parsing properly, so I need to see the result in the table and get back to ...
0
votes
1answer
2k views

SSIS Merge Join Error [closed]

I have a simple data flow. I'm trying to join two sets of data from two different databases. The TXT database is collation SQL_Latin1_General_CP1_CI_AS. The other dataset (Cost) is coming from ...
3
votes
1answer
420 views

SSIS 2012: What rights are needed to connect to SSDB via DMO

I'm trying to connect to the SSDB catalog to execute a package using the .NET object model e.g. using Microsoft.SqlServer.Management.IntegrationServices; var sqlConn = new SqlConnection(...
2
votes
1answer
1k views

Error while running SSIS Package job in SSMS

Error while running SSIS Package job in SSMS Hi! A SSIS package named "My_Package" has been scheduled as a job in SSMS to be executed daily at 5:00 AM daily. SQL Server Version : Microsoft SQL ...
0
votes
1answer
194 views

SSIS Package fails to “Transform File and create output file”

I have an SSIS (2012) package which was written by one of the developers. I've been tasked to with fixing the error. Each time the package is run I receive the following three messages indicating the ...
1
vote
1answer
204 views

How to identify where a package execution has spent most of the time?

Team BI has a package deployed as a project on SQL Server 2012. How can I find how long a package takes to run on a daily basis, and where it has spent most of the time? I know that the catalog....
0
votes
1answer
82 views

SSIS Condition that include two connections/data bases

In a SSIS package , I need some sort of condition that include two connections. The simplified problem is: A simple CSV import to SQL Server, DB1, table 1( col1, col2 ). I need to populate table 1 > ...
1
vote
1answer
4k views

SSIS export to CSV Flat File Destination task, error The code page on input column is … and is required to be

I get this error on a File Destination Task, do you know what the cause is and how to fix it ? Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at export ...
1
vote
1answer
1k views

SSIS Package Validation Error email task when attaching file created by previous task

While running in debug mode an SSIS package I get the folowing error. "file ... does not exist ...", but the file is created by a task earlier in the process, so most probably it will exist at ...
3
votes
2answers
4k views

SSIS 2012: The environment reference n is not associated with the project

I have a package that I am updating. The package is executed by a Job Agent job. After deleting the package and then deploying the new version, I run a script that executes any necessary [...
3
votes
1answer
1k views

Verify if user has read access to a table

I'm developing an ETL, whose extract step must read data from a table. There are times that my user's access to that table is revoked. So, to avoid the ETL failing, before reading the table I must ...
1
vote
0answers
330 views

Adding Web Reference to Script Task makes the SSIS package invalid.

Web Reference makes the SSIS package invalid. Within my SSIS package-controlflow I have a script component and within this component whenever I add a Web reference and close editor, script ...
1
vote
1answer
2k views

SSIS - insert system date variable as a execute sql task parameter

I am trying to insert the system:starttime variable into a table by passing a parameter into an execute sql task. I dont have much knowledge of SSIS data types, and I am currently having trouble ...
2
votes
3answers
2k views

Scrubbing sensitive data

I am looking for an automated solution to scrub sensitive data from my prod environment to my DEV and DEVINT environments so that I don't have to write lots of code to get this done. Does anyone know ...