Answer Questions

• Kwey problems during the deployment phase

  I used the Business Intelligence Studio to make a report. I also enabled the tcp/ip protocol but during the deployment of the report i get the following error. I can see the report in Preview-Layout mode but i can t run the project. Could you help me Thanks In Advance =================================== A connection could not be made to the report server http://localhost/ReportServer$DVLP002_SQL2005/Reports . (Microsoft Report Desi ...Show All

• BillWestphal Data source synchronization issue: Connection string conflict?

  I was NOT using data source till now. I was directly using Ole DB Connection. Everything works as expected. Today, I created a new Data Source based on the existing Ole Db connection. I changed my tasks to use this Data Source. Now, everytime I open the dtsx file, a screen pops-up with title "Synchronize Connection Strings". It reads: "This package contains at least one connection which is based on a data source. The con ...Show All

• brizznady Error when using VariableDispenser in a custom task.

  Hello, I am building a custom component and am trying to access variables from within it. I have the following code: Dim vars as Variables = NOTHING Me .VariableDispenser.LockForRead("User::Variable") Me .VariableDispenser.LockForRead("System::ContainerStartTime") Me .VariableDispenser.GetVariables(vars) ... ... vars.Unlock()   It blows on the call to GetVariables with the following error: "Unable to cast COM object of type 'System_ ...Show All

• dvj81 SSIS Installation Problem

  I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install. Here is the setting: - I have WinXPPro SP2 - I had SQL2K and removed it - I installed SQL2k5 (as described above) I am getting the following error: Microsoft SQL Server 2005 Integration Services -- A component that you have specified ...Show All

• Grasssu SSIS SqlDumper Output

  Hi, I am posting this for a colleague of mine. Any thoughts or recommednations " Is there any way for me to analyze the sqldumper files One of my pipeline components is causing SSIS to dump and I'm trying to key in on what may be causing the issue. " Thanks, - Joel Do you mean SQLDmprNNN.mdmp files They are regular minidumps that can be opened with Visual Studio or WinDBG debuggers. If ...Show All

• Oridel Table control causes pdf Format skipping pages

  Whenever I use a table control a in report in SQL Server Reporting Services. When I save that report to a PDF format, every other page is  blank in a multipage report. Every other page is skipped. Has anyone else run into this problem thanks so much --- that has helped me out! Hi, I am using RS2000 with SP2. keeptogether = false is not working properly in a Table. If anyone else has run into this problem, Please s ...Show All

• Jack H cannot delete a scheduled job

  when I try to delete a scheduled job I just get an error. I'm using the administrator account. Any ideas delete statement conflicted with reference constraint "FK_subplan_jobid". The conflict occurred in database MSDB in table dbo.sysmaintplan_subplans column 'job id'. The statement has been terminated. Microsoft Sql Server error 547. I am logged on as administrator. Any ideas I think you need to delete the pla ...Show All

• Mark Arnott Scheduled Job Not Working

  I have created a scheduled job in the enterprise manager, which checks around 20 different date columns and replaces any non-dates with NULL using the following syntax: - update policy set [exp] =null where isdate (substring([exp],4,2)+'-'+left([exp],2)+'-'+'200'+right ([exp],1 ))=0 go update policy set [eff] =null where isdate (substring([eff],4,2)+'-'+left([eff],2)+'-'+'200'+right ([eff],1 ))=0 go update policy set [written] =null where ...Show All

• dlmac Dynamically positioning the Columns Based on User input.

  Hi, i donno how to dynamically place coloumns based on the user inputs. i m having a coloumn and that column should be appear in different places according to the report parameters selected by the user. now i m doing this by putting the same column in different places and by contrlling the visibility i m acheiving this. it would be better if i can change the coloumn position according to the user input, instead of having the s ...Show All

• Frank Melvin Stack With SQL Server

  Hi, I need to implement a stack using Sql Server. The basic table is simple:- id (int), val (char(10)). Basically I want a recursive EvaluateStack stored procedure. This should select the topmost value from the stack, and then either return it or (in the case of an operator) recursively call itself in order to get a left hand and a righthand operator. So: (pseudo-code) SELECT val FROM STACK WHERE id=@Count CASE WHEN val="+" lhs=EXEC E ...Show All

• Tommy Williams - MSFT What component to use for Calling View

  In SSIS 2005 what component can I use inside my Data Flow task to call my View and use it as a datasource I know I've used an Execute T-SQL Task but I don't know what component to use inside an actual task itself. What I'm trying to do is in my Data Flow task, instead of using 3 OLE DB Source components, I want to actually call 3 stored procs and use those 3 components as the data sources to merge on using the merge and sort components later on ...Show All

• Gholamreza Slow performance on subscribers

  Hello all! In fact the problem is not replication, but anyway i'm writting the message here, because in one way or another the issue is connected with replication. I have 1 publisher server pushing a merge replication to 12 subscriber servers. My biggest problem is performane of queries on subscribers. This happens to a big table (more then 2 million records) with 10 columns. This is a related table. Query is very simple: SELECT a,b,c FROM ...Show All

• Seb MARTY distributed database

  Hi ...i have to implement distributed databse.. what are the tools and components that i need to do the distribution and retrival i use SQL server 2005.... please help me....as soon as posible.. so argent thanks What do you mean by a distributed database ...Show All

• Sameer Simha Executing SQL 2000 DTS packages from VB.NET 2.0

  I have to build a simple Windows Forms application that imports data for review and then exports it into a different format. I've created DTS packages in SQL 2000 for the import and the export. What is the recommended way to execute the packages using buttons on a Windows form Thanks for your reply. I don't have SSIS available where I have to deploy the project. I must import and export data through ...Show All

• ryan031581 Installing SSRS 2005 while using SQL 2000 for metadata

  Does anyone have any install notes for installing SSRS 2005 and utilizing a SQL 2000 DB for metadata storage I am tring to seperate the Metadata and RS in hopes of load balancing RS boxes. At the same time I would like to save on the license by reusing one of my SQL 2000 licenses. thanks, CQ ...Show All