Showing posts with label appearing. Show all posts
Showing posts with label appearing. Show all posts

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

Thursday, February 16, 2012

Brilliant blog posting (Full-text search ideas)

I was just browsing SQL Server blogs appearing in my feeds, and this
one struck a note with me because I would kill for BOTH of the features
he mentions.
http://www.yafla.com/dforbes/categories/SQL/
Sorry for spamming some guy's blog, but if the SQL dev team reads this
please take a look at it. I doubt it's new ideas, but it's worth
reminding yourself of.Forwarded to the dev lead of Full-text search.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Seyton" <jseyton@.gmail.com> wrote in message
news:1126113969.155725.262800@.g49g2000cwa.googlegroups.com...
>I was just browsing SQL Server blogs appearing in my feeds, and this
> one struck a note with me because I would kill for BOTH of the features
> he mentions.
> http://www.yafla.com/dforbes/categories/SQL/
> Sorry for spamming some guy's blog, but if the SQL dev team reads this
> please take a look at it. I doubt it's new ideas, but it's worth
> reminding yourself of.
>|||seems to be pretty well known, I recall reading something like that on
Tom Kyte's site a while ago|||John,
The issues under "Improved Indexing in SQL Server" are well known on the
fulltext newsgroup. While both concerns are not features in SQL 2000 FTS or
SQL 2005 FTS, both issues are solvable at the application level with data
duplication. I've emailed DForbes to see if he's had previous emails on this
topic per his request.
Paul, I'm sure that the FTS Dev Lead knows about this issue and hopefully
post-Yukon it will be incorporated in the next SQL Server version, besides
he knows how to contact me.. <g>.
Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:%23vTs1d9sFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Forwarded to the dev lead of Full-text search.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "John Seyton" <jseyton@.gmail.com> wrote in message
> news:1126113969.155725.262800@.g49g2000cwa.googlegroups.com...
>>I was just browsing SQL Server blogs appearing in my feeds, and this
>> one struck a note with me because I would kill for BOTH of the features
>> he mentions.
>> http://www.yafla.com/dforbes/categories/SQL/
>> Sorry for spamming some guy's blog, but if the SQL dev team reads this
>> please take a look at it. I doubt it's new ideas, but it's worth
>> reminding yourself of.
>

Friday, February 10, 2012

Borders & Styles

Hi,
I am making a Matrix report & having a tough time getting the borders to
work.
On the column header the side borders are appearing but the top borders
phew, I dont seem to be getting them.
Please help, ThanksThe Borders don't appear on the report when do a preview but when I save it
as Excel they are there in Excel.
Any thoughts ?
Thanks
"Vishal" <vrajput77@.hotmail.com> wrote in message
news:uwPwkIdCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am making a Matrix report & having a tough time getting the borders to
> work.
> On the column header the side borders are appearing but the top borders
> phew, I dont seem to be getting them.
> Please help, Thanks
>