October 18, 2009 at 10:33 am
Gerry here - have not posted before..
Trying to cet tabels and all data within copies to a new database to get rid of some problematic tables suspect for corruption.
when we select and scrip to query editor, it does not appear thaqt the contents of the tables are going to be copied.
Thanks,
Gerry
October 18, 2009 at 11:46 am
You have left the reader to face unnecessary challenge number one: "What's the question?" It would appear to be: "How do I get the data to transfer too?" But as you're a newb here, I won't draw attention to it this time 🙂
As you've posted in the SSIS forum, I am assuming that you are using the 'Transfer SQL Server Objects' task? If so, setting the 'Copy Data' option to True would seem to get you what you want, or am I missing something?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 19, 2009 at 4:45 am
If you just want to straightforward copy of the tables try the Import Export wizard from management studio. Right click the source database, select Tasks, then Export data and follow on from there. If you save the package on your file system, you can then open and edit it in BIDS or Visual Studio, so it's a good way of generating a skeleton dataflow package for adding other processing later.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply