yes

you can schedule all the packages on one server or different.

no, as it ok

import everything in stage table then delete not required rows

or simply import required data in main table.

thanks

create job for each instance and schedule it

for example....

1. Job1 on Instance1 schedule to run at 1 PM

2. Job2 on Instance2 schedule to run at 2 PM

etcc...

if pssible create one more drive and place indexes there, peformance will be faster...

which connection ur using for execute sql task?

did you created profilename = kalyan?

if yes then can you send test email?

thanks!!!

error on line 6

object doesn't support property called "Folders"

no, not working

i want to transfer around ~40 packages , click here and there is time consuming job

need some other solutions...

I want to find database growth by every 4 hrs

here is folder structure

c:/import/data

after import archieve

c:/import/archieve

files are with extension .ks and .ca

thanks

hmmmm

is there any otherway?