Answer Questions

• yazoox Preview has data but no columns returned

  In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet Manmeet Panigrahi wrote: In my SSIS package, I connect to an external SQL server ...Show All

• Franco Finstad Cyclical dependency causes stack overflow exception

  If i have the following objects: create database cycle go use cycle go create view v1 as select 1 one go create view v2 as select 1 one from v1 go alter view v1 as select 1 one from v2 go and run the following smo script to get the dependencies (didn't include full code) I get a stack overflow error. Is there any way to catch this or check for it before it happens DependencyWalker dw = new DependencyWalker(db.Parent); DependencyTree dt = new DependencyTree(dw.DiscoverDependencies(urncUnsorted, true)); ...Show All

• NeederOfVBHelp Database Question, Scripting Vs. Wizard

  There are two ways to get access to a database from C#, for example, I can use SQL statement to create a table; I can also use SQL statement to read value from a table. Another way is to use the database wizard to create a table. One good thing with the database wizard is that you get access to the fields directly by intellicense and the fields are easier to bind with the controls. I am just starting learning database. The problem I see with the wizard, if your database changes. For example, right now I am using an access file about if that change to oracle or any other type. How can I approach that Will that be easier to modify. I want to know if scripting is better or using the wizard. What I like with the wizard is getting acce ...Show All

• detzX Matrix grouped by Day Part and Date

  I am wondering has anybody ever created a Matrix in a report grouped by Day Part (10-2 Morn, 2-6 Aft, 6-10 Eve etc) and Date I would like to see a report with an output such as 13/02/2006 14/02/2006 Total Morn Aft Eve Morn Aft Eve Mr A 2 4 5 2 6 2 21 Miss B 8 8 1 1 4 5 27 I have a DB table which records the datetime each time a viewer changes TV channel. The report is a summary by user of each channel change By Day Part with Each Date I can do this easily enough by just grouping on Date but now require another level of detail. ...Show All

• GS80 Copy & paste of custom task loses internal property settings

  We have a built a custom control flow task that we use frequently. It has a simple user interface form where we can set certain properties. Problem is, after I configure it once and then copy and paste it all of the internal property settings seem to be lost on the newly pasted task. When I open up the editor for the task all of the properties are displayed visually in the editor form, but the properties pane is empty. How can this be corrected I'm wondering if this is a SSIS bug or if the custom task needs some code to either prevent this situation or finish off the setting of internal properties Has anyone else created a custom task with a UI form that they can copy\paste without losing custom in ...Show All

• NewC&amp;#35; How to: Set up & interpret a model to predict Even Dollar Transactions

  Generally, what would be a good start to model and make predictions based on the following. Even Dollar Transactions – Including transactions that end in $0 or $50 with a Total Transaction Amount between $400 and $5000. I have a table called Transaction with a BillingAmount column. I've gone through the SQL Server 2005 Data Mining Tutorial (which uses a discrete prediction BikeBuyer yes or no) and read a lot of Data Mining with SQL Server 2005. Neither of these give good, complete, methodical examples of selecting inputs and targets and making predictions; especially for continuous columns. I think I'm generally struggling with the concepts of selecting (continuous ) predictable attributes and calculating predictions based o ...Show All

• Jean-Pierre Fouche SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh Each polocy type can share the same report layout, what do you mean a list these reports will be run by sysbatchuser through a dts program and using subscription to get to excel, so they wont be interacted with until they are already in excel. So that leaves me with having to use the master report to get a client number and then the subreport to get the ...Show All

• misiu_mietowy Week Commencing drop down

  Hello I hope someone can help me. I have created a report which draws back a 1 week schedule, at the moment the users need to use start (a date which is a Monday) and end dates ( date which is a Sunday) to get a weeks' schedule. How do I get one dropdown box which automatically has only Monday dates for Week commencing in it Thanks. ...Show All

• Evan Mulawski Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'

  I have started getting this new error after installing SQL 2005 service pack 1 whenever I start the SQL agent : Log SQL Agent (Current - 6/5/2006 12:28:00 AM) Message [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) I don;t see any problems because of it but would like to fix it because it is an error and might be affecting something I don't know about. Thank you. So, when will SP2 or a hotfix be released It would be nice to have database mail working. Thanks. yeah it is enabled. Still then Im getting the error. Is this a show stopper for Database mail not to work I can ...Show All

• cc151010 Analysis Services service won't start

  Can anyone point me in the right direction I haven't used SSAS in a few months and I went to start the service in SQL Server Configuration Manager and I get an error pop-up message: The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details. However the event log has no useful info - just says the service started, then it stopped - no error related info. There are no logs generated in ..\MSSQL.1\. Every other service starts - database, SSIS, SSRS, Agent, Browser and FullText. I'm running Sql Server 2005 (with SP1) on Win XP Pro (SP2). Any help appreciated! There were a few Information type events that said that Ana ...Show All

• Donaghy Page Breaks on Hidden Tables

  I am having an issue with page breaks on tables. I have 2 tables that I have set to PageBreakOnStart. They have conditional visibility. What I am seeing is that if i put an item in ToggleItem, the page break functionality does not work anymore. Is this by design I would have expected the page break to be there if the item is visible, and not if it is hidden. Any ideas Thanks! BobP Currently, RS doesn't support conditional page breaks. Any conditional logic will nuke the page breaks and there is no workaround as far as I know. Conditional page breaks are on the wish list for the next release. Hi Kimberly, Is this suggestion for the 2008 version coz i have done something quite similar in SSRS 2k5 ...Show All

• jzfredricks Convert DateTime field

  Hi, I'm not entirely sure that this is the correct forum for this question but it relates to my SSIS package. I am currently implementing an SSIS package to replace an existing stored procedure which is getting very unmanageable. I have come across a part in the stored procedure which performs a convert(datetime, @Parameter3, 14) on a string of data. The string value of @Parameter3 is in the following format HH:mm:ss. The problem i am having is how to implement similar functionality in a script task. everything i have tried involving the datetime object returns 1,1,0001, 00:00:00 or similar. It never seems to get the time so that it can be passed to a datetime field in the database. Thanks in advance for any help that is provided. Grant ...Show All

• PAULL ExceptionHandling in T-SQL?

  Hi all, Is there any concept of exception handling in T-SQL while writing Stored Procedures, plz. help me with this issue. I'm using SQL Server 2000 Thank you Robert :) To back up what Robert said, T-SQL did not have a rich set of error handling capabilities in 2000, whatsoever. You have to deal with the error message on the client end. So be careful to check for and close any transactions you might have started when you get error messages back and want to stop the batch. Hello Trid, No, there is no structural error handling in 2000 so to speak. There are several ways to perform error handling in 2000, with the most common being to test the value of @@ERROR for a non-zero value, then send control to a handl ...Show All

• Nick__A. is analysis services 2000 compatiable with sql server 2005??

  im trying to run analysis services 2000 along with sql server 2005 but with no luck. I can process the cubes no problem from within analysis services, but the problem is that the cubes are processsed each night via a dts package on the sql server side of things. when i run the package i get this error: Access is denied. the connection string to the repository needs to be specified in teh 9.0 server properties ( see <DSO>...</DSO> section in msmdsrv.ini file from analysis services 9.0). as im not using analysis services 9, that file doesnt exist. what do i do the error cant be with analysis services 2005, as it is not installed. all i have installed is analysis services 2000, a ...Show All

• thames Removing Rich Text formatting from a field

  I have a field where the data is stored with RTF. I know SQL Reporting Services cannot display it properly. Is there way to remove the RTF formatting codes through a function to just pull out the text and displya it in the text box place this code in your Code section: function StripRTF(ByVal rtf as String) as String rtb.Rtf = rtf return rtb.Text end function Add a reference to the System.Windows.Forms namespace and create a class instance of System.Windows.Forms.RichTextBox with an instance name of rtb I had a similiar problem and found this link helpful: http://www.4guysfromrolla.com/webtech/042501-1.shtml I just took the function provided in the above link and placed it in the Code section of my report ...Show All