I think that you have set FailOnError or FailPackageOnError of any step to be True.  If FailOnError or FailPackageOnError to be True, the package will stop its execution wherever the error...

Maybe my example misunderstanding

I have one master and one child table. Each master record has at most 2 child records.  How can I present it as follows:

Master

Maybe my example misunderstanding

I have one master and one child table. Each master record has at most 2 child records.  How can I present it as follows:

Master

I've tried it.  If the table has the primary key or unique index, then it is able to edit data.  But when I used the Server Explorer of Microsoft .NET,...

Hey, I am just a newbie.  I also start to use stored procedures and I can't find out what actually cons and pros...