I removed the flat file destination from my data flow, so i route error output to row count, but it didnt give me the # if error rows. well...

It makes sense now, i will try to do that, but omy other question how do i configure send mail task, in case if i get less than 50 error...

Allen here I have attached a screnshot of my package it should give u an idea, where I am wrong.

SO my main motive is to create a package which...

Allen here I will explain inmore detail what I am trying to do.

I need to create a package which should move a data from sql1 table to sql2 table....

that didint work at all, i checked 50 on maximum error count and run the package, package run successfully by dumping more than 50 errors in my output flat file.

wow seems no one have any idea about my question, its pretty simple, just need to create threshold for error ouput file, if an error is more than 50 then...

thanks and my other question, how to skip an error while loading a data through ssis, suppose i am loading 1 million record and if an error comes in a...

Strange, nobody knows how to capture error message and send them via email on ssis?

Anyone please can help me out why jprimary keys are not copied in subscribers

Anybody their who can provide their input

The script that you send is for restoring from a single backup file or multiple backup files. Since I am backing up in a single file with append option. So...

Okay you mean that I need to create separate backup files while doing backup with append option. if it is hten can you please explain me why

I did a backup and restore with enterprise manager tool. not with a code

The tempd db is normal, I dont see any problem with tempdb

What do you mean by properties of primary filegroup, I checked on the properties of database, its on autogrowth option with unlimited growth.

thank you