is it wrong to use exec sp_name in oledb source?for migrating data from multiple source tables to destination table.

he is telling that use transformations.

I m using transformation too(but few).

sequence no is 2(2 means 2 records creted on that activity)one record is updated.then only one record should be update with data_effective_end_date the destination table with seq no 1.

...

Canu send a query for that as an example?

Declare @workflow_activity_type_identifier int,

@workflow_identifier

select @workflow_activity_type_identifier=workflow_activity_type_identifier from workflow_activity

where workflow_activity_identifier...

i created stored procedure fro migrating the data from one sqlserver databse another sqlserver database.

My task is ther is workflow of xxxxxx.

i have to display sequence no increments based on...

Thanks for early reply,

if there is more than one row in workflow_activity table.

what changes can i do in the code?

Thanks.

I m little bit confused with the code which u sent as an example.

canu make it clear.

Thanks.

yes,how should i create an ssis package.

give me any example with sample code.

thanks.

There is sequence number column in destination table(there is no mapping filed in source table).When update or insert the data in to destination table the sequence number field should be...

i have to populate record by record sequentially based on the number of times the increments on X or Y.

For example:

Seq no col ...