SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• The process cannot access the file because it is being used by another process.

    I have a File System Task Copy file operation to copy a file in an SSIS package.  The p…

  M Shah

  2 replies

  15 years, 8 months ago

  By: deanna.briggs

• pivot data using SQL

  Hi all, I am using SSIS to do Pivot but some rows are going to error, I cannot findout why, as all …

  sql_learner29

  1 replies

  15 years, 8 months ago

  By: sql_learner29

• How to Loop Text Files

  Hi, i'm having 10 txt files in a folder that to be accessed sequentially. while running the package…

  sabarichandru

  4 replies

  15 years, 8 months ago

  By: Elliott Whitlow

• removing duplicates without sorting....

  Hi I have a source that gives me data in sequence like this Account DEPT Employee TASK A1 D1 E1 …

  sql_learner29

  25 replies

  15 years, 8 months ago

  By: Ed Zann

• Problem Executing For Each File loop (*.xls)

  Hello people, I would like your help/experience in the following issue: I have an SSIS package impo…

  Theo-929802

  11 replies

  15 years, 8 months ago

  By: Theo-929802

• XML Source Not Displaying all columns in XML file

  Below is my XML Schema definition, which I generated from the XML file I want to import into a tabl…

  Stegzy

  1 replies

  15 years, 8 months ago

  By: SID_

• SSIS: Integration Services XML as Source

  Hi Guys, I have converted an MS .xlsx file to .xml file. Now I chose the xml file as a data source …

  tasnim.siddiqi

  1 replies

  15 years, 8 months ago

  By: Phil Parkin

• difference between DotNet and OLE DB connection strings?

  I just lost a couple of days debugging why my Packages did not work and I think I understand but I'…

  Eric Mamet

  3 replies

  15 years, 8 months ago

  By: Elliott Whitlow

• SSIS

  Hi All, I am trying to execute SSIS package from the .net Framework. I have a User Variable availab…

  ruja.patel

  1 replies

  15 years, 8 months ago

  By: Elliott Whitlow

• Looping through Files in SSIS 2005

  Hi All, I'm totally new to SSIS 2005 and i have the following requirements. Scenario: In my server …

  vibin.das

  2 replies

  15 years, 8 months ago

  By: vibin.das

• SSIS based on filename mapping to Database table

  Hi, I'm totally new to SSIS 2005 and i have been assigned to do the following tasks. Following is t…

  vibin.das

  3 replies

  15 years, 8 months ago

  By: vibin.das

• how to do incremental loading for each table

  Hi........... How could I do incremental loading for each table in the database instead of writing …

  guru12

  3 replies

  15 years, 8 months ago

  By: Koen Verbeeck

• Error when using Int or String Datatype Variable but Works with Object Datatype

  My scenario is I am assigning a value to a package variable in execute sql task which is in a for e…

  SSIS.COM

  4 replies

  15 years, 8 months ago

  By: SSIS.COM

• How to call one SP for multiple Execute Sql tasks

  I want to make my Package dynamic by using the same SP for multiple execute sql tasks. Basically, t…

  SSIS.COM

  2 replies

  15 years, 8 months ago

  By: Ed Zann

• Polpulate the Dimension Table from OLTP Source tables

  Hello, I am new to SSIS. I have to transfer data from OLTP to staging and from staging to Dimension…

  ETLD

  4 replies

  15 years, 8 months ago

  By: ETLD