Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssis]

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

SQL Server Integration Services (SSIS) is an ETL processing tool made by Microsoft and sold with SQL Server since version 2005. It is only available bundled with SQL Server and cannot be purchased separately.

SSIS replaces Data Transformation Services, which Microsoft introduced with SQL Server 7.0.

1144 questions
20
votes
2 answers

The value could not be converted because of a potential loss of data

Let me start out by clarifying that this is not a duplicate question, nor a potential duplicate for that matter. I have tried implementing every answer to every single variant that already exists of this problem on StackOverflow and DBA Stack…
Mathias Lykkegaard Lorenzen
  • 579
  • 2
  • 5
  • 13
20
votes
4 answers

how to query SSISDB to find out the errors in the packages?

I have seen this question SSIS 2012 - How to Query Currently Running Packages in T-SQL? It gives me the following script: SELECT E.execution_id , E.folder_name , E.project_name , E.package_name , E.reference_id , E.reference_type , …
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
18
votes
2 answers

How do I grant the privilege of connecting to SSIS?

Attempting to run SSIS packages using dtexec.exe, I got this error message: Could not load package "D:\Filename.dtsx" because of error 0xC00160AE. Description: Connecting to the Integration Services service on the computer "" failed with the…
Jon of All Trades
  • 5,987
  • 7
  • 48
  • 63
17
votes
4 answers

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\Microsoft SQL …
Radhi
  • 323
  • 1
  • 2
  • 9
17
votes
2 answers

"Access is denied" when connecting SSMS to Integration Services

I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name: Connecting to Integration Services service on the computer 'FooDB' failed with the following error: "Access…
James Lupolt
  • 4,278
  • 5
  • 31
  • 46
16
votes
1 answer

Running SSIS package from SQL Agent job owned by a non-sysadmin domain user

I have two SSIS packages that run scheduled overnight (via SQL Server Agent) as part of a larger SSIS deployment, without any issues. Everything is using Windows authentication, and the scheduled job is owned by a sysadmin (well, me) and run as the…
Mathieu Guindon
  • 914
  • 2
  • 7
  • 16
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
14
votes
2 answers

Relating ExecutionInstanceGUID to the SSISDB

The 2012 release of SQL Server Integration Services, SSIS, has delivered an SSISDB catalog which tracks the operations of packages (among other things). The default package execution for solutions using the Project Deployment model will have logging…
billinkc
  • 16,143
  • 4
  • 54
  • 89
14
votes
2 answers

ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?

Based on my analysis, a complete dimensional model for our data warehouse will require extraction from over 200 source tables. Some of these tables will be extracted as part of an incremental load and others will be a full load. To note, we have…
8kb
  • 2,639
  • 2
  • 32
  • 36
14
votes
2 answers

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 options are "tablock" and "no check constraint". The…
Zane
  • 3,530
  • 3
  • 25
  • 45
14
votes
1 answer

Executing SSIS Package from a stored procedure with different user privileges

I'm having issues with allowing my users to execute SSIS Packages in a reasonable manner due to varying levels of privilege required. The scenario: we've created a data warehouse, with two different SSIS packages responsible for loading it with…
Wokket
  • 161
  • 1
  • 6
14
votes
2 answers

How to implement a Set based algorithm/UDF

I have an algorithm that I need to run against every row in a table with 800K rows and 38 columns. The algorithm is implemented in VBA and does a bunch of math using values from some columns to manipulate other columns. I'm currently using Excel…
medwar19
  • 169
  • 4
13
votes
3 answers

SSIS Script Component - How to modify the Output0Buffer

I've a script component which accepts records from SQL Azure database table. The script then invokes a web service, which returns the number of failed and success records. For all the records, I would like to add the Status field which has either…
flybyte
  • 401
  • 2
  • 7
  • 9
13
votes
2 answers

SSIS 2012 Create environment variable fails

I'm working a script to port an Environment from one server to another. I am running into an issue calling catalog.create_environment_variable wherein I get the error "The data type of the input value is not compatible with the data type of the…
billinkc
  • 16,143
  • 4
  • 54
  • 89
1
2 3
…
76 77