I want to copy table from one server to another server. so i created SSIS package(data flow task) it completed successfully and it shows 491 records are transfered but when check it in destination server i didnt see any records. what is the problem could you please suggest me.
Thanks in advance Binod
asked May 11 '12 at 09:28 PM in Default
Did you put a source and destination in the data flow? Is the destination pointed to the right instance/table?
You can also just use the Import/Export Wizard and have the option of saving it as a package to run again at a later time.
answered May 12 '12 at 12:54 PM