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
1 answer

SQL task MDX with parameters. SSIS

I need to create dynamically some local cubes in ssis and i don't know how to use parameters in this query CREATE GLOBAL CUBE test STORAGE 'C:\test.cub' FROM Cube_test( Measure [Cube_test].[Val], dimension [Cube_test].[Date_1] ( level [Date_1], …
LuisSol
  • 41
  • 2
4
votes
2 answers

Unable to set Target Server Version to SQL Server 2012 for Integration Services Project

I'm trying to create a new Integration Services project. By default the project targets SQL Server 2017. I need it to be SQL Server 2012, but the option is not showing up. I have existing projects which have been set to 2012 a while back, but now I…
sanfalero
  • 372
  • 2
  • 18
4
votes
2 answers

How to store a column value into a variable in Data Flow Task?

I have DFT, where I extracting a URL from a table and I need to store that value into a variable. I am using OLEDB Source to connect to My SQL Server and selecting the required columns. Then I have Conditional Split which will split the right URL…
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
4
votes
0 answers

[Vertica][Support] (50310) Unrecognized ICU conversion error

I get following error when i try to load a field from vertica DB which has data type "Long Varchar" using SSIS. [Extract Data from Vertica "Fact_Service_Case_View" [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'.…
Karthik
  • 41
  • 4
4
votes
4 answers

Execute an SSIS Package as a SQLAgent job from C# code and pass a parameter to the SSIS package

I need to pass a parameter to the SSIS package, which is being executed from an SQLAgent job. The job is triggered from C# code. I could not get a definitive answer in the internet. Is it possible? SQLServer Version: 2012 From the C#, I am using the…
turbo88
  • 423
  • 2
  • 8
  • 23
4
votes
1 answer

A buffer failed while allocating 10484320 bytes

When I run the following package, it completes every task successfully until loading into the destination where 0 rows are written. I reduced the buffer size but still didn't work. Any clue on how to solve this. I get the following error…
Rachel
  • 208
  • 1
  • 5
  • 18
4
votes
1 answer

SSIS Deployment: SSIS Package run time error in SQL Server deployment

I am new in working with SSIS on SQL server. I deployed a package to my Test Server and trying to execute in Intergration service catalog to run the package and these are the errors i see every time i run it. I tried to schedule a job to run this…
Nani
  • 103
  • 3
  • 11
4
votes
1 answer

SSIS 2012 Excel Source with Dynamic ConnectionString from Variable

I have a simple SSIS 2012 package with: A Script Task obtains the latest .xlsx filename from a folder and stores the full path in a package-scoped variable: SourceFileExcel An Excel Connection Manager called FUNB to connect to the file An Excel…
Adam
  • 1,932
  • 2
  • 32
  • 57
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
4
votes
3 answers

How to make an IF Statement in SSIS

How can I create a condition in SSIS like below? I know how to create it just in SQL Server Example: IIF(LEFT(MAT,1) = '"', NULL, REPLACE(MAT,'""',''))
Everton Gomes
  • 161
  • 1
  • 1
  • 9
4
votes
2 answers

Concatenating Firstname and lastname as Name and then ommit Firtname and LastName in SSIS

I have a problem statement as below : From a DB source I have a table which has data related to Person. Out of which 3 columns are as Title, FirstName, LastName and I want to replace this as Name before actually putting it to the destination. I…
Avineshkumar Tiwari
  • 89
  • 7
4
votes
3 answers

SSIS Conditional Split Lineage Error

I'm trying to run an Excel table through an SSIS Package and 3 nodes in, it has a Conditional Split. I'm using a previously known working spreadsheet with some data added to it. The error I'm getting specifically is: Conditional Split.Inputs[Split…
Tyler C
  • 573
  • 5
  • 17
4
votes
2 answers

SSIS: Truncate Excel Destination

I am creating a SSIS package that imporr data from a SQL Server Source to an Excel Destination. How can one truncate spreadsheet before run? I tried the following way (using Execute SQL Task with no success.
John
  • 109
  • 1
  • 5
  • 12
4
votes
2 answers

SSIS : Creating a flat file with different row formats

I want to create a flat file output, where format of rows is different. file has header, middle data rows, footer row. file will look Like below H|deptcode123|deptNameXYZ|totalemp300 E|Sam|Johnson|address1|empCode1|........many other…
coder
  • 122
  • 1
  • 13
4
votes
1 answer

Set package path in "Execute Package Task" From Integration Service Catalog in SSIS 2012

I would like to call SSIS package dynamically based on the configuration of various packages. I have deployed SSIS 2012 solution on Integration Service Catalog. At run time I am having the the package name but unable to set the path of SSIS package…
Rahul Neekhra
  • 780
  • 1
  • 9
  • 39
1 2 3
…
91 92