SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• To validate # of excel rows(source) and sql server table(destination) rows are equal

  Hi, When exporting data from excel to sql server table, using SSIS package, after exporting is done…

  Alicia Rose

  1 replies

  18 years, 4 months ago

  By: Chinna

• SQL 2005 SSIS - MS Access Data Transform Missing Random Rows

  Running 64-bit SQL 2005, run a Data transform to bring in all rows from an Access table and insert …

  mark-627262

  3 replies

  18 years, 4 months ago

  By: mark-627262

• round robin database

  Can I use SSIS to extract data from a round robin database and import to a sql database?

  jessica-314018

  3 replies

  18 years, 4 months ago

  By: Matt Miller (4)

• regd date small issue

  hi i jus had a column name date but the data are like date 100083 100080 100097 so now i jus need …

  Chinna

  18 replies

  18 years, 4 months ago

  By: Chinna

• XML/CSV Data Source

  Hi everyone We are currently in the process of defining the technical requirements for a new client…

  David Schneeberger

  5 replies

  18 years, 4 months ago

  By: David Schneeberger

• Looking for Best Practice on Loading Flat File with 2134 columns

  Here is the delima, I'm developing a package to bring in a CSV file that contains 2134 columns...st…

  Marvin D

  9 replies

  18 years, 4 months ago

  By: Jeff Moden

• moving columns from one table to other

  i had a table 'NY' with 4 columns col1 col2 col3 col4 now i have other table 'ABC' with 2 columns…

  Chinna

  1 replies

  18 years, 4 months ago

  By: SQLdevotee

• SSIS triplicating data when more then 1 schema

  I have a DB with 3 schema's. They are dbo, current and archive. When tables have the same name but …

  cbaker

  1 replies

  18 years, 4 months ago

  By: Jack Corbett

• Flat files without delimiters

  Hi, I have a flat file without delimiters. The format is like L10123444 221 but Col1 = L;col2=1;col…

  karthi-646351

  3 replies

  18 years, 4 months ago

  By: Jeff Moden

• Handling error records at OLEDB destination

  Can we handle errors (Records failed to insert into target table) at OLE DB Destination?. If so I'm…

  Jay1234

  1 replies

  18 years, 4 months ago

  By: Jack Corbett

• Help - Production - The variable "User::SourcePath" doesn't contain file path(s).

  :w00t: I have a Foreach loop to process all files of *.txt in a directory. Within the loop is an F…

  chockenhull

  3 replies

  18 years, 4 months ago

  By: chockenhull

• How to create dbf using SSIS

  Does anyone know how to create a dbf-file using SSIS. I want to extract data from a sql table and w…

  jos.haemers-599799

  4 replies

  18 years, 4 months ago

  By: b_boy

• Data Type conversion Problem

  Hi, I tried to convert excel data to flat file output using SSIS.one of the excel field contains th…

  senthilkumar.m-555627

  2 replies

  18 years, 4 months ago

  By: senthilkumar.m-555627

• Multiple E-L tasks. Any other ways of doing it?

  Following this post I am starting the following one, which is kinda the same thing but even more co…

  VALEK

  12 replies

  18 years, 4 months ago

  By: jdgonzalez@jdandrachel.com

• Lookups SCD's Historical Data

  Hi. I have an employee dimension with some recorded changes. That is, some employees have multiple…

  Nicholas Large

  1 replies

  18 years, 4 months ago

  By: matzer