Script component references in SSIS 2005

• stricknyn

  SSCertifiable

  Points: 6560

  More actions

  June 15, 2010 at 1:00 pm

  #145356

  Hello all,

  I am looking to design a custom data source using the script component as a source. I want to use the Advantage .NET Data Provider to access some Sybase Advantage files. The problem I'm having is it does not appear in the references list when I go to "Add Reference" in my script component. Also note that the provider is installed since I am using it as a data source in a data reader in the exact same package. It just doesn't show in the "Add Reference" list in a script component. This is SSIS 2005

  If I pop open SSIS 2008 drag a data flow task with a script component as a source, then go to the "Add Reference" list, the Advantage .NET Provider shows here. It just doesn't show in SSIS 2005.

  Anyone know how to make references show in SSIS 2005?

  Thanks,

  Strick

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 20, 2010 at 4:38 pm

  #1182528

  You have to have the provider in the following folder:

  C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

  and on 64bit machine here as well:

  C:\Program Files (x86)\Microsoft SQL Server\90\SDK\Assemblies

  Also you have to have at least SQL Server 2005 SP2 installed.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/