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

SQL Server error - error code 0xC0208449 while running package

After executing the SSIS package I got the following error sql server error error code 0xC0208449 I am running the package in verbose mode and got this is the full package log: Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0…
krishna kumar
  • 33
  • 1
  • 4
3
votes
1 answer

Make SSIS package use Package Configuration(.dtsConfig file) instead of Variables

I have created a SSIS Package. I want to use Variables for development purpose in my local. But, When I move this Package to QA, I want to make use of the XML Package Configuration file(.dtsConfig) so that it will use values specific to environment.…
Rasmita Dash
  • 917
  • 5
  • 15
  • 28
3
votes
2 answers

How to handle NULLs/Blanks in SSIS

I am building an SSIS package to load a flat file(CSV) to SQL server. I am getting the below error when I try to insert into the column state_code (char(2)) to the SQL server. If I change the destination datatype to Char(4), the package executes…
Damodara Lanka
  • 51
  • 2
  • 9
3
votes
3 answers

SSIS Excel File issue - Failure creating file

I have SSIS package that grabs excel file and load it to sql table .i get the following error when i run it. I have tried to make run on 64 bit to false. That did not work i also have installed 64 bit access driver engin . That did not help…
MJ8
  • 185
  • 4
  • 19
3
votes
1 answer

How can I loop though columns by name in an SSIS Script component?

I'm loading a pipe delimited flat file into a staging table. During the load process an SSIS script component performs some operations on a row. It may set a flag in one field based on values in another field, add a prefix to certain columns, or…
DataWriter
  • 1,010
  • 1
  • 10
  • 25
3
votes
1 answer

Execute Process Task Doesnt Display Text | SSIS

I have a Foreach Container in which I have a Execute Process Task . I have many Console.WriteLine() statements in it. The 3 images highlighted in the image can be used to get output from .exe . I declared a variable in package to get error message…
Sai Bhasker Raju
  • 531
  • 1
  • 7
  • 20
3
votes
2 answers

SSIS:File System Task 'Could not find file'

I am working on a SSIS project that download a file via web and upload the data in sql server then after that move the downloaded file to another folder. Here is an image for a clearer picture I have a variable: Source_Folder with a…
Vian Ojeda Garcia
  • 827
  • 4
  • 17
  • 34
3
votes
1 answer

Loading SSIS Package Programmatically in C#

I'm loading a ssis package from my application which works fine. However, what I'm trying to work out and failing miserably is that the package executes in 1 second (which is great) but the loading of the package takes 9 seconds. Working locally…
S Osborn
  • 87
  • 1
  • 5
3
votes
1 answer

SSIS The variable cannot be found

I want to execute package from visual studio solution Code: private Microsoft.SqlServer.Dts.Runtime.Package pkgPaquete; private Application appAplicacion; public DTSExecResult EjecucionPaquete(string str_Paquete, List < CatVariablesEtl > Vars =…
Gerardo
  • 369
  • 2
  • 6
  • 14
3
votes
2 answers

Run SSIS Package after checking entries in database table

Background I would like to load data for 8 tables from Source (This gets data from some other place) to Target. I have a control table in my source that maintains entries every time a table is loaded. So before I start my SSIS package, I need to…
Venkat N
  • 31
  • 3
3
votes
1 answer

Changing format of columns in CSV before loading to SQL server database using SSIS

I am trying to load a csv file in a SQL Server database table using SSIS. Currently before loading the file we are opening the file in excel and changing the format of the column B from General to Number. (if this is not done, incorrect data for…
Ajay
  • 31
  • 2
3
votes
1 answer

SSIS CDC with Oracle 11g

I was wondering if I can use SSIS, as an ETL tool to extract data from Oracle 11g and load it to another Oracle 11g destination, and apply CDC. I have used SSIS CDC with MS SQL; however, I had to enable CDC on the database so I was wondering if I…
user2597012
  • 581
  • 4
  • 9
  • 28
3
votes
2 answers

SSIS using variable in Lookup Transform

In the Lookup Transformation , I specify a reference data set to use as follow: SELECT DISTINCT Client_ID FROM dbo.CLIENT WHERE (ENROLLMENT_DATE >='2016-07-01') AND (DE_ENROLLMENT_DATE <='2017-06-30') If I want to replace the hard-coded…
Ice
  • 429
  • 2
  • 6
  • 19
3
votes
2 answers

Convert String to Int SSIS

I have an string of original source and into destination table It was decimal(5,2), I try to change it with a rule But when I run task It always fail, can someone help me what is wrong there? Update I also try (DT_DECIMAL,2)TRIM(NAME1) but It…
Gerardo
  • 369
  • 2
  • 6
  • 14
3
votes
2 answers

Change data length using SSIS DerivedColumn

I´m reading .csv file to paste into sql table but I get advertesiment into a column It occurse because my destination table have "MOLDE" with string(50) and source have string(255) How can I change "MOLDE" length to get only 50 first values So I…
Gerardo
  • 369
  • 2
  • 6
  • 14
1 2 3
…
91 92