Hello Sean,
                      I forgot to remove paramters in my log procedure after I removed it went successful..Now theissue for me is with date format

TY
Resolved the issue..and we are using try catch block in main procedure

Quick question on the Active Column.

In the main procedure I have declared variable called...

This is what I have in the package -

In OLEDB Source Output

External columns
From and Todate both are - DT_DBDate

In the Outputcolumns
From and Todate both are...

Yes, I want to reporoduce the same the same that is happening in our existing system.. The error is created as 547 means it s a violation constraint.

I...

TY So much..

But source and destination table has both same sizes..
nvarchar(1000).

I checked the len of the text  - totalsize is 271 including with spaces,comma and hifens.

Before Inserting...

This is an example of case statement

 Case When @Company = '' then 'no company' Else 'my company' End

In my case I am checking the If...

We are keeping remaining stuff in the same format so I don't want to change it.

What is this variable 2 and loop variable?

Variable2 = LoopVariable    

do we need to define these two at package level? or variable 2 is existing variable...

Any syntax for the expression, Not sure how to write the code in expression.

Can I get an example of the code.

Already created the variable and assigning into result set

But my question is it loops 13 times..to bring all states information how to track the first state id into...

TY So much,Resolved.

Yes, all 3 tables has same structure.
we are having 2 packages, in one package we are loading table 1 data in another package we are loading table 2 data.