Integration Services

• Topics

  Started by

  Posts

  Last post

• Dds,ata convertion from Progress database to SQL Server 2005 using SSIS

  Hi All, I am new to Progress database and i want to migrate the data from progress database to SQL2…

  Sarath Vellampalli

  1 replies

  14 years ago

  By: Jack Corbett

• Alternative to using a variable in SSIS to hold very large (>4000) SQL statement

  I am using an OLEDB source to get my data in SSIS and use a variable to hold the SQL. The SQL is qu…

  Ells

  10 replies

  14 years ago

  By: Ells

• What is Best (Fast Loading) option for Importing Excel data into SQL Server

  Hi Folks I am trying to design a SSIS 2008 package which will import data from Excel-2007 sheet int…

  devsql123

  2 replies

  14 years ago

  By: Koen Verbeeck

• Warning:...There is a partial row at the end of the file.

  Hello All, During some testing I hacked up an import file to cause my package to fail. It only gav…

  Chrissy321

  4 replies

  14 years ago

  By: Chrissy321

• Configure ODS using Changed Data Capture

  My task is to implement an ODS solution using SQL Server 2008 I have got the following environment:…

  rka

  2 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• Loading Excel sheet into SQL Server Table

  Hi Folks I am looking for design guidelines from you for creating SSIS package to load Excel sheet …

  devsql123

  2 replies

  14 years ago

  By: Koen Verbeeck

• Derived Column - Conditional

  Hello I am new to Integration Services. I am trying to split a table into two tables. To do this I …

  Angelflower21

  2 replies

  14 years ago

  By: Angelflower21

• compare difference of versions of SSIS package

  I often need to compare what is the difference of a ssis package with a previous version. Is there …

  sqlfriend

  7 replies

  14 years ago

  By: Elliott Whitlow

• SSIS Validates each Data Flow when opening Solution - Delay Validation?

  SSIS is Validating each Data Flow when I open a Solution. So far I have 20 of 179 Transformations a…

  Welsh Corgi

  2 replies

  14 years ago

  By: Welsh Corgi

• How to use row number in excel source?

  Hi Friends, i wrote a SQL statement with row number ()(to get the first count) in the excel …

  Charmer

  4 replies

  14 years ago

  By: Charmer

• Datatypes of Excel columns in SSIS

  I have an excel file to process in SSIS. One of the column in excel is having different types of va…

  agg_rakesh

  9 replies

  14 years ago

  By: Koen Verbeeck

• Is it possible to recreate a package based on the one deployed to SQL Server?

  I created an SSIS package about 2 years ago. We deployed it to SQL Server, sceheduled it, and it's …

  mister boom

  8 replies

  14 years ago

  By: Orlando Colamatteo

• SSIS Logging

  Hi All, I have to capture the package name,source,destination,source count and destination count in…

  sqlserver8650

  5 replies

  14 years ago

  By: Koen Verbeeck

• Incremental Load from AS400 DB2 into SQL Server

  I performed a Load of a SQL Server Staging area from an AS400 DB2 Database. I did not expect good r…

  Welsh Corgi

  3 replies

  14 years ago

  By: Pam Brisjar

• SSIS - Passing rows as array - Script component

  - Using Script component as Transformation, Communicated with Web service for look up operation - S…

  Gerbera

  4 replies

  14 years ago

  By: Gerbera