SQL Express used for SSIS?
Home > IT Answers > SQL Server > SQL Express used for SSIS?
Lianv
10 pts.
0
Q:
SQL Express used for SSIS?
SQL Express, SSIS, Dell PowerEdge 750, Dell PowerEdge
Can sqlexpress be used for SSIS

Software/Hardware used:
DELL 750 Poweredge server
ASKED: Aug 17 2009  12:18 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29845 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
According to this Microsoft document, with the express editions you get only the Import and Export Wizard, and the basic Integration Services features required by the wizard.

Al other SSIS features are not included, so you would need standard or enterprise edition.
Last Answered: Aug 17 2009  2:53 PM GMT by Carlosdl   29845 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Sqlrunner   10 pts.  |   Aug 17 2009  8:12PM GMT

What are you looking to do with SSIS and SQLExpress? SSIS is a standalone set of libraries that do not require SQL Server to run. I believe you do need a standard or enterprise edition of SQL server to get the SSIS libraries, but I am not sure.

 

TaulPall   35 pts.  |   Aug 20 2009  11:19PM GMT

SSIS is a separate Windows Service from the SQL Server database engine and which is not dependent upon other Windows Services. SSIS Services are not included with SQL Server Express. However, as with just about any data source, a SQL Server Express database can be either a source or target for an SSIS Package.

Is it your intention to develop SSIS Packages or to simply deploy SSIS Packages? Typically one would use BIDS (Business Intelligence Development Studio) to develop SSIS Packages (it’s really just Visual Studio). BIDS is installed with SQL Server Standard, Enterprise and Developer Editions.

 
0