January 13, 2010 at 8:17 am
I've been given the task of transferring data from a Sql Server 2005 database to an Access database. I know I can use the wizard to accomplish this, but here's the problem - I only want to copy data for certain organizations. Something to this effect:
Select *
From Every table
Where OrganizationID between x and y
I'm guessing a SSIS package is the best way to accomplish this, but I have no idea where to start. ANY suggestions would be greatly appreciated.
January 13, 2010 at 9:10 am
the Export Wizard gives you the option of copying tables or using a query in like the sixth step: much easier using the wizard than SSIS.
you have to select your existing server as the source, then choose Access for the destination.
you have to point to an existing .mdb access database file...it doesn't create one on the fly.
the next step is this, asking whether to use a table or a query:
the next screen lets you paste your query and then finalize it. you might have to repeat it for each table name;
Lowell
January 13, 2010 at 9:36 am
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply