Stack Overflow
Stack Overflow

Questions tagged [ssis-2005]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2005 is a part of SQL Server 2005 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

35 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 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

Date format changed in error output text file

I have a file to be loaded into SQL Server 2005 using SSIS 2005. The file has a date field. The values are like '12/01/2010 16:38:51'. Some of the rows in the file are wrong and will be redirected to a text file. But in the text file, the date will…
thotwielder
  • 1,563
  • 7
  • 44
  • 83
0
votes
1 answer

SSIS 2005 Error while using script component Designer: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)"

I am trying to debug a dts package in SSIS. I have a script component designer where I pass in the input variables to increment a counter. When I try to msgbox the counter value, I get the following error. Error: 0xC0202009 at STAGING1 to…
Klaus Kjeldsen
1 2
3