Answer Questions

• Corres SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog >>> This method does NOT require MSDTC. Now, the message got through. (The ears were listening but the mind was not .) Thanks, Barkingdog barkingdog wrote: I see, but after running more tests I found that putting the Execute SQL and DataFlow (INSERT records) task in ...Show All

• Atanu Maity Querying Analysis Services 2005 Cube with SSIS

  Hi, I've been trying to use Analysis Services 2005 Cube as a data source, query it via MDX and then use the data returned elsewhere in SSIS. However, I've been unable to get this working and can't find any information regarding how this can be done. Surely it should be possible when I can get this working even in Excel I've looked in December edition of BOL and no luck - have also sent a feedback to BOL regarding this and have been told that "it should be possible, since there is a way to send SQL queries to AS." However the person I was speaking with knew of no one who had actually tried this scenario and to try posting here. Any help as to how to get this done would be greatly appreciated. NR ...Show All

• mfareezaw Timeout exception during long running stress test

  Hi, We have built two testing apps for sending and receiving files across the network reliably using SQL Express as the database backend. The apps seem to be working fine under light load. However during stress test, we always get the following exception: "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." During stress test, both the sender and receiver are running on the same machine. Sender creates file fragments, store them in the sender database and then send out to the network. File fragments will be deleted from the sender database when the sender receives acknowledgement from the receiver. ...Show All

• Matt237 Parsing CSV name=value pairs into columns

  Hello smart SQL people, I have a field in the DB that contains name value pairs in the form of csv. Is there a neat trick (using a stored proc) to get it to be diplayed as in columns (maybe create a view around it or somthing ) EX. Select 'name1=val1;name2=val2;name3=val3' as MyData --> Returns MyData ----------- name1=val1;name2=val2;name3=val3 ============================================ How can i get it to return name1 name2 name3 -------------------------------- val1 val2 val3 Very nice but but i forgot to mention that i am doing this on Sybase 9 (Please dont say go post at the sybase forum :) ) I know the two are so similar but unfortuantly the cross apply is s ...Show All

• Gurpreet Singh Gill Compatibility of SQL Express Reporting Services with SQL 2000 Reporting Services

  I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end. One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows: Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets Does the resultant designed report end up in an RDL file If the customer published this report via the R ...Show All

• sohaibi Printing Graph report

  Hello I have a report with pie and bar graphs, I have the paper size 16.54 x 11.69 for landsacpe, there are twelve graphs ,two placed side by side , and in the report manager, the appearence is perfect ,spread over six pages. I have Pagebreakatend True for all the graphs. The problem is with printing, on printing , the are tottaly misaligned,any tips are welcome Thanks Inder No that is not an option, we should be able to print from the report manager and also from PDF I stumbled on the solution, separate the graphs by a rectangle and give page break at the end of the rectangle, also in properties ,check insert after rectangle Thanks Inder ...Show All

• rrowe007 extending SSIS Container?

  Has anyone investigated extending any of the SSIS Container classes I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute. I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them. We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself. Any insight appreciated. When package schedules the tasks, SSIS uses its internal representa ...Show All

• Chimme SQL SERVER 2005 DATABASE MIRRORING for large number of databases

  I am trying to enable database mirroring for 100 database. It goes error free till 59 databases (some times 60 databases) with the status (principal, synchronized) on principal. on the 60th or 61st database it gave the status (principal, disconnected). Also mirror starts acting abnormal. connection to mirror starts to give connection timeout and it is not enabling database mirroring on any more databases. I have SQL SERVER 2005 Enterprise with SP1 on the servers. witness is not included yet. these are my test servers... i have more than 500 databases on my production servers. principal and mirror both are using port 5022 for ENDPOINT communication. All of the databases are critical and all must be included in the Database Mirroring. s ...Show All

• rtaiss Reporting Services privileges

  How do I need to setup IIS and SQL Server to get reporting services to work When I navigate to http://<my server>/reports, I get a generic error page. PLease help! More info:  When I click "Set SharePoint administration group" from the SharePoint Central Administration page, I get the following: " Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com " The info in this KB article did not help. ...Show All

