Does anyone know where to go to get help running a stored procedure with
parameters on a linked AS/400?
select * from openquery(AS400,'CALL Library.Procedure')
--The OLE DB provider "DB2OLEDB" for linked server "AS400" indicates that

What are some of the enhancement and new features related to Data Mining that I can expect in SQL Server 2008?
thank you,
Gustavo Frederico

Under "Data Mining" Microsoft lists
"Text Analysis - Analyze feedback to find common themes and trends that
concern your customers or employees, informing decisions with unstructured
input"

I'm trying to create mirroring between datanases but any time I restore
database from primary server to mirror database is in (Restoring ... ) state.
I'm guessing I should not attempt to start mirroring until database is out of
this state but I gave it a try hopping this will ...

I have two tables that are related via a trip id like so:
Trips
-------------------------------------------------------------
TripId     TripDate     TripNumber     Vehicle      Driver

To minimise the impact for users we always process our cubes on server A and
then backup/restore them to server B.
Users only access server B.
Now I wan't to use "usage based aggregation optimisation". The user

We upgraded some fields in our database, updated the DSV in the build saved
and ran the update and everything went off ok, until we ran the process from
the SQL Server Menu instead of BIDS interface.  It still shows the field as
being to small and the build is cancelled due to a ...

I have many calculated members defined as 'currency' in format string. When
I pull this calculated members in Excel 2007 they are not displaying the
currency format. However, all my measures defined as currency do show in
excel. Please advice.

I'll apologize in advance for asking something that may have already
been answered, but I've searched and can't find a solution.
I am running SQL Server 2005 Standard SP 2 in my test enviro. I have
two OLAP databases on the box.

I have been having some strange problems with our SSAS server and I suspect
something is corrupt there since it crashes without apparent reason, and last
night the AS service couldn't even start because some file is in locked state.
So I decided to delete the AS database and start ...

I would like to accomplish the following:
1. Send Mail to an email address and individual's name retrieved from a list
retrieved by a select statement.
2. Customize the text in the email to incorporate the individual's name

It appears I had successfully migrated sql server 2000 dts packages to sql
server 2005.  However, I can't find them on sql server 2005.   How do you
reference these packages.
Thanks in advance

Please advice on How to Execute a DTSX package from VB.Net 2003.

Dears,
I'm trying to import excel sheet using SSIS, however if there is any cell
that has formula (C1 = A1 + A2), it appears as null.

I had to change the administrator password on a sql 2000 server and now the
packages under Data Transformation Services will not open up.  I get the
error message: "the specified module could not be found" when trying to open
a module up or even trying to create a new package.

This is only a test

I posted this a week ago but it never showed up, so here goes another try...
"Andre" <no@spam.com> wrote in message news:...
I have a package that is reading data from a stored proc and exporting it
to a csv file.  Occasionally we add additional output columns to the sproc,

If the current Fiscal Year (FY) is 2010 and the current Fiscal Month
(PER) is 4
In a Script Task, what is the script necessary to derive that CurrFY =
2010 and CurrFM = 4 ?

So I have an interesting scenario with expressions.  I always thought they
were evaluated during validation of the package/task/variable etc.  That is
until I started using the SQLStatementSource expression property on a Execute
SQL Task.  I created a simple package to test this ...

I have a dtsx package with a very simple Execute Process task .exe that just
saves a file in a directory. The package runs fine from Visual Studio, the
app runs fine on the SQL Server. However, when I run this package from a job
in SQL Server the package starts and hangs forever. ...

WTB: MICROSOFT OEM SOFTWARE
WTB: MS WIN 95, 98, 98SE, 2K, XP, OFFICE 2000, XP, 97, 95 PRO-Vista ultimate, basic, premium Small business..
Looks at the list below.
Wanted to buy.. Microsoft OEM and RETAIL Software in small and large quantities.

Firmware - Driver para R4i Dsi,  R4 Dsi.  Nintendo Dsi.
http://www.elotrolado.net/hilo_firmware-drivers-nintendo-dsi-r4-i-upgrade_1214985
saludos
gx,nS<Sbd&FDZePCfVbTtGCkr

In short, "Dynamic MDX Queries" don’t work as described in the BOL.
I’ve lifted the sample code directly, tried to run it, and it fails.
It’s documented at http://msdn.microsoft.com/en-us/library/ms172589(SQL.90).aspx
The “Analysis Services Event Provider” queries a SQL table, ...

doesn't look like too many members or lots of activity.  Is this an
active group?

Hi, everyone.  I'm embarassed to admit that I set up a SQLNS app some
time ago, and it's been so long since I worked with it that I'm at a
loss for where to start troubleshooting.
A SQLNS server that I work with is experiencing an inordinately high

I've installed SQL Server 2008 x64 SP1 SSRS on a server running
Windows Server 2008 x64 Standard and am having major issues. I
installed and configured SSRS using documentation provided by our CRM
application (ConnectWise). They appeared to be pretty standard

We are using a SQL Server embedded connection and a specific user name and
password for the Report Server.  Meaning not Windows Authentication.
When we use a report URL as the drill down from one report to another and
click on the link, we get the Report Server logon asking for ...

a) how do I know which version of SSRS designer I have? how do I know
which version is current?
b) anyone know what this means:
c:\documents and settings\administrator\my documents\visual studio

I posted a message on 2/19/2010 that never got answered and subsequently was
deleted. I'm not sure why.
I'm trying to get away from Crytsal Reports and I would like to know if
there is a way to code the location of a .jpg file in .NET so I can

I have a report with a tablix in it reporting from a dataset within
this report I have a subreport sourcing data from another dataset. I
have set the subreport to activate on the click of a hyperlink. But
what I want to embed a few subreports into the main reports all