Import/Export Wizard created a IS package

[manmaria]

When I am trying to export data from one DB to another DB using the wizard, created a IS package and it is using lot of .tmp files in my local directory. If I want to schedule to run this job periodically in the server, then I assume I need to change these local directory files. Can I create some dummy files in the server or how to procede to run this package anywhere?
It has "EpilogueSql" and "PrologueSql" etc etc.,

Thanks,

 

[mrdenny]

When you run the package on the server the temp files should be automatically created in the servers temp folder.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[manmaria]

It is not just creating new temp files, it has a temp file which has sql to copy data from one DB table to another DB table. Do I need to make a copy of this file in the server folder?

Thanks

 

[Catadmin]

Assuming you didn't create those temp files in the first place, all you should have to do is change the connection managers in the package. Then it should create those temp files on the proper server directory all by itself.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"