Wednesday, March 7, 2012

BUG : Data source not appearing

Hello,

I am trying make some imports and I am using the wizard.

I have created a new project and added 2 new datasources. One for a DB2 database and one for a SQL Server database

I select Project | SS Import and Export Wizard and the wizard launches.

When I look under datasource I can't find my 2 created datasources. I can create new ones but this is not something I want.

Any help ?

Constantijn Enders

Are you trying to create data sources, via the 'Data Sources' in the BI Project? if so, the data sources created in there will not be shared/visible in import/export wizard or the package.

Import/Export wizard has no access to project level artifacts, but is simply a way to auto-generate packages. Please try creating a package for your solution.

|||

It would be handy if the import/export wizard could access the project items. Perhaps for a next version.

I am importing from a DB2 system and setting up the oledb connection requires at least 3 screens.

You can only import multiple tables and/or views OR a single query. (not multiple queries)

If you have 10 queries, you have to setup that connection 10 times

Just my 2 cents

CE

No comments:

Post a Comment