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 |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2009-02-27 : 18:41:54
|
| I used the import wizard to import files as I have done in sql 2000. I named & saved it. Question, where does it save it and how do I get it run on a schedule? I've never done this in 2005 only in 2000.can anyone help?Thanks |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2009-02-27 : 22:05:48
|
| If you are in question about the SQL Server 2005 Import/Export Wizard, it is possible to save this job and schedule it. When you choose to save an I/O operation, an SSIS package (.dtsx file) will be created. You can open this file using Visual Studio or Business Intelligence Development Studio (BIDS) and view or modify the data flow.To schedule this to run, you'll need to load it to a machine running SQL Server and SSIS. Connect to the SSIS instance and import the SSIS package, and you can then set up a SQL Agent job to run it on a schedule.You can find more exhaustive information about the Import/Export wizard, BIDS, and scheduling an SSIS package by searching Books Online or Google. Feel free to post again if you have a specific question or problem.hth,Tim---------------------Tim Mitchellwww.BucketOfBits.com |
 |
|
|
|
|
|
import package help