How to create SSIS Package

Question

Hi All,

Any help from any body!! for creating SSIS Package ...

Answer 1

Assume you have Intergration and Report service installed alone with your SQL server.
Under MSSMS, Management, Maintenance Plans to build a new "MAINTENACE PLAN"

If you want to access the package other than MSSMS, Login to Integration Service to export the package.

---

927

Answer 2

Hi All,

Any help from any body!! for creating SSIS Package ...

is this the correct forum ?

what do you want to achieve with SSIS or is it only a general question about creating a SSIS package?

you can use the new SQL Server Data tool or Visual Studio 2008/2010 to create SSIS package.

Answer 3

Google is your friend http://msdn.microsoft.com/en-us/library/ms169917.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 4

Hi SqlServer001,

To create a package in Business Intelligence Development Studio:
1. In Business Intelligence Development Studio, open the Integration Services project in which you want to create a package.
2. In Solution Explorer, right-click the SSIS Packages folder, and then click New SSIS Package.
3. Optionally, add control flow, data flow tasks, and event handlers to the package.
4. On the File menu, click Save Selected Items to save the new package.

For more information, please refer to http://msdn.microsoft.com/en-us/library/ms141178(v=sql.105).aspx.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 5

check these

http://msdn.microsoft.com/en-us/library/ms169917.aspx

http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm