-
- Katmai June CTP, where are the SSIS lookup enhencements
by ccote
- 2 Replies
- Last post
by ccote
- H, I downloaded and installed the June CTP of Katmai. It looks the same as SSIS 2005. I would have expect to see improvements made to lookups (connectivity, cache) but did not find it. Are these improvements into June CTP
Thanks,
Ccote
-
- HOW TO EXECUTE THE PACKAGE IN STORED PROC PLZZZZZZZZZZZZZZZZZZZZZZZZZ
by Koteswara Rao
- 1 Replies
- Last post
by jwelch
- My Package Exist in
C:\WROX\WROX\bin\excel_database package exist
OR sql server agent ->job-> excel_database package exist
now i want to excute the from master database how please send the
stored procedure code
Regards
koti
-
- Moving From DB2 to SQL
by Constantijn Enders
- 0 Replies
- Last post
by Constantijn Enders
- Hi,
We want to move our current datawarehouse from DB2 to SQL server.
Is there a tool who can do this automatic
If not is there a tool that can convert the ETL in datawarehouse manager to SSIS Or at least ease the pain
CE
-
- Installing SQL Server Express
by Jim Hess88
- 10 Replies
- Last post
by Mike Wachal - MSFT
- I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything. My problem is that now that I have
-
- Modifying Existing Rendering Formats
by Jeffrey Rush
- 2 Replies
- Last post
by Jeffrey Rush
- Good morning (afternoon/evening) all. I am researching a way to render data in a plain text file, with no formatting. I plan on building out the result set to exactly what I am wanting and just need it to render itself without any formatting logic being taken into consideration. The end result is to generate a QIF file from a random data set. QIF is just a formatted text file. Am I making sense
-
- Data migration using Import/export wizard SQL 2000 to SQL 2005
by Javahar
- 2 Replies
- Last post
by kumar s
- I am trying to import data from SQL 2000 to SQL 2005
The Data schemas are the same in both (tables, relationships, key and triggers).
Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 20
-
- cluster install 2nd node unavailable
by acki4711
- 6 Replies
- Last post
by acki4711
- Hi all,
Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown".
- I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 v
-
- Problem about ProClarity KPI indicator customization
by Helen999888
- 0 Replies
- Last post
by Helen999888
- Hi, all Microsoft BI experts here,
Thank you very much for your kind attention.
I am wondering if there is any way for us to customize the size of the the KPI indicators on ProClarity As this is a quite important issue if we could customize the size of each indicator, in many cases we would love to see very big indicators! Again, thought here is the best place I could think of to place this
-
- It's a computed column processing bug?
by Roman S. Golubin
- 3 Replies
- Last post
by Roman S. Golubin
- Hello everybody!
I have question about indexed and not indexed Persisted columns on sql server 2005. It's a bug
First , my version of SQL Server is
Microsoft SQL Server 2005 - 9.00.3186.00 (Intel X86) Aug 11 2007 03:13:58 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Now I create two tables and try four se
-
- Stupid Question in SQL Sever 2005 Report
by Kaveti
- 14 Replies
- Last post
by Kaveti
- Hi There
I have a report built in SQL Server 2005 Reporting. When i run that report i see the output question is, if i want to copy any column data like for example on 10th record i want to copy 2nd column's data. How do i do that. I want to use mouse to copy data to Notepad like the normal copy and paste data. When i try to do that i was not able to clicl on it. I can't seem to get this do
-
- SQL Query string (Probably easy)
by Fireemt12
- 3 Replies
- Last post
by Dhericean
- Need help with a query string.
I know this doesnt exist, but logically this is what Im looking for.
SELECT fieldname1, fieldname2 WHERE (fieldname1 LIKE ('%foo%', '%doo%', '%too%')) OR (fieldname2 LIKE ('%foo%', '%doo%', '%too%'))
To make this clearer, or maybe someone else has a better idea, I am using code on a web page to search the DB.
It takes the string entered by a user, say &qu
-
- SSIS BULK INSERT error: File Format doest not exist
by bjorke
- 6 Replies
- Last post
by Steve Wang 2006
- My colleague is working on bulk insert task from SSIS and since the data file does not contain any valid delimeter one of the suggestion he got is to use a file format to address the issue. Thus a bcp command is used to generate the format file, as per below.
bcp <database name>.dbo.<table name> format nul -T -S <server name> -n -f out.fmt
The file file format was
-
- MSSQL 2005 SP2 Upgrade Fails - DB Engine
by Dwebs
- 4 Replies
- Last post
by Dwebs
- Just downloaded and installed mssql 2005 sp2 on one of our servers
All components upgrade apart from the database engine. After the first upgrade i rebooted then tried to update the db engine again it failed for a second time.
Below is the error from mssql setup, any help would be nice!
Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 10
-
- update query? multi column key
by fbecker
- 4 Replies
- Last post
by fbecker
- Hi I have a question about an update query...
I want to set every Tool (described by toolId and toolGroup) as active, which has the highest timestamp..
I have a table Tools with a composite key of toolID and toolGroup with following columns (actually it has more but for simplicity sake..)...
toolID, toolGroup, tool_timeStmp, isActive
I have a select query which shows me eve
-
- sp_fulltext_database is unable to full-text index the current database
by NipunTomar
- 4 Replies
- Last post
by NipunTomar
- I am using-- exec sp_fulltext_database 'enable' to enable fulltext indexing on a database but query does not return any results, it just keeps on executing. I waited for about an hour and then cancelled. I dont know what is wrong. Can anybody please help me.... i am using SQL server 2000 on Windows Server 2003
SELECT SERVERPROPERTY ( 'productversion' ) retured 8.00.194
SELECT SERVERPROP
-
- Cdate conversion vs data from a cube
by Guillaume R
- 5 Replies
- Last post
by sluggy
- Hello,
I have a problem with date conversion when the date is coming from a cube.
I mean the function "=cdate(Fields!Signature_Date.Value)" works fine when the date is always fill in, but when my record is equal to nothing, I have got the value "#error" in my report...
Which is the best way to avoid to display this value in my report
I have used the
-
- Taking Data from another report?
by Keith O.
- 2 Replies
- Last post
by Lisa Nicholls
- Hey everyone,
I am planning on running a weekly report on a database that has its data overwritten every day. If i wanted to compare current data to data from the previous week, is there a way to save this report's information or something so that I will be able to pull it back up Thank you.
-
- Hidden Attributes in Report Builder?
by tenchyz
- 0 Replies
- Last post
by tenchyz
- I created a report model off of an Analysis Service Cube. And was checking out the report model with the report builder. Does anyone know if there is a way you can call hidden attributes into the report using Report builder
-
- Reporting Service webservice access denied Exception
by fbecker
- 1 Replies
- Last post
by h_w
- I am running SQL Express with Reporting Services 2005 SP2.
Installed both on with the NT-Authority\Network Service
I uploaded a report and I can execute it in the Report Manager.
What I want to do is execute the report via Webservice and stream the result as PDF.
Code Snippet Reporting.ReportExecutionService svc = new Reporting.ReportExecutionService(); svc.Credent
-
- check if there is an existing SQL server installation
by reggiepangilinanX
- 6 Replies
- Last post
by Deepak Rangarajan
- is there a way to check an SQL Server installation, i want to get the version and what edition the installed sql server is. thanks
-
- Great Plains database replication
by Robbie Page
- 1 Replies
- Last post
by Raymond Mak
- Our company has a database server (Windows Server 2003 x64 EE w/ SQL Server 2005 x64 EE) that has Great Plains installed. We have a database for one of our companies that I would like to begin replicating to another server. The reason behind this is that we want to run the GP/CRM Connector which requires 32-bit ODBC connections.
Anyways, what I need to do is enable replication to our 32-bit ser
-
- Datatype nvarchar(max) not accessible
by Werner Mielke
- 2 Replies
- Last post
by Werner Mielke
- Hi,
trying to input
create table T ( c1 nvarchar ( max ));
in MS SQL Server Manangement Studio Express results in an error :
Fehler beim Analysieren der Abfrage. [ Token line number = 1,Token line offset = 30,Token in error = max ]
create table T ( c1 nvarchar ( 4000 ));
is processed w/o errors.
I¡¯ve installed SQL Server 2005 Express Ed. SP2
Microsoft SQL Server
-
- Referencing Variables by Name
by Colin Macguire
- 10 Replies
- Last post
by Phil Brammer
- Hi there everyone,
A quick question. How do I reference variables (system and user) in SSIS by name instead of by just using a " ". The reason why I'm asking is because I'm trying to log what happens in a package to SQL, and if I cannot reference a variable by name it tries to insert variable values into incorrect fields
An example of the code I'm trying to use can be found
-
- Need to retrieve record count from CTE
by Mark Shvarts
- 5 Replies
- Last post
by Rob Farley
- I have a common table expression and I need to retrive first 20 records as well as record count.
select @first_name='m', @last_name='s'
with my_cte as ( select row_num = row_number() over (order by prosp_id, contact_num) , first_name, last_name from piza.prosp_contact where first_name like @first_name + '%' and last_name like @last_name + '%' )
sele
-
- Ad hoc reports multiple tables
by kutts
- 1 Replies
- Last post
by kutts
- HI, i am a new to SSRS and i am facing a problem with Ad Hoc reporting. actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report. i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associat