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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 how to SSIS

Author  Topic 

hellilyntax
Starting Member

19 Posts

Posted - 2006-09-05 : 13:21:33
hi people...
can u explain to me on how to use SSIS?
im using SQL Server Management Studio Express...
there is no wzard for that feature...
do i have to install it?
if yes the how?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-05 : 14:08:38
You can't.

Look here http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx under Integration and Interoperability.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-09-05 : 14:23:38
development in SSIS is now done in visual studio with business inteligence project.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

hellilyntax
Starting Member

19 Posts

Posted - 2006-09-06 : 17:20:43
can ssis be applied to a condition where sql server is on other side while source file(excel) is on another server?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-09-06 : 17:38:47
quote:
Originally posted by hellilyntax

can ssis be applied to a condition where sql server is on other side while source file(excel) is on another server?



Yes.

Tara Kizer
Go to Top of Page
   

- Advertisement -