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, 2012 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, 2012 at 12:54 PM