here is some sample data, also it only happens when the first filed is 21

21,"I",1,10024414482,1,2,2009-09-01,"CI03",100012717709,382029.00,398583.00,1,4230,2009-09-01,,2009-12-22,2009-12-22,"","00BRGE","",,,""

24,"I",2,10024414482,"4230L000164357","ENG",1,2009-09-01,,2009-12-22,2009-12-22,,"",,"","STUDIOS",,"",,"","VULCAN HOUSE",33433131,"","Y","M5 9JS","SALFORD","N",,,""

21,"U",3,10004678137,1,2,2003-12-01,"CI03",,376896.00,398991.00,4,4230,2003-12-01,,2009-12-22,2003-12-01,"DONE BROTHERS","00BRGC","",,,""

24,"U",4,10004678137,"4230L000015980","ENG",8,2003-12-01,2009-04-01,2003-12-01,2009-12-22,,"",,"","",,"",,"","FORMER DONE BROTHERS",33432125,"","N","M30 9QG","","Y",,,""

24,"I",5,10004678137,"4230L000164359","ENG",1,2009-04-01,,2009-12-22,2009-12-22,,"",,"","",,"",,"","UNIT 3T",33432125,"","Y","M30 9QG","MANCHESTER","N",,,""

21,"U",6,10004678205,8,4,2009-07-13,"CZ01",,378012.00,398588.00,1,4230,2003-12-01,2009-12-22,2009-12-22,2003-12-01,"","00BRGC","",,,""

I have my text delimiter to a " already because most of the fields have quotes in

Sorry iI wasn't clear, I will give a more complete overview of what I want to do.

There are 5 tables

Basic_Land_And_Property_Unit_Record_Type21

Land_And Property Identifier_Record24

Street_Descriptor_Record15

Street_Record_Type11

Master_Table

Each Tables holds different amounts of data

The master_table has...

Thanks for the solution,

This query has to work on other tables as well ie

Street Descriptortype 15 when id(15), Street record-Type11 when id(11).

and it also has to delete records.

when the...

the master table is

USE [DEV_Test]

GO

/****** Object: Table [dbo].[MASTER_TABLE] Script Date: 05/06/2010 11:51:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MASTER_TABLE](

[Field1] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Field2] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS...

I have two tables, one called BASIC_LAND_AND_PROPERTY_UNIT_RECORD_TYPE21 and one called Master_table. the Master_table has data as shown below:

Field1 ¦ Field2 ¦ Field3 ¦ Field4

-----------------------------------------

21 ¦...

iam trying to iterate through results from ole DB source

the quey below but it inserts 64 records instead of 4,

could you give me an idear where i am going wrong.

set...

Table A has 100 records with I, U, D (insert, update, delete)records.

18 of the records are need to be inserted, when the stored procedure run's 1800 records are inserted into...

Hi

I have a problem eith the solution described earlier, the problem being that it iterates through the dataset as many times as there are rows, therefore when it inserts...

yes the source and destination are on the correct server, the diagram you provided is what i have.

Thankyou, I think you answered my questions for now, but iam sure I...

i have just been reading up on OLEDB command transformation, could you use this command as it reads row by row with a stored procedure

Thanks for your solution, being a newbie to SSIS, after processing first row how does it move onto next row without using a for next loop.

I am .net developer but have been seconded to the dba section.

I have tried to use the conditional split but it grabs the data in batches, the delete update and...

I have been battling this problem all day and seem to have taken backwards

Iam using Excel 2007 and have installed AccessDatabaseEngine.exe, after adding another execute sql task an error...

Cheers for the replies.

The inserts,updates and deletes will only effect one row ie. it could update the row then delete the row and then insert the row all acording to...