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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Making a command to execute an import template

Author  Topic  vurna78 Starting Member 3 Posts Posted - 2007-03-23 : 11:00:44 Hi there! This is my first time visiting this forum, but probably not the last... :) I've been using ms access for a long, a few months ago it started acting up due to some 2gig limit Microsoft has set on it. Anyhow I've got a SQL database now to store all my data in but I'm having difficulties when importing data (which I do on a monthly basis). I used the ssis wizard to create and save a package, that was very easy but I don't know how I can execute it automatically. In Access I always used macros etc but they don't seem to exist here. Any help for a SQL server newbie would be greatly appreciated. :) Btw, I use a program called SQL server management studio (I hope I'm in the correct program). And I'm importing flat files. Brg, Erik