SSIS and import/export wizards

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

SQL Server Administration (2005)

SSIS and import/export wizards

Author

Topic

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2007-01-11 : 09:04:28

Guys,

I am new to SQL Server 2005. I have installed Developer edition. I want to transfer data through DTS which is now SSIS - Sql Server Integration Service I believe.

One question though how do I access SSIS, I am doing normal imports and exports using the wizards. Is there any other interface to access the SSIS??

Please let me know

Thanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-11 : 11:36:55

In the All Programs/Microsoft SQL Server 2005, open SQL Server Business Intelligence Development Studio. That is now the main tool for working with SSIS packages. To create a package, select File/New/Project on the menu and then create a new Integration Services Project.

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2007-01-11 : 14:36:22

Thank you snSQL

Is there any tutorial or a way to follow steps to import a csv file into a table.

Thanks
Sri

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-11 : 15:41:41

Well the easiest is to add a New Item to your SSIS project and select SQL Server Impoart and Export Wizard.

Otherwise in Books Online table of contents you could go to SQL Server 2005 Tutorials/Integration Services Tutorials/Integration Services Tutorial

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources