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
9
votes
2 answers

How to pass parent variable value to child package for reference type: External Reference

I have a ssis project in which the master package contains many child packages. All the child package are invoked with execute package task. I need to pass the "begin date" value from master to all the child package. I know we have parameter binding…
Remi
  • 214
  • 5
  • 17
8
votes
8 answers

SSIS error: delimiter for column "columnX" is not found

This question was asked here before but the solutions proposed don't seem to be working for me. I'm trying to import a text file pipe delimited text qualifier ". The SSIS package is returning the error message delimiter for column "columnX" is not…
marcia12
  • 159
  • 1
  • 2
  • 12
8
votes
1 answer

Unable to fetch "ReadWrite" Variable Value in Script Component of SSIS

In Script Component [Input0_ProcessInputRow], i am trying to fetch "ReadWrite" global variable value and it throws below error. ERROR: The collection of variables locked for read and write access is not available outside of PostExecute. Below is…
VHK
  • 193
  • 2
  • 4
  • 12
8
votes
2 answers

Connecting to SFTP via SSIS

I'm trying to connect to a SFTP server via an SSIS package. The package executes WinSCP with the following connection string in a .txt file: open sftp://username:fc$#6444@example.com:22 However the package keeps failing without being able to…
may-z
  • 127
  • 1
  • 1
  • 6
8
votes
6 answers

Error: An error occurred while skipping data rows

I am getting these errors in flat file connection manager. Error: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source returned error code 0xC0202091. The component returned a failure code…
Allen Jose
  • 81
  • 1
  • 1
  • 3
7
votes
2 answers

migrating ssdt project from visual studio 2012 to 2017 cdc source not opening

We migrated packages from Visual Studio 2012 to 2017 There is no cdc source component in the ssis toolbox: and the cdc source component looks like: And cannot be opened as well. If I create a new Visual Studio 2017 Project it has the cdc source…
dangalg
  • 6,398
  • 4
  • 27
  • 37
7
votes
5 answers

SSIS reading LF as terminator when its set as CRLF

using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is set to CRLF, but when it processes the file, I have a text column that has an LF in it. This is causing it to read that as a row terminator causing…
vin
  • 195
  • 3
  • 13
7
votes
2 answers

How to skip last row in the SSIS data flow

I am using FlatFile Source Manager --> Script COmponent as Trans --> OLEDB destination in my data flow. Source reads all the rows from flat file and i want to skip the last row (Trailer record) updating the database. Since it contains the NULL…
VHK
  • 193
  • 2
  • 4
  • 12
7
votes
2 answers

querying ssisdb to find the name of packages

i was querying the ssis catlog to find out the name of all the packages in the catalog. There are only 6 packages in the Folder1 project,but the query gives 9 records 1. SELECT P.NAME FROM SSISDB.internal.projects PRJ INNER JOIN …
user1254579
  • 3,901
  • 21
  • 65
  • 104
7
votes
4 answers

Source control in SSIS and Concurrent work on dtsx file

I am working on building a new SSIS project from scratch. I want to work with couple of my teammates. I was hoping to get a suggestion on how we can have some have some source control, so that few of us can work concurrently on the same SSIS project…
imba22
  • 651
  • 1
  • 13
  • 25
7
votes
1 answer

Is Microsoft retiring, discountinuing or deprecating SSIS OLEDB provider with ODBC?

There were announcements back in 2011 about Microsoft SQL Server OLEDB access going retire, now I heard it has been deprecating starting SQL SERVER 2014? However it is not apparent from MSDN pages linked below about depreciated features in SSIS…
Narinder Sharma
  • 369
  • 1
  • 5
  • 14
7
votes
1 answer

Cannot use a sensitive project parameter on SSIS 2012

In SSIS 2012 I am trying to use a sensitive project parameter for an OLEDB connection for oracle. It works perfectly with the Sensitive property set to FALSE (in Project Params Designer). But I do not want the password to be visible like that. As…
Vick
  • 71
  • 1
  • 2
7
votes
6 answers

Error: 0xC0202009 at Data Flow Task, OLE DB Destination [43]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21

My source is a TXT Flat File Source, the Destination is of type OLE DB. (see image) I found a very basic tutorial on Code Project to create a package. I finished the steps but when debugging I get a strange error(bellow): Can someone give an…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
6
votes
4 answers

Is it possible to Decompile and read an SSIS package code?

I am working on a project which was owned by a different person. He created a job to update bunch of fields in handful of tables in SQL server. That job was based on an SSIS package. Now I have the DTSX file and the disabled job. When I tried to…
Rick
  • 1,392
  • 1
  • 21
  • 52
6
votes
2 answers

Executing SSIS package gives System.IO.IOException

I am trying to execute the package and every time I see the following error. Especially when I execute the data flow task. Error : System.IO.IOException: The process cannot access the file 'C:\PPE_OVERRIDES.ispac' because it is being…
user10260750
  • 83
  • 1
  • 5
1
2
3
…
91 92