• Yolande single report with the data from "Multiple data sources"

  Hi, In my project i want a report. In that report data is getting from more than one data sources(systems). While creating data source view i used named query for both primary and secondary data source. But at the time of crating "Report Model" i am getting below error. An error occurred while executing a command. Message: Invalid object name 'Table2'. Command: SELECT COUNT(*) FROM (SELECT SerialNum, ModelNum AS com_model FROM Table2) t Is there any way to create a report with multiple data sources Yeah, Models look pretty version 1-ish... See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1828724&SiteID=1 >L< In my report i am using 2 tables. Table1 is in databas ...Show All

• IS dude WHERE clause does not work. Why?

  I am asking for help to resolve this simple problem. It is a stored procedure. It is supposed to return a single row from a table. The table may have max 300 rows but now there is only one row in it. When I execute the query in SQLEXPRESS in the New Query Editor Window with the correct parameter it returns empty row . set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CentrCtrl_SelectStats] @symbol varchar (10) = 0 AS BEGIN SET NOCOUNT ON; SELECT * FROM dbo.CenC_stocksStats WHERE symbol = '@symbol' END Now, I varied this simple statement this way and that way. I changed it into SELECT * FROM dbo.CenC_stocksStats WHERE symbol = @symbol with the same negative result: empty rowset . If I remove the WHERE clause ...Show All

• jamiec How to pass a table name as a parmater in SQL Task

  I am trying to execute an SQL task in a ForEach container that is the table name for a select statment I want to execute (table name is passed from a rowset created before the ForEach container). ForEach Container is looping correctly (I've used a watch to make sure each of the table names in the previous rowset are being passed correctly). I want to use the table name to execute the following query: Select count(*) as TableRowCount from MyLinkedServer... (with as the table name) Problem I am having is that the SQL Task Editor keeps placing a space between the last period and the parameter and then telling me it cannot parse the SQL. I tried: Declare @SQL varchar(255) Set @SQL = 'Select count(*) as TableRowCount from ...Show All

• LotusExigeS1 Unlock account from Management Studio does not work!

  Hi, I recognized that I cannot unlock an locked account with Managament Studio for SQL Server 2005 SP1 (Login properties). I need to use 'ALTER LOGIN'-command from a query window. I found old forum entries mentioned the same problem. Is there a time frame to fix this problem Maybe in SP2 or SP3 Wolfgang Kunk Can you please explain again the problem you are hitting Was the login disabled to begin with If not, then enabling it should not have changed anything. Enabling a login does not change its password. How did you determine that the password was set to '***...' Have you tried this password or just looked at how it is displayed by the UI The UI displays stars to hide the real password and the num ...Show All

• kangalert How do you pass data to a subreport in local mode?

  I know that to pass data to the main report in local mode you simply use: ReportViewer.LocalReport.DataSources.Add(New ReportDataSource("myDataSource", myDataTable)) But how do you pass data to a subreport inside of the main report I would expect a ReportViewer.LocalReport.SubReports collection or something but I do not see one. Using ReportViewer.LocalReport.DataSources.Add(New ReportDataSource("SubReportDataSource", SubReportDataTable)) did not work I found the example in the help and have reproduced it in a test web form (vb), but the event is not triggering. The main report loads fine. Here is the code I have to attach the event handler: Protected Sub Page_ ...Show All

• Mohammad Syed Password Property in ConnectionManager

  I'm developing a custom manager in SSIS that has several properties defined. One property is a password string that is visible in clear text in the properties pane. I'm trying to figure out how to create a masked field in the properties pane that will mask the text and not present this in clear text. Can someone send me instructions or code samples in C# for doing this BOL doesn't provide any information on doing this. Hi, we're facing the same problem, but haven't found any helpful information about it. This post doesn't really help with the issue not displaying pwds as plain text. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=887558&SiteID=1 Hope you guys can help. F. ...Show All