Is it possible to use the SQL Import / Export Wizard to copy from PRODUCTION to PILOT?

SUGGESTED

I need to update the SO and PO tables on a daily basis to test an automation customization I am working on.  Has anyone used the Microsoft SQL Import / Export Wizard to create an SSIS package to copy data from PRODUCTION to PILOT?  Does that work?  If so, are there any potential issues I need to worry about when I do this?