how do i assign an identity value in derived column, do i use the same package variable and how do i need to create a .net script to count the...

well this is a requirement from my manager.

John now i there is a change in this current project, nolw i am told to create a package, which will insert a good records in a table even...

Yes multiple destination is diffrent, like my first dest is sql1 and ultimatly it becomes source for destination sql2.

thanks for your response, now i have one more concern, while loading a data I have to first truncate the table and then load the data on table. in my...

now in this senario how do i run the package. if i run a package, both the data flow task start executing. now in my senario, i need to load...

As soon as I debug by creating container and setting container transaction option 'required', there would be blocking on the database and package doenst get executed. My source...

sorrry it worked now with that column errorow countgo , now we need to work our final need. how to manage a container

here it goes

still the same thing, after putting the column name, see the attached file, i execute the package in both option at data flow, with required and supported, both times package...

here goes

here is another file the one u needed

I think I go you, here I have attched a file, had 3 screnshots.

for that what i need to do, sorry i am bit confused

here's an attahced file how my conditional split componenet looks like