February 25, 2009 at 6:55 am
Two quick questions:
(1) When designing packages in SSIS on a desktop using Visual Studio 2008, does SSIS have to be installed on the local machine? We thought about providing developers with client tools access to SSIS running on a development server, but this doesn't seem to work.
(2) Can SSIS connect to a SQL2000 data source?
Thanks,
-- Tom
February 25, 2009 at 7:02 am
The developer edition is under $50 online you need to give that to your developers and you should be able to connect to SQL Server 2000 or any other RDBMS in SSIS because it is an ETL tool.
Kind regards,
Gift Peddie
February 25, 2009 at 7:57 am
Thanks for the Response. Our developers have MSDN licenses, so they should be good to go.
I found my error on the second issue. It appears you cannot use a SQL Server Destination Data Flow for anything less than SQL2005. SQL2000 must be an OLEDB destination to work.
Much appreciated.
February 25, 2009 at 9:08 am
A side note the MSDN developer edition download is all platforms in one ISO file so it is about 3.3gig. I used the DAEMON tools to install it and did not run into issues.
http://www.daemon-tools.cc/home
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply