Stack Overflow
Stack Overflow

Questions tagged [ssis-2008]

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

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

448 questions
0
votes
0 answers

SSIS customised Slow Changing Dimension

i have 50 customer and i am asked to design a SSIS package to handle the Slow Changing Dimension. i have designed the entire package for it. The real challenge for me. How can i make sure if any new customer file arrived for the first time, it will…
Rohini Mathur
  • 431
  • 1
  • 5
  • 19
0
votes
1 answer

How to Pass to many records as parameter to a SP in SSIS

I'm truncating a table(Say 'X' table ) and inserting values on some conditions into that.Then after i have to select those inserted values, and delete those in another table(say 'Y' table),which is present in other server by executing a stored…
Bharath
  • 31
  • 1
  • 4
0
votes
1 answer

ssis transaction with out Msdtc

One of the packages is going to implement using SQL Server Integration Services SSIS Transactions without MSDTC. The Execute SQL task has placed ,before the data flow(Df_insert) for begin transaction.There are several update steps and index…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

FTP task SSIS for moving files from linux ftp to windows share?

Can we use FTP task for sending files from linux ftp to windows share?If so can anyone help me with the syntax as i will be using the operation as receive files.
user2941762
  • 61
  • 1
  • 1
  • 9
0
votes
2 answers

How to receive "output" variable of SP in SSIS to count how many data entered into conditional IF

I have an SQL Procedure like below: CREATE PROCEDURE [dbo].[ExampleSP] @ID int, @name varchar(30), @Counter int output AS BEGIN SET NOCOUNT ON; ----…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

How to count rows in SSIS based on specific conditions?

I have a Stored Procedure in SQL Server 2008 like below. ALTER PROCEDURE myStoredProcedure @Id int, @hin varchar(30), @checkValue varchar(30), @CounterDeceasedPatients int=0 OUTPUT insert into myTable values (@Id,…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

SSIS expression similar to case statement

I need to write an expression for derived column. My column name is 'status'. what is the equivalent expression in SSIS for the below condition? Case when Status Like '%Open%' then 0 when Status like '%Won%' then 1 when status like…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
0 answers

How to preserve leading zero in OLE DB Source output column?

I am using SSIS (SQL Server Integration Services) and using the Ole DB Source Component. One of the columns is specified as DataType: DT_NUMERIC, Precision: 18, Scale: 4. When the number to the left of the decimal is zero, the zero gets…
Jin Kim
  • 16,562
  • 18
  • 60
  • 86
0
votes
0 answers

slowly changing dimension not opening , system getting hang every time while trying to open

I got one package to enhance some of the functionality of SSIS package, but while I am trying to open SCD to know the attributes mapping and keys mapping, SSIS package gets hang everytime, due to that I am unable to investigate the other things in…
Mayank vishnoi
  • 1
0
votes
2 answers

Full Cache lookup is not matching record that should be matched

In my package, when I lookup a value based on FULL Cache Mode, it goes to no match output even when the datatype and value is same in lookup table and source. There is no duplicate row as well. When I put 'No Cache' mode, it's matching correctly.…
SChowdhury
  • 163
  • 1
  • 11
0
votes
1 answer

How to compare 2 MS Excel file structure(Columns) using SSIS

I have a requirement in which I need to compare columns of 2 Excel files. If columns are matched, then proceed with next steps of SSIS package. If columns are not matched, SSIS package should stop. Please help.
SG_
  • 45
  • 7
0
votes
1 answer

SSIS - Sub query getting an error

I have the below script in the Source Editor in a SSIS package and I get an error. I change to a Select * and it works. I'm not sure why this is not working. It works in P/SQL. Any help would be appreciated! This works in my package: select * from…
Mr John
  • 231
  • 1
  • 3
  • 18
0
votes
1 answer

How do i traverse files through folder using for loop container in SSIS

There are so many examples for traverse files through folder using foreach loop container but i want to know how to traverse files using For loop container please help me
prabhu sundararaj
  • 15
  • 5
0
votes
0 answers

How to get the execution result of a stored procedure

I want to capture the execution result in a variable. If the procedure fails due to a deadlock or error how do I capture it programmatically. The scenario is I have a SSIS package where I call a stored procedure. Now the stored procedure sometimes…
Ranit Das
  • 64
  • 1
  • 11
0
votes
1 answer

SMTP Connection for SSIS 2008

I am new to SSIS and trying to figure out a way to set up a SMTP connection for an email. I did some online research about this but didn't find a clear explanation on how set up a smtp connection. Can I use outlook 2013 to send an email from SSIS?…
mehtat_90
  • 586
  • 9
  • 29
1 2 3
…
29 30