Install DTS packages on development machine

I would like to install the components I need to develop a SSIS custom component. Is there an SDK or install option for just the visual studio components?

There is no seperate redistributable or SDK for SSIS. There is actually an SDK folder that gets installed, normally C:\Program Files\Microsoft SQL Server\90\SDK which has SSIS related assemblies for referencing, but I am not sure which install option gives you this. I suggest you run setup and select "Integration Services" and also "Workstation Components..."

A nice blog post about installing SSIS and some of the options-

Michael Entin's WebLog : Why do I get "product level is insufficient..." error when I run my SSIS package?
(http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx)

Instalation MSDE failled !

Hello,
I'm trying to install MSDE but it fails.
I notice thatthe install log has several return values 3 wich means
problems.
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (AHFTSH,LocalSystem,87).
Action ended 11:25:35: InstallFinalize. Return value 3.
...
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (48:B4) [11:25:40:093]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (48:B4) [11:25:40:093]: Error in rollback skipped. Return: 5
MSI (s) (48:B4) [11:25:40:109]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 246, szDescription:
"".
MSI (s) (48:B4) [11:25:40:171]: The call to SRSetRestorePoint API succeeded.
Returned status: 0.
MSI (s) (48:B4) [11:25:40:171]: Unlocking Server
MSI (s) (48:B4) [11:25:40:171]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 11:25:40: INSTALL. Return value 3.
...
MSI (s) (48:B4) [11:25:40:328]: MainEngineThread is returning 1603
MSI (s) (48:94) [11:25:40:328]: Destroying RemoteAPI object.
MSI (s) (48:30) [11:25:40:328]: Custom Action Manager thread ending.
MSI (c) (28:3C) [11:25:40:328]: Back from server. Return value: 1603
MSI (c) (28:3C) [11:25:40:328]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 11:25:40: INSTALL. Return value 3.
...
=== Logging stopped: 21-11-2007 11:25:40 ===
MSI (c) (28:3C) [11:25:40:359]: Note: 1: 1708
MSI (c) (28:3C) [11:25:40:359]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (28:3C) [11:25:40:375]: Grabbed execution mutex.
MSI (c) (28:3C) [11:25:40:375]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (28:3C) [11:25:40:375]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21-11-2007 11:25:40 ===
Solutions ?
Regards
Antonio Ferreiar
Andrea,
Thanks. Problem solved.
Antonio
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:5qj194F10cgomU1@.mid.individual.net...
> hi Antonio,
> Antonio Ferreira wrote:
> have you already seen http://support.microsoft.com/kb/829386/en-us ?
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>