Thanks for the reply...The stored procedure accesses the view but not the table...I could not add any indexes to the views formed by the unions ...The view has around 50...

oh I m sorry.....u have SQLXML source in import and export wizard....

you can use import and export wizard...you can find this wizard in BIDS...you just follow that wizard starting with the selection of source for MicrosoftExcel..It takes you to the end...

it dynamically takes the server names from the configuration file...so u need to change the configuration file regularly to shift the servers....may be there should be any other way to...

you can do that with a single SSIS package....but it can't load the data from more than 1 server to the other server at a single time...what you have to...

I remember like that task does 'nt work for sql 2000. So, better go for alternatives like import and export wizard..

It looks like the agent service does not have required access to both the instances...make sure that the account on which the sql server agent runs, has all the rights...

I use XML configurations...They are very flexible and easy to manage...I store the configurations in variables and store these variables in xml config files...so when I change the environment, I...

yep...Thanks a lot for the response...I m gonna leave the packages uninstalled....

Thanks for the reply...just to be more specific, I did nt install those packages in the file system either...just saved in C: drive...thats it...so is it okay if we just...

you said that you already tried protection level in the package!! can you specify which protection level you are using?? have you tried changing the protection level to don't...

I guess, try changing the protection level in the package to "don't save sensitive"....

you can create a variable for each and every connection manager and store the value of the connection manager in the variable...now, in the expressions store the appropriate variables...in the...

are all the control flow elements using same database?? If I understood the question, you can use some other alternatives for the data transfer like import/export wizard...

Hey...Finally I found the answer...actually when we use import and export wizard, it creates a temporary file 'prologuesql'...so if you move the package between the servers, you should change the...