Dineshbabu...

Thanks for the question..

Nice explanation..

Nice QotD and nice explanation..:-)

Thanks..

Great QotD..

Thanks for asking..:cool:

100% Agreed...

Great Question...

many thanks

Great Question...

Thanks

Great QoTD...

got it wrong, but your explanation was nice..

learned something...

thanks...

Nice back to basics question - thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

I believe so..

before putting this question on QotD, was wondering that...

http://www.mssqltips.com/sqlservertip/1311/web-based-database-administration-for-sql-server/

Nice Link to go through..

Thanks

Yes I would go with the replication as well.

or you can use help of SSIS, with Lookups and Union.

but again that would make your system slow, since you do not...

Do you use package configuration, Logging when you deploy your package.

or you manually change connections of server databases.

in Derived Column you can

use this expression to check NULL values

ISNULL( [ColumnName]) ? 0 : [ColumnName] -- if it is an Interger

ISNULL( [ColumnName]) ? "Some Value" : [ColumnName]...

you shoud use two for each loop to get each type of file from the same folder.

it makes the system fast, since you do not have to define the logic...