Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
staillon
Starting Member
1 Post |
 Posted - 2012-08-03 : 11:29:18
|
| I'm using a basic MS Access 2007 front end for some users that are not SQL Server savy. I am using a button to allow them to opent the Import/Export Wizard, however, I would like them to be able to select the Server and Database on the MS Access Form and then have it passed to the Wizard when it opens.Is this possible? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-03 : 11:36:45
|
| For that you should be using a SSIS package rather than the standard export import wizard. you could create the basic transfer functionality using export import wizard and save it as a package. then open this package in BIDS and add configurations inside it for server and database properties. then you would be able to pass values for these properties from access forums and call package programatically to executeseehttp://arcanecode.com/2009/10/06/using-ssis-package-configuration-values-as-parameters-to-sql-tasks/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Pass Server and Database Param to Imp/Exp Wizard