Stack Overflow
Stack Overflow

Questions tagged [ssis-2014]

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

38 questions
4
votes
1 answer

How to download SSIS Packages from SSISDB

I'm still fairly new to SSIS. I've figured out how to download packages from a server by connecting to Integration Services. How do I download packages from SSISDB? Background: We have a TON of packages that the previous people created. All…
Rich Uchytil
  • 457
  • 1
  • 7
  • 16
3
votes
1 answer

How to expose an executable error as a message in SSISDB

We are currently calling an executable built using python from a SSIS Execute Process Task run as part of a nightly batch job. This all works fine however when the executable fails only a very basic generic error message is raised with no reference…
jeremyh
  • 612
  • 4
  • 14
3
votes
1 answer

Data Flow failing at last error record - Oracle Destination

I have a simple Data Flow Task that is transferring 1M records from a source to destination. Both the Source table and the Destination table are Oracle tables. The data at the source is composed of two columns Id and Name as shown below - create…
VKarthik
  • 1,379
  • 2
  • 15
  • 30
2
votes
1 answer

Building SSIS 2014 Project deployment model from cmd line

Build SSIS 2014 Solution/project from cmd line is not working Used several scripts with no luck. C:\Users\Source\Repos\ETL "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\devenv.exe" \ETL.sln /build…
user1810575
  • 823
  • 3
  • 24
  • 45
2
votes
0 answers

Text qualifier appears in data when using flat file

I have a flat file connection manager that reads data from a file that I have constructed with a Powershell script. The fields in the file are delimited with a vertical bar (|) and each field is qualified with the ¬ character (mainly because some…
johnmcp
  • 891
  • 1
  • 10
  • 17
2
votes
1 answer

Parse Full Name into separate column Name fields

SSIS project SQL 2014 I have a full name string in a single column including commas as input and I need to parse last name, first name, middle, if they exist into separate columns for the output. Can this be in done in the select? I have seen…
k brake
  • 21
  • 1
2
votes
1 answer

Error 0xC0011008 the package failed to load

I'm facing a strange behavior of SQL Server Agent when executing SSIS packages. I have a job that includes many steps (mainly SSIS packages). Some steps fail mostly every day even the configuration is the same for all the steps. I tried to…
blackbishop
  • 30,945
  • 11
  • 55
  • 76
2
votes
1 answer

SSIS user variable not updating after project is deployed to the catalog

I have a control flow that sets a user variable with an Execute SQL task. Everything works fine in Visual Studio but once I deploy it to the SSIS catalog the variable doesn't seem to get assigned. I'm executing it against the exact same data…
Mike D.
  • 4,034
  • 2
  • 26
  • 41
1
vote
1 answer

IntegrationServices Only Runs Part of SSIS Package

I have a SSIS Package that looks like this: It runs fine via Visual Studio or DTEXEC in command line. I have deployed it, as seen here: When I connect to and run it via C# in my WinForm it only seems to run the 'Truncate Table' task. I comes…
Dizzy49
  • 1,360
  • 24
  • 35
1
vote
0 answers

In Place SQL Upgrade and SSIS

I am planning an in-place upgrade of a SQL server 2014 to 2017. We have many SSIS packages deployed to the server. Anybody know if the upgrade will convert the deployed packaged to 2017 format or will I have to re-deploy them all? I know that if I…
Davin Studer
  • 1,501
  • 3
  • 15
  • 28
1
vote
3 answers

Transpose rows of string values to one column in a dataflow with SSIS

I need to transpose some strings concatenated in one column in a Dataflow but I don't find a suitable solution. I have millions rows like this : Col1 Col2 Col3 1 MyVal1 String1 1 MyVal1 String2 2 MyVal2 String2 2 MyVal2 String1 2 …
user3463579
  • 95
  • 1
  • 8
1
vote
1 answer

SSIS Data Tools for SQL Server 2014 (none of vb.net script tasks are working, even with default code)

I have installed SQL Server 2014 Data Tools. When I add the script task and use C#, it work. But when I add script task and choose vb.net 2012, and then clicked on edit script and save. After that click ok and getting this error message for all…
user3577355
  • 11
  • 1
1
vote
0 answers

How to permanently fix destination column maps in SSIS 2014

I have an SSIS 2014 solution in Visual Studio 2015. The solution has multiple configurations. The solution is under source control in Git. The project is set for project deployment. The issue I'm having is that the column mapping in the…
Hector Sosa Jr
  • 4,230
  • 27
  • 30
1
vote
1 answer

Can the same SSIS ETL Product (Package) work for SSIS for SQL Server 2014 and 2016?

We're building an ETL Product in SSIS. A lot of our SSIS packages have script tasks written in C# script with assembly references to Microsoft.SqlServer.ScriptTask, Microsoft.SqlServer.ManagedDTS etc. Some of our customers may be using an older…
Ash
  • 241
  • 4
  • 15
1
vote
1 answer

How to import a text file with multiple layouts into SQL with SSIS

I'm fairly new to SSIS, any help would be much appreciated! I need to import a comma delimited text file. The rows in the file have different layouts. The value of the first column specifies the layout. For example: Layout 1: Name, Surname, Age,…
Cobus Ellis
  • 51
  • 4
1
2 3