Answer Questions

• mverma Have DTS Package prompt for a file name

  I have a user in the IT department that wants a process to take his text file and import it into a SQL Server table. Simple enough with a DTS package. The rub is that he want's to execute the package and have it prompt him at that point for where the file resides. I tried to get him to go into the DTS pacakge and update the connection, but he doesn't want to do it that way. I suggested renaming the file to a common name to be used each t ...Show All

• nwkrzysztf Filtering

  Hi All,       I am trying to filter on one of the dataset, but i have to do "today's date"... Fields!cur_prm_shp_dt.value >= "todays date" or Fields!cur_prm_shp_dt.value >= "systems' date" the problem with that one is that the system date view is in another dataset and does not join to the table that i get cur_prm_shp_dt from. Any suggestions Thanx ahead of time, Kerrie What do you need is a parametriz ...Show All

• Dock ADO.NET Source Custom Properties - Documentation Wrong?

  Ok, so I've looked near and far and have found nothing but info that says data flow properties can not be changed at runtime....then I see in this in the SSIS documentation under ADO.NET Source Custom Properties: SQLCommand String The SQL statement that the ADO.NET source uses to extract data. The value of this property can be specified by using a property expression. Pray tell me how this property can be specified using a property ...Show All

• radjayanti Bug in SQL 2005 SP1

  I am trying to chase this down and have noticed similar postings on the web concerning applying this SP. I have successfully upgraded all components except for the "database services" component. Has anyone been able to get beyond this Below is the log: 04/23/2006 09:24:53.523 ================================================================================ 04/23/2006 09:24:53.523 Hotfix package launched 04/23/2006 09:24:56.664 Prod ...Show All

• Blue9000 Exporting Tables from SQLExpress 2005 to SQLExpress 2005

  Hi, I just installed the latest version of VWD 2005 Express Edition and the latest version of SQL Express Edition 2005 and noticed that some stored procedure in the ASPNETDB.MDF file have been implemented. When I use my ASPNETDB.MDF file from the Beta 2 release, in the latest version, I cannot connect using my login info to the database... I receive an error message that the stored procedure is "to long.....". As I already created more than 35 T ...Show All

• tsgomez Report server in sql 2005 standard edition does not work

  i am using sql 2005 ..the management studio works fine but when i try to generate a report,it gives me an "out of memory exception" I tried configuring the report server in the configuration tool and when i try t oconnect the report server,it gives me the following error System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus( ...Show All

• crmpicco debugger doesn't stop at breakpoint while debugging SQLCLR function

  Hi, I have created one simple SQL Server 2005 CLR function in Visual Studio 2005 beta 2. It works fine from SQL Server 2005 management studio April CTP.   When I try to debug this SQL CLR function from Visual Studio 2005, I am getting the output in Output window along with debug information but it is not stopping at breakpoint. Output window says ‘No symbols loaded’. Could you please help me why it is not stopping at break point ...Show All

• Leo Cohn DataSet and Insert method

  hi, i created a query to insert a row in DataSet in Visual Studio 2005. i gave the method name to the query i created. as i understood it returns '1' if successful or '0' if not. is it possible to get the ID or the row instead Thanks a lot Jens there is no error. the point is i would like to get the id of the row that i insert instead of default int value. Hi, are you using a SQL 2k5 There is a new ouput clause in ...Show All

• trader Properties affected by Expressions

  Hi, is there any way to see which property is changed/affected by expressions If not that would make things really complicated because you look at a property and it seams to be OK but the task doesn't do what it's supposed to because "behind the scenes" the setting is changed by an expression... Thanks, To see a list of properties with expression, go to the same dialog as you set the expression. The first screen shows what is set, the " ...Show All

• MurtazaMM Using a parameter for the "IN" clause

  All, Having some trouble with getting the "IN" statement to return results from a stored procedure. I want to pass in a string of values, such as ('999999', '111111'), to my stored procedure and use it in a select statement. The SP looks something like this... @someNumbers [varchar](1200) SELECT * FROM someTable WHERE someNumber IN (@someNumbers) This doesn't return any data. How do I define something like this in the stored proc Thanks Mike ...Show All

• Sajay - MSFT Scipt to find size of cube

  I have a situation where i have to make report for N number of cubes daily.About their sizes and all.Does anybody face this situation earlier Can we write a Script for this Does any body have such Script Hello Its possible.The cubes are stored in the folders on defined drive like H:\Analysis Services .You can write a VBscript using filesystem object which can read the foldernames and its size and then it ...Show All

• Bhupathi Venkatesh Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (eve ...Show All

• TomGK2006 OLAP cube format

  Can the reporing services read the cube definitions (backcolor,forecolor etc.) the MDX contanins the " CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FORE_COLOR, BACK_COLOR, FONT_FLAGS " clause. Thank you Thank you Robert, but yet i'm using OLAP2000. We're intend to move OLAP2005 soon. So i understand i cannot access those properties with OLAP 2000... Shlomi ...Show All

• DamageInc How to create a cover page

  This seems like it should be a very simple task. I need to create a cover page that appears as the first page of all my reports. It contains a confidentiality statement and I don't want any other report information on this page. I created the cover page in a separate report to be used as a subreport in any report that needs the statement included. However, I have searched all over the Web (including this forum) but cannot find any info on how to ...Show All

• NewYoda SSIS Package runs in BI but not VB.Net

  I have a solution with 2 projects: Startup project is VB.net the other is a BI project with an SSIS package.  If I right click on the SSIS package in BI and choose execute the package works flawlessly.  No warnings, no errors, no nothing.  IF I try to execute the same package in VB.net using the following code: Dim dtsPkg As New Package Dim dtsApp As New Application Dim events As IDTSEvents Dim Res As DTSExecResult d ...Show All