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

Merge join or Lookup which is cost affective in ssis

I need to join 2 tables with more than 20 million reocrds.Which of the below mentioned solution is good 1 one Oledb componet and a lookup component or 2 Two oldeb componets,2 sort componets and a merge join componets
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
2 answers

SSIS Lookup Failure

In an ssis Dataflow there is a lookup component ,which lookup on a table with 18 million records.I have configured the lookup with full cache. Default buffer size :20485760 Default Buffer Max rows: 100000 The lookup join is based on an ID…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

How to Convert the mentioned Excel format to the mentioned table format

I have an excel file as shown below I need to load these data into a table with below mentioned format How to achieve this in SSIS.I mean all the column header would insert as row element as shown below.Is it using pivot ?
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

SSIS Expression equivalent to SQL Expression

what is the SSIS equivalent expression(Derived Column component) of the below SQL expression cast(CASE WHEN len(cast(KPI as varchar(3))) > 2 THEN CASE substring(cast(KPI as varchar(3)),3,1) WHEN 1 then left(cast(KPI as…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

SSIS Design Patterns : Converting all T-SQL Task to SSIS components

There is A SUGGESTION to redesign all the SSIS package in a project.The thing is ,at the moment all functionality has been implemented using the T-SQL stored procedures(Execute SQL Task).I have been asked to redesign all those T-sql tasks to ssis…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
2 answers

SSIS - Archive files Task

I am developing SSIS 2008 package. Amongst other things, it processes files located in a drop-off filesystem folder. TASK: After they are processed, files should be compressed and relocated to an archive folder. QUESTION(s): Does anyone know of a…
user1711225
  • 16
  • 2
0
votes
2 answers

Update existing and insert new in SSIS 2008r2

I have two backup databases with 12 months data in one and 10 months data in another.. because of some reasons i can't use 12 months DB. So i need to update 10 months DB with 12 months data(new rows, new entities etc and update existing records)…
hemanth
  • 577
  • 6
  • 17
0
votes
1 answer

how to remove the pop window,which appears when ever trying to open a package in ssis

An ssis 2005 package has been upgraded into 2008.But everytime i open this 2008 package a popup window opens( "welcome to ssis package upgradation wizard").Any sugestion how to disable it
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
2 answers

SSIS Package Variable Set Order

I have an ssis package where the variables are set by database table. In order to re-use code, this package will be run on a weekly basis. But there will also be a need for the use to run it ad hoc. Now I have the code to run the package from the…
Mike
  • 5,918
  • 9
  • 57
  • 94
0
votes
1 answer

Is there a variable which can store other variables of the same type?

I am learning SSIS 2008. I want to store many file paths in separate variables and put them into some "variable that holds multiple variables of the same type". Can I do this in SSIS 2008 ? If yes, then how ?
Steam
  • 9,368
  • 27
  • 83
  • 122
0
votes
1 answer

Milliseconds being rounded to seconds by in SSIS 2008 script task

I'm trying to import some data from one database to another. Everything works fine except for the milliseconds are being rounded off to its nearest second. In my SSIS package, I have a Recordset Destination which stores the result of a query into a…
rageit
  • 3,513
  • 1
  • 26
  • 38
0
votes
0 answers

Use SSIS C# script to run SQL plus SQL string

I am attempting to use a script task (C#) within SSIS (SQL Server 2008 BIDS) and am having trouble sending the actual SQL string to SQL plus. I can get it to take my username and password, but cannot seem to get it to take a SQL string from the C#…
GD1977
  • 1
0
votes
1 answer

Computing value of field based on next row in SSIS

I have a contract table with BeginDate fields but no end date on a SQL Server 2000 database (cringe). I'm using an SSIS package designed in the 2008 environment to move data from this table into a staging db for a data warehouse. I need to compute…
Stickman
  • 138
  • 7
0
votes
2 answers

How can I perform one transaction per input row?

I have a dataflow that has an oledb data source. I then have a script component that performs three web service calls, this has two outputs that are (in effect) synchronous to the input row (one output row per input row), and one output that is…
Erik Funkenbusch
  • 92,674
  • 28
  • 195
  • 291
0
votes
1 answer

SSIS packages deployment

We are running into a deployment nightmare with our current setup : 1 - DEV makes changes to SSIS 2 - All the packages that change have to be uploaded again to MSDB 3 - once the deployment is done we use dtexe /SQL switch What we would like…
Murtaza Mandvi
  • 10,708
  • 23
  • 74
  • 109
1 2 3
…
29 30