I want to transfer part of a large table from one server to a new server. It is a table containing 8 million sales records and I only want to transfer the last 2 years for development purposes in the new DB. It seems that the Transfer SQL Server Objects Task doesn't allow any query to be applied to the data being transfered. The only other way I see to do this is a Bulk Insert Task. I guess I can export the data I want into a text file and then use the Bulk Insert Task to load it. Is there a task that will automate exporting the data into the text file? MCSD .NET developer in Dallas, Texas

You don't need to use a text file at all. You can simply use a OLEDB Source and destination to load the data directly from SQL to SQLChuck

Chuck I need to do this in an SSIS package. Is that what you are describing? If so, what type of task object would I use? I need to be able to transfer only some of the records, not all of them, which is the only option I see in a Transfer SQL Server Objects Task. Thanks Steve MCSD .NET developer in Dallas, Texas

You would use a dataflow task in your ssis package. Inside the dataflow task you would use an OLEDB source which you declare a query for - there is where you would limit the data. A dataflow task is the primary way to move data in SSIS - all of the power exists in the components that can be used inside that task. Chuck

Have a look at this http://www.ssistutorial.com/first-ssis-package.phpChuck

Chuck That's exactly what I needed. Thanks Steve MCSD .NET developer in Dallas, Texas