SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS Package SQL Agent Scheduling Fails.

  My enviroment: DEV/TEST = XP Pro, VS 2005 and SQL 2005 (SSIS, Database) PROD = Wndows 2003 64bit / …

  teekay-101299

  1 replies

  17 years, 10 months ago

  By: teekay-101299

• Extracting Data from SQL 2005 to SQL 2000

  Hi I just created a simple package that copy objects and data from SQL 2005 to SQL 2000. I used a T…

  SSMfana

  9 replies

  17 years, 10 months ago

  By: SSMfana

• Conversion of System.Object to collection

  Need assistance in looping an Object variable. Basically I have a SQL task populating the variable …

  Spudmasher

  4 replies

  17 years, 10 months ago

  By: Spudmasher

• Automating execution of dtsx packages

  I have created a project that contains four separate dtsx packages. Up to now, I've been executing …

  Gwen-528901

  5 replies

  17 years, 10 months ago

  By: Gwen-528901

• 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 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

  17 years, 10 months ago

  By: chockenhull