SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Please help. Excel input fails: "value violated the integrity constraints for the column"

  Error is on the Excel Source component. All columns in the spreadsheet are text. Component is read…

  born2bongo

  3 replies

  16 years ago

  By: born2bongo

• excel error

  Hi, I'm getting a peculiar problem. for example i entered 2/2/2010 in excel and integrating it to n…

  Anamika

  3 replies

  16 years ago

  By: Phil Parkin

• Reusing lookup transforms

  Hi there, I have a question regarding the lookup transform. I know there is a disk cache available …

  ducon

  2 replies

  16 years ago

  By: ducon

• Troubleshooting a sql server package configuration

  Hello, I am trying to create a package that stores the configuration information in a sql server ta…

  padre

  4 replies

  16 years ago

  By: padre

• Generating Reports with Integration Services

  Hi We produce several reports each week/month and I'm investigating the possibility of automating t…

  chris.mcbain

  5 replies

  16 years ago

  By: chris.mcbain

• Transfer SQL Server Objects task, PK problem

  i have a job that copies 20 tables or so once a month to an archive database. some of the tables ha…

  alen teplitsky

  1 replies

  16 years ago

  By: Phil Parkin

• Pass dynamic value into a variable in SSIS

  I have a SSIS that insert data into SQL tables. The flat file will be taken from a specific path, b…

  MTY-1082557

  7 replies

  16 years ago

  By: MTY-1082557

• Import Export Table Failed with error

  Hi I wanted to import couple of big schema from my production database to test version. These schem…

  santosh.subudhi

  1 replies

  16 years ago

  By: Jack Corbett

• EXECUTE SQL parameters mapping problem

  I Have EXECUTE SQL Task and I am trying to insert some data into table with syntax: "INSERT INTO te…

  darko IS

  4 replies

  16 years ago

  By: darko IS

• Re-direct Errors

  Hi, I am importing several excel files using a ForEach loop container. Each excel file has several …

  Jason Coleman

  5 replies

  16 years ago

  By: Jason Coleman

• Excel to Text file

  Hi, I'm working on a package where i'm transferring data from excel to a flat file. My problem is t…

  Anamika

  9 replies

  16 years ago

  By: Anamika

• text file destination in file connection manager

  I have an SSIS package.The SSIS runs perfectly the first time . then I lose the text file destinat…

  mtz676

  2 replies

  16 years ago

  By: mtz676

• Warning about global shared memory

  Hello all, Could someone please explain me what error below means: [SSIS.Pipeline] Warning: Warning…

  pshvets

  5 replies

  16 years ago

  By: udayk94404

• Popup to ask variable value every time it run

  In my project there is a simple select query whose 'where' condition will filter for particular rec…

  vivekjamshedpur

  1 replies

  16 years ago

  By: COZYROC

• SSIS Error Message HELP!

  Here's our environment: SQL Server 2005 x64 SP2 with a 2 node cluster. As long as SQL Server is on…

  beezell

  4 replies

  16 years ago

  By: Carolyn Richardson