Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssis-2012]

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.

120 questions
15
votes
1 answer

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.Pipeline: Validation phase is beginning. Information:…
Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
14
votes
2 answers

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 "Test Connection" will halt and fail the package…
Michael J Swart
  • 2,235
  • 5
  • 23
  • 32
12
votes
1 answer

How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?

There are several blogs which claim to categorize SSIS Transforms into blocking (asynchronous), non-blocking(synchronous) and partially blocking(asynchronous). When looking into the specific question: Is multicast synchronous(non-blocking) or…
Thronk
  • 1,388
  • 3
  • 19
  • 39
11
votes
3 answers

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 [create_environment], [create_environment_reference],…
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54
11
votes
3 answers

Error: "To run a ssis package outside of sql server data tools you must install [send successful email] of Integration Services or higher."

NOTE that the title of this qusetion is a verbatim error message specific to this user. The error message illustrates a bug in the dtexec application, which substitutes a user variable into the error message string. In this case, the standard…
Eric Higgins
  • 2,689
  • 1
  • 19
  • 25
9
votes
8 answers

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 people to manipulate SSIS Catalog projects.
Joann.B
  • 411
  • 1
  • 6
  • 16
8
votes
1 answer

Why is SSIS slow to enumerate over many files in a directory and import them?

I have a terribly slow SSIS package. It's quite fast with one file, and reasonably fast with 100 files or fewer. (About one second per file) However, if my directory has thousands of (very small) files, the process drags on terribly slowly. My…
Chris Adragna
  • 351
  • 4
  • 14
7
votes
2 answers

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 way to tell which column caused the failure, for…
User1000547
  • 233
  • 4
  • 9
6
votes
1 answer

DTUTIL performance slower in SQL Server 2012?

We've noticed that since deploying Windows 2012/SQL Server 2012, the performance of DTUTIL has decreased. DTUTIL.exe consumes 50% on each of 2 cores on an 8 GB VM. The same syntax against Win 2008 R2/SQL Server 2008 R2 shows almost no impact on a VM…
JohnW
  • 190
  • 6
6
votes
1 answer

Any Tricks to Better Identify Disabled SSIS Elements?

Does anyone have any tricks they care to share that will help better identify disabled elements within SSIS packages? Ideally there's some manner to adjust the text color to red or or something along those lines, but the default behavior seems…
John Eisbrener
  • 9,547
  • 6
  • 31
  • 65
6
votes
3 answers

SSIS 2012 VS_ISBROKEN on Derived Column

I have converted a SSIS package built in VS2008 to open in VS2010. I have a Derived Column component that fails validation. It works fine in VS2008. Here is the Expression used in Derived Column... FINDSTRING( SecurityDescription,"\n",1) > 0 …
K09
  • 1,454
  • 13
  • 39
  • 61
6
votes
3 answers

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 easily repointing the whole project to different…
onupdatecascade
  • 395
  • 1
  • 2
  • 10
5
votes
1 answer

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(connectionString); var ssis = new…
Paul Hatcher
  • 171
  • 1
  • 4
5
votes
2 answers

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 data to csv [Flat File Destination [187]]: The code…
user3752281
  • 163
  • 1
  • 2
  • 5
5
votes
1 answer

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 AlwaysOn. I have a table that records the current role…
Datsun80
  • 51
  • 1
  • 2
1
2 3 4 5 6 7 8