tags:

views:

34

answers:

1
Q: 

How to setup a MS SQL BI development environment on local machine

Hi, We need to setup a local development machine (with BIDS) to develop SSIS packages as we do not want to install BIDS on the database server itself.

Is there any guides on how to do that?

A: 

Here is a link to a guide to doing this for sql 2008:

http://www.mssqltips.com/tip.asp?tip=1807

William Todd Salzman  2010-04-13 20:28:28

related questions

How to turn on FastParse in SSIS (SQL Server Integration Services)
Recommend ONE favorite SSIS component that does SFTP/FTPS
SSIS: Remove Duplicates from Flat File
SSIS read flat file, write to DB or C# app,mutli thread read/write?
SSIS gurus: Links to Great Learning Content requested
Potential Pitfalls of inserting millions of records into SQL Server 2005 from flat file
The best way for a SSIS ftp task to not fail when there are no files to copy
SSIS: How to progmatically direct work flow in dtsx package
SSIS Package Puzzle
Import *variable record length* CSV file using SSIS
Using SSIS to refresh a training database from a production database
What are the options for extracting data out of Hyperion 7.3 with SSIS
SSIS Oracle Parameter Mapping
Integration Services: Multiple-step OLE DB operation generated errors
How to insert a row into a dataset via SSIS
SSIS copy directory from FTP location to a shared network location
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
How Do I Check Job Status From SSIS Control Flow?
How do I get SQL Server Integration Services to use a different database connection for Package Configuration
Can you start a scheduled Windows task from SQL Server Integration Services ?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
SSIS convert image blob
Good Starting Places for SQL Server Alerts/Notifications?
Accessing Excel data source running SSIS package on 64 bit server
Execute stored procedure (SQL 2005) and place results into a CSV file on a FTP location