Rather than messing about with two packages, I find it easier to execute dynamic dts packages by using vba.

Copy this code into a vba module on a word document or...

Still not entirely sure what you are trying to do.

Are you using a data driven query task for the package as a whole or do you have various source and destination...

Sounds like you've got it. It's exactly what I meant - You see more than entry when looking at the OnSuccess flow.

Incidentally, if you want to check to make sure...

Don't know if you are aware, but you can add more than one destination step precendence on a singe source step.

Click on one of the 'on completion' lines and open...

Why not just add a line in that inserts into the desired table after each insert:

select max(Identity_Column) from yourtable. Will give you the last id entered.

Or is there more to your...

I got this a few months back. Will do the trick for you.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Thanks Peter. The user account that is logged on to perform the load is not a global one, so I will be able to put a trace on it.

I will...

Thank you both for your replies. Somehow I knew it would involve a lot of work, but if it is to be right, then I appreciate it's the only way.

Looks like...

I can only quote from my experience with dynamic properties tasks, but the idea behind it is the same for everyone.

The task is there to set values at runtime rather than...

At a guess I think it has something to do with the identity column.

Check what the 'set identity_insert' is

As per Steve's answer.

Easiest way:

select count(distinct(name)), date

from testing

group by date

You have a couple fo ways to do this.

You can retrieve the value of OIW_DOLLAR into a global variable and then use if, then, else, end if on the value...

Not as easy as it looks. If you only have 3 rows to export across, the easiest way is to do a select to return one row, then use the...

Inexed views are not straightforward. Read this article on how to. Helped me out a couple of weeks back.

Beware the pitfalls associated with them as I also found out.

http://www.sqlteam.com/item.asp?ItemID=1015

I would create a temporary table that has two coulmns (correct_spelling, incorrect_spelling).

Then run an update on the address table linking together the incorrect spelling with the address.

I.E

update address_table

set address_table.address =...