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 |
|
vbx
Starting Member
38 Posts |
 Posted - 2008-05-07 : 12:47:52
|
| Hello all,I am fairly new to SQL and am running with 2005 Dev. edition. I use the import Wizard often and was wondering if there was a method to save an import "profile" and execute it with out having to key it all in each time?thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 12:52:39
|
| Save the SSIS package to file. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-07 : 12:52:44
|
| Are you taking about Import/Export wizard? |
|
|
|
vbx
Starting Member
38 Posts |
Posted - 2008-05-07 : 13:16:07
|
quote:
Originally posted by visakh16
Are you taking about Import/Export wizard?
Yesquote:
Save the SSIS package to file.
I tried this and it prompted me for some password information that it would not allow me to ente? Kinda confusing |
|
|
|
vbx
Starting Member
38 Posts |
Posted - 2008-05-07 : 13:19:46
|
| OOhhh I think I got it.It is using the user name and password that I alread entered from the previous screen?I think I just saved one. I assume I can open it from entery screen?can this be executed a recurring time of day everyday? To automate it? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 13:21:25
|
| Depends on how you want:Get info from here:http://technet.microsoft.com/en-us/library/ms141747.aspx |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-07 : 13:24:53
|
quote:
Originally posted by vbx
OOhhh I think I got it.It is using the user name and password that I alread entered from the previous screen?I think I just saved one. I assume I can open it from entery screen?can this be executed a recurring time of day everyday? To automate it?
You can schedule it to run everyday. For that you need to create a SQL Agent job and execute package from it. The job will be scheduled to run as per your need.http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx |
|
|
|
|
|
|
save import wizard information