Sunday, March 11, 2012

BI/SSIS Developer environment?

Which sql components are needed to develop/execute packages within BIStudio considering that SSIS is centralized in one sql server?
Is Source Safe 2005 integration within BI has the ability to add/update packages to a SQL server location instead of a system file?

Thanks,

Greg.I can only answer your first question.

When you install Business Intelligence Development Studio from the Client Tools node in SQL Server setup, the components necessary to develop and test Integration Services packages are also installed. However you cannot run packages outside the IDE on a client computer configured in this manner.

The best way to run a package from clients in an ad hoc manner is to create an unscheduled SQL Agent job on the server to run the package, and launch that job from the client by using the system stored procedure, sp_start_job.

-Doug

No comments:

Post a Comment