-
- ExceptionMessageBox
by S1monk
- 13 Replies
- Last post
by jaegd
- I am trying to get the Exception Message Box to work in a script task in SSIS.
I am using the example from http://msdn2.microsoft.com/en-us/library/ms166340.aspx almost verbatum.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.MessageBox
Public Sub Main()
'
-
- Reporting Services authenticating with Analysis Services
by pavel_hlobil
- 2 Replies
- Last post
by Pavel Hlobil
- Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services.
Problem: Reporting Server does not apply Analysis Services Role after login.
Details:
I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role.
On the Reporting Server
-
- custom plugin error: how to pass information to Mining Model Viewer?
by Renan Souza
- 1 Replies
- Last post
by Bogdan Crivat
- Good morning,
Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one.
First of all, thanks a lot again.
Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging.
My clustering method ret
-
- Documents in VLDB
by Ike Ross
- 11 Replies
- Last post
by ggciubuc
- Hello All,
I have been experimenting with SQL Server 2005 partitions. I loaded a terabyte of information into 2 tables. The first holds the document information and the second holds the actual binary document (in this case pdf). Most of the documents are about 1 megabyte in size, but the largest is 212 megabytes.
SQL Server has no problem storing the blobs. The problem oc
-
- replacing Null values with 0's in Matrix
by techie234
- 4 Replies
- Last post
by sluggy
- Hi,
I am newbie to reporting services and I need some help. Could any one please let me know how to replace Null value with 0 in the data section of the Matrix. I don't want blanks to be displayed on the report, I want those to be replaced with 0's.
Thanks for your time.
-
- TSQL - Retrieving my Databes index (list)
by ajliaks
- 3 Replies
- Last post
by ajliaks
- Hi guys,
If I have an SQL connection called
"SERVER"
and into SERVER I have five different Databases like
"DB1"
"DB2"
"DB3"
"DB4"
"DB5"
(each one with it's own Tables / Views / Functions / etc)
How can I get the DATABESES LIST
Thanks in advance,
Aldo.
-
- Handling errors returned by SSRS
by cvajre
- 7 Replies
- Last post
by Teo Lachev
- We are displaying the report in our reporting application but we do not want to display errors from SSRS to the user. We want to handle the errors and display a user friendly message.
How can that be done . We are making URL access to the report server.
Thanks.
-
- subcube functions
by hmayer
- 1 Replies
- Last post
by Mosha Pasumansky
- does subcube functions respect the current subcube
if I nest them inside a scope
Like
FREEZE - I guess not
LEAVES - I guess yes
Is it true if I guess - Scripting Statements - no - Functions - yes
HANNES
-
- EDI file output
by jadoger
- 1 Replies
- Last post
by Phil Brammer
- any good example of extracting data from sql server 2005 in EDI file format I need to generate EDI files from sql server
thanks
-
- Client Components Fail to Install - UPDATE
by nielsb
- 5 Replies
- Last post
by nielsb
- Me as well can not install the client components on boxes that have CLR 2.0/Office 2007 already installed. Notice that the failures have occured on boxes that doesn't have any SQL Server 2005 components installed. I do not know if it is CLR 2.0 or Office that causes the failures. The error I'm getting initially is the same as Bogey1 and willgart: "
Upgrade failed due to the following error
-
- Help: how to generate sql statements according to parameters in a table-valued function
by Ricky Wang
- 1 Replies
- Last post
by Louis Davidson
- I need to enchance the following function:
create function dbo . GetCustomersByRegion ( @PageNo integer , @PageSize integer )
returns table
as
return (
select *
from ( select row_ number () over ( order by customerid ) as row_num , *
from customers ) a
where row_num >= @PageSize * @PageNo and
row_num &
-
- public key in certificate
by purusingh
- 0 Replies
- Last post
by purusingh
- <code>
CREATE CERTIFICATE SalesCert
encryption by password = 'blabla' WITH SUBJECT = 'Sales cert', EXPIRY_DATE = '10/31/2009' GO
</code>
When I create certificate using such tsql where is the public key.
-
- Truncate database tables based on foreign key constraints
by Amsri
- 1 Replies
- Last post
by Philip Kelley
- Guys, I have 600 tables in my database, out of which 40 tables are look up value tables. I want generate truncate scripts which truncates all the tables in order of Parent child relationship excluding lookup tables. Is there any way to do this apart from figuring out Parent Child relationship and then writing the truncate statements for each of the table. For example EmployeeDetail table referenc
-
- Problem with Lesson 3 in the Analysis Services Tutorial
by joney
- 2 Replies
- Last post
by Mary Potapova
- I am at the step of "Adding an Attribute and Defining Display Folders" where I am experiencing problems. The steps are: 2. In the Attributes pane, select the following attributes by holding down the CTRL key to select multiple attributes, and then in the Properties window, set the AttributeHierarchyDisplayFolder property for the selected attributes to "Location": ? City ? Coun
-
- Connector between executables dissapears
by London79
- 3 Replies
- Last post
by EuphoricHed
- Dear Forum Members.
I am currently using Visual Studio 2005: Business Intelligence Development Studio to create an Integration Services Package.
The package contains several containers, within each container there is a ¡®foreach loop container¡¯ and within the ¡®foreach loop container¡¯ there is a script component, execute component and another script component.
Each of the three components i
-
- Need to Subtract the result of two stored procedures
by ink innovations
- 13 Replies
- Last post
by ink innovations
- I am trying to take the results from two stored procedure and subtract them to get credit from two columns.
The stored procedures look like
create PROCEDURE mw AS select * FROM pla p where p.st in ('ds', 'sd') and (iPlayerID = '5345') compute sum(p.amount) RETURN
both procedure have the same syntax. I am not able to use AS in to insert the values into a variable. Is there a wi
-
- SSIS Logs Vs Custom Logs components
by spattewar
- 3 Replies
- Last post
by spattewar
- Hi,
In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.
Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required
-
- Parse text file (csv, fix width), Perl or something newer?
by ydbn
- 6 Replies
- Last post
by MatthewRoche
- I need to parse some text files and load them to database - these files are mostly CSV files or fix width columns format and the column names (first line) may vary in text (e.g. different abbreviation), order and extra columns, etc. Is it a good idea have this done using script task of SSIS How it compare to Perl on performance Or any other tools good for this
-
- protected sql database file
by Romantic_touch
- 7 Replies
- Last post
by Hemantgiri S. Goswami
- how can I create sql database file and it cann't be use or open (open mean to design view or structure) .
my case is: I have Acces db and this db has its own username and password, no body can read, write or view the designing, so it is useless. But there are somesoftware able to break and hacking db access. I think sql database file is more secure, so how can I do it
-
- Old Excel files after SQL2000 > SQL2005 migration
by P&#228;r Hedberg
- 14 Replies
- Last post
by Par Hedberg
- Hello there!
We are having some problems over here after our SQL2005 upgrade.
If we try to use an excel file that previously accessed the SQL2000 database (same DSN name and credentials), and then try to refresh the data after the 2005 upgrade, we get the errormessage "[Microsoft][SQL Native Client][SQL Server]User 'DOMAIN\username' does not have permission to run DBCC TRACEON."
-
- Dynamic SQL Cells
by Trekkie_SG9
- 3 Replies
- Last post
by Arnie Rowland
- How can I make the values for certain cells in a table in a database show the day a folder was created
On the same note, How can I make other values in other cells change (say the values 101 through 200 had to change to 1-100)
-
- Database mirror certificate expired
by David Dong
- 7 Replies
- Last post
by lrod
- anyone has the experience to solve this
-
- create local cube issue
by olap_user
- 7 Replies
- Last post
by olap_user
- Hello
everyone,
I have a
problem in creating the local cube in MSAS2005. This is what I have done please
guide me to solve the issue.
Steps:
We have installed MSAS2005
with SP1 on Dev box I created cubes on BI Studio
(linked to dev box from my local pc) I can see the cubes from MSMS
(linked to dev box from my local pc) Then I tried to CREATE GLOBAL C
-
- Seek in a SQL table from Access
by WesJD
- 4 Replies
- Last post
by Mike Wachal - MSFT
- I have an MS Access 2003 database from which I want to seek a specific record in a SQL Server Express 2005 database. I can connect to the table and get a recordcount but the recordset.supports (adseek) and recordset.Supports(adIndex) both return false. Any suggestions Specific code I'm using is as follows:
Dim cnxn As ADODB.Connection Dim strCnxn As String Set cnxn = New ADODB.Connection
-
- SQL2005 64bit, snapshot creation error
by Legi0n
- 2 Replies
- Last post
by Legi0n
- I'm running SQL Server 2005 SP2 64bit under Windows Server 2003 64 bit The system is the replication distributor as well. Transactional replication. But I can't create the snapshot! I have run snapshot.exe repeteadly with all parameters in a command prompt and it crashes at various BCP percentages. The error is like this: 2007-10-16 00:38:56.32 [10%] Bulk copied snapshot data for article 'Dictiona