Help with SSIS

Question

Help with SSIS

Best-330874

SSCrazy

Points: 2350
More actions
March 14, 2007 at 10:36 am

#117903

Hi All,
i am new to sql server 2005.i want to import an excel WORKBOOK which has multiple sheets into sql server database.so for that i want to use SSIS and create a package and schedule the job.can somebody guide me the steps to accomplish it.

Thanks
Asim

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

S. Kusen SSChampion Points: 10936 More actions · Answer 1

The article at http://www.databasejournal.com/features/mssql/article.php/3580216 should help you get started with the import and export wizard.

To schedule it as a job, you will probably do best by changing the package's security. See my post at this location: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=349385

Hope that helps.

Best-330874 SSCrazy Points: 2350 More actions · Answer 2

My question is like what are the other options beside using import-export wizard-what are the steps needed to create a package.

S. Kusen SSChampion Points: 10936 More actions · Answer 3

If you're going to just do an import or export, it's easier to use the wizard and let it build the package. The wizard builds you an SSIS package, but you have to then run it. After you build it, you can analyze what it does and it will then help you get started with understanding how to build similar packages. I tried to build an excel import/export from scratch and there were issues with the way the data was being transformed and I was able to see the difference after running the wizard.

To get started, you want to open the business intelligence studio, go to file, new, project and select integration services project. That will get you up and running with a blank package.