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

3
votes
2answers
30 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
65 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
89 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
47 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
27 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
157 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, ...
4
votes
2answers
82 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 ...
1
vote
0answers
14 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
18 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. ...
1
vote
1answer
136 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
53 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
26 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
63 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. ...
1
vote
0answers
42 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
106 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
93 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 ...
1
vote
0answers
624 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
56 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
2k 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
614 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
52 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 ...
-1
votes
2answers
211 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? ...
1
vote
0answers
650 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
234 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
939 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
200 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 ...
2
votes
1answer
961 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
146 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
157 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 ...
0
votes
1answer
68 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
3k 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
793 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 ...
2
votes
1answer
2k 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
259 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
2answers
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 ...
10
votes
2answers
2k views

How do I Continue After a Failure in SSIS

I want to implement something like the following: In this package, I want to loop through a list of database names, dynamically modifying connection manager settings. However, the first failure on ...
3
votes
3answers
4k views

Permission to view execution report in SSIS Catalog

We are currently using SSIS 2012. Is there any way for a user to view execution reports under SSIS Catalog without being ssis_admin or sysadmin? This is for production environment and we don't want ...
1
vote
1answer
259 views

How to unpack comp3 in SSIS

I'm receiving a file from a mainframe group that includes Comp-3 packed decimals and I'm having some problems converting it to a normal decimal. For the SSIS Setup I have the following: Flat File ...
0
votes
2answers
4k views

SSIS Package truncation and possible data loss (error code: 0xC020901C)

Good morning all, It's been 2 days now trying to figure out how to solve this issue, still no answer. Maybe you can help me out. Here is the thing. I have created an SSIS package to import data from ...
1
vote
1answer
246 views

SSIS foreach loop xlsx files

Hello I see similar questions has been ask before but I am having a bit of trouble with this issue, this is using excel 2013 data files and sql server 2012. I have a foreach loop container This for ...
1
vote
2answers
4k views

Is it possible to use a temp table in a data flow source?

I have a data flow in a 2012 SSIS package where I'm trying to use a temp table as the data source. I'm using an OLE DB data source with a SQL Command Data access mode. My code looks like this: ...
4
votes
1answer
2k views

Execute T-SQL Only If AlwaysOn Database Is Primary

Little background on the system. It is SQL Server 2012 AlwaysOn Availability Group with 1 primary and 1 secondary. I have been following this article (SSIS with AlwaysOn) to make SSIS work with ...
0
votes
0answers
1k views

How can I resolve timeout errors in SSIS around midnight every night?

I find a pair of these in my Application Event Log a little after midnight every night: The SSIS Execution Process could not write to the IS catalog: MyServerName:SSISDB Error details: Unable to ...
0
votes
0answers
51 views

SSIS Foreeach Container Not Failing

I have a foreach container which is looking in a share directory for files to then send on to another location. When I ran this as part of a job the package was running successfully however the files ...
2
votes
1answer
238 views

Sql job fails when connection string is updated with port number,where as it succeeds without port number

We have a sql job which creates package dynamically based on metadata config values.We have specified connection string of servers in below format. Source : sat\sql2012,5000 ...
3
votes
0answers
568 views

DTUTIL to package store

I am trying to deploy a package to a project in my SSIS catalog and am using the following command: dtutil /FILE C:\Changes\ReceivedEDI.dtsx /DestS MARSQL12 /COPY ...
0
votes
1answer
203 views

apply cdc to existing data warehouse

I'm building an education data warehouse. I have various dimensions that i would like to track changes to i.e. DimStudent, DimClass, DimCollege, DimExamPaper etc. etc. My solution currently drops ...
1
vote
1answer
4k views

SQL Server 2012 Agent Job not providing full failure message for SSIS Packages

(this was also posted at http://www.sqlservercentral.com/Forums/Topic1576641-2799-1.aspx) We are having an issue with 2012 SQL Servers not reporting why a job has failed, this is happening for jobs ...