Stack Overflow
Stack Overflow

Questions tagged [ssis-2012]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2012 is a part of SQL Server 2012 Data Tools

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

1375 questions
4
votes
2 answers

How to skip the SSIS package failure even if the task fails

An ssis package as shown below;It has to be designed in such a way that if the email tasks fails, the package should not fail. The 2nd precedence constraints is used as completed,so it would skip the start email,in case it fails and package would…
user1254579
  • 3,901
  • 21
  • 65
  • 104
4
votes
1 answer

SSIS Source Format Implicit Conversion for Datetime

Does anyone know of a chart that shows which formats of dates are supported by the different datatypes in SSIS? For example, does DT_DBTimestamp support the format 1-Jan. I tried looking but couldn't find anything. The reason I ask is that I found…
James
  • 117
  • 2
  • 11
4
votes
1 answer

Error adding duplicate key to Dictionary in script task

The script has been running well for ages, but has suddenly started falling over stating Error: 0x0 at (SCR) GetLineageIDs, ProcessDataFlowTask error:: An item with the same key has already been added. at…
TJB
  • 787
  • 1
  • 8
  • 29
4
votes
2 answers

Does the SSIS Package fail ,when one of the container failed

I have a package with 1 container.Does the ssis pacakge fail,If that container fail!? The property FAIL PACKAGE ON FAILURE is false for the container. Does that mean the package fail only if this property set to TRUE,other wise only the…
user1254579
  • 3,901
  • 21
  • 65
  • 104
4
votes
1 answer

In Integration Services Catalogs getting "Cannot access a disposed object." error

In Integration Services Catalogs I configured parameters of the project and pressed OK and then again when I am going to change the parameter configurations by right clicking on project and clicking on configure it gives me below error. TITLE:…
Naim Halai
  • 355
  • 1
  • 8
  • 27
4
votes
1 answer

what is environment variable configuration in ssis and what registry entry configuration in ssis

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I am not understanding what is Environment Variable configuration and what is registry entry configuration in SSIS.
Ghayaz Dot Net Apps Developer
  • 77
  • 1
  • 2
  • 11
4
votes
1 answer

Converting a bit to an int returns a negative value

I am trying to convert a bit field from the source DB into an integer value in the Data Warehouse in a SSIS Project (SQL Server 2012) Select cast([MyField] as int) as TheField from MyTable For some reason this returns 0 and -1, as opposed to the +1…
Andre Doose
  • 161
  • 10
4
votes
2 answers

SSIS 2012 - conditional headers' location

I need to stage a couple of thousands of txt files, using SSIS, into an SQL Server 2012 instance. The issue is that some of the txt files have control checksums in their first two lines and some others don't. If a file has a checksum, its first line…
Piotr L
  • 1,065
  • 1
  • 12
  • 29
4
votes
2 answers

Ignore duplicate records in SSIS' OLE DB destination

I'm using a OLE DB Destination to populate a table with value from a webservice. The package will be scheduled to run in the early AM for the prior day's activity. However, if this fails, the package can be executed manually. My concern is if the…
craig
  • 25,664
  • 27
  • 119
  • 205
4
votes
1 answer

DTExec: The package execution returned DTSER_FAILURE (1) in SSIS package execution

I've got this question within a project in ssis. I had to divide the original project into different packages because this was to big and sometimes it could provoke some problems with the memory. So, in order to link the different packages I'm…
d2907
  • 798
  • 3
  • 15
  • 45
4
votes
1 answer

SSIS 2012 Unable to deploy Package with project level connections

SSIS 2012 Developer Edition:- I made a project with project level connections and all the packages in it are using these connections. When I try to deploy the same project on the SQL server integration catalog, it is giving an error Failed to…
vishnu anil
  • 41
  • 1
  • 2
4
votes
1 answer

SQL Sharepoint Integration thru SSIS using oData Source Connector driver

SSIS SP Connection using OData connector. I was able to connect to Sharepoint site fine and was able to see the data thru preview and all.. but when i execute the task i get below error. [OData Source [2]] Error: The OData Source was unable to…
user1810575
  • 823
  • 3
  • 24
  • 45
4
votes
1 answer

SSIS 2012 - Best pattern for project-package-environment connection configuration

What is the 'best practices' way to configure connections in SSIS 2012 project (that will be deployed to the server)? Documentation and Google shows multiple ways to accomplish this, but which way takes full advantage of the 2012 project/deployment…
davewilliams459
  • 1,679
  • 2
  • 15
  • 24
4
votes
2 answers

Lookup component fails to match empty strings when full cache is used

I have lookup component a with a lookup table that retusn a varchar(4) column with 3 possible values: "T", "R" or "" (empty string). I'm using an OLE DB connection for the lookup table, and have tried direct access to the table, as well as…
JotaBe
  • 38,030
  • 8
  • 98
  • 117
4
votes
1 answer

How do I log Custom Messages to the Execution Report in SSIS 2012

When an exception occurs in the execution of a task, for instance a lookup task fails to find a match, I want to report that exception and the value it was looking for in the Execution Report. How do I do that? Is there a more appropriate way to do…
jlembke
  • 13,217
  • 11
  • 42
  • 56
1 2 3
…
91 92