Answer Questions

• JSastre Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All

• Grant Jenkins How to access data in a SQL Command in the OLE DB Destination editor

  Instead of blindly inserting all my data from a previous task into a table using "Table" as the Data Access Mode in the OLEDB Destination editor. I would like to join this output with a reference table and insert only qualifying rows. Question is "how do I access the data from previous task so that I can do a meaningful equijoin" I know I have to use the "SQL Command" data access mode, but what next Thanks. chiraj No. You should just use a differrent OLE DB Source in the same data-flow and then join it to the LOOKUP output using a MERGE JOIN. Or you could use another LOOKUP. -Jamie well, I don't see that property. What I did was I dragged the ...Show All

• ntsoo Problem with connection

  Hi! I'm having a problem with my SQL Express 2k5 server. They people who have to connect, can't connect. But I am able to connect! I can connect using with auth. and also SQL auth. I see the databases with the proper permissions and I can access them. I use MS Access 2003 to connect to the server. They other people are also trying to use Access, PHP scripts and SQL Query Ananalyzer but they all fail to connecte. Can somebody help me to troubleshoot this problem If you are running it locally you might use the Shared Memory protocol which doesn’t have to be enabled for remote connections, because its a local protocol. For remote connection you have set the SQL Server to listen to TCP/IP. http://www.sqlserver2005.de/Share ...Show All

• Michael Barrett General printer settings not inherited by linked reports ...

  I have a general report that has been configured to print in landscape. Has been done through the "Layout" menu found under "Report\Report Properties". Everything lookes like expecting when I am printing this general report. Now I am creating a linked report - based on the general report from before. And I would expect this linked report to inherit the same printer settings as the general report, but this is not the case. Is this a misssing feature in the Reporting Services product or am I missing something Please ... There must be someone that are trying to print subreports. ...Show All

• Raulsassaa performance: memory usage: any way to flush memory?

  Hello, we are using SQL Server 2000 on Win2k3 machine we are having different sproc's that have a structure like: create table #tmp1 @query = 'insert into #tmp select from ......' if condition1 append where clause1 if condition2 append where clause2 exec(@query) while loop @query = 'update #tmp set col1 = (complex select stmt.....)' exec(@query) select * from #tmp drop table #tmp this proc is using multiple tables, some of them having records around 50k. when this sproc is getting executed, memory usage of sqlservr increases but when the execution completes, it doesn't reduce the memory usage though we are dropping the temp table explicitly. we even tried deleting all the records of temp table, before dropping it. s ...Show All

• Barry Kwok sql 2000 database restored sql server 2005

  I have a SQL 2k database backup and I restore it in sql server 2005. Is this now a SQL Server 2005 database or a 2K database in a 2005 server. Means do I need to convert databases somehow when I migrated from 2000 to 2005. Is the above mentioned way a way to migrate... or are ther some conversation tools. Any help / links / ressources would be Great... Felix Felix, The compat level does not change file format of your database. As Jeff said that was converted when you restored. Compat level sets how SQL Server processes certain syntax in your database that has changed over the versions, in case a sproc in your database depends on a quirk in a prior version it will leave your ...Show All

• Judoshiai Reporting Service Web Service from PowerBuilder 10.5 ...

  Has anyone implemented Reporting Service (Execution) Web Service from within Powerbuilder 10.5 I am trying to pass NULL value to the second argument of LoadReport function (to not get the History Snapshot) and the SOAP call gives an error message "String was not recognized as a valid DateTime". I could not pass Powerbuilder NULL (SetNull(StringColl) and StringCol passed as the snapshotID) value as the second argument to LoadReport as for some reason the Web Service could not be invoked. If I pass empty string (or 'NULL' string) I get the following error message. If I pass 'or '1900-01-01T00:00:00', then Reporting Service looks for a snapshot with this date and fails. Is there a way to send a string f ...Show All

• polymorphicx Package Variables Not Available at Runtime

  Hello, I have three package variables that I need to have access to at runtime. All three variables have package scope. The first two, 'StartDate' and 'EndDate' are DateTime variables. The third is called FilePath and is a String variable. I have taken the following steps; 1. Enabled package configurations 2. Set up all three variables as Parent Package Variables, and have targeted the 'Value' property for each. 3. In the properties of the solution, I have set AllowConfigurationChanges to True. 4. After the package was built, I ran the Package Installation Wizard from the Manifest. I have done both File System and SQL Server installations. When I go to run the package, none of the three package variables are available for modifica ...Show All

• Ragnvald SQL Server Agent (2005) Always runs default instance of SSIS package

  Hi All, I currently have a SQL Server 2005 (Standard Edition) default and named instance installed on the same machine. I also have SSIS packages with the same names in both instances. When I change the Configuration file MsDtsSrvr.ini.xml to point to the named instance server, I am able to successfully run the named instance packages from within Integration Services of SSMS. When I try to run the same package from SQL Server Agent (specifying the named instance server), it runs the package from the default instance. I know this because it is being logged and the logging happens on the default instance. Has anyone come across this issue or know if there is a known bug regarding this Any help would be appreciated. ...Show All

• jwraith Conditional Send Mail Task

  Hi, I want send email if certain conditions are met (by send mail task)... if compnay records does not exists in some table (returns null)... not task failure.... how do I achieve this without using Script task   does any one have an idea about it,   regards Zadoras wrote: In contiuation i would like to ask another question i.e. I want to send the results of my query (complete result sets) from email task How will I able to achieve the task. ur help will be appreciated Hmmm interesting one. probably the easiest way is to push that data into a flat file destination and then email that file as an attachment. -Jamie In contiuation i would like to ask another question i ...Show All

• Eric van Feggelen ADO Connection to MSSQL Server 2005... Need help

  Hi, at first a few things about my system: I use Visual Studio 2005 Pro on WinXP SP2 and I have recently installed MSSQL Server 2005 Express on my system. I want to establish a connection to the MSSQL Server from C++ (not .NET) using ADO. For this I use the following connection String: Open(L"Provider=SQLNCLI;Server=FREECASTLE;Integrated Security=SSPI;DataTypeCompatibility=80;MARS Connection=True;",L"",L"",ADODB::adConnectUnspecified); This works. But this is not exactly that what I wanted, because here just my Windows Authentication is used. I want to be able to pass username and password for users that are allowed to access the SQL Server. Here my first confusion begins: I have the option to pa ...Show All

• Rattlerr Many different tables sharing a unique ID

  Beginner's question: I have many unrelated tables, each with a unique "ID" column, but each ID must be unique in all tables. What's the best way to achieve this Thank you. You could have an ID bigint identity ( 1 , 1 ) column in your master table with another column into which you inserted a value and then use @@IDENTITY in the tranaction to get back the associated ID. Scalability becomes more problematic as you have more insert transactions in more tables inserting into the master table. All depends on your work load and resources. This sort of strategy was common in the past before identity was available. Another strategy is to create an identity column in each table an initialize each ...Show All

• Chintan Jhaveri Newbie question RS API

  Functions... lines that start with = Is there a list of these functions (switch, Iif, etc..) that are for RS online somewhere Something like a Java API for example Excellent! Thank You Teo Lachev! You can any use any VB.NET function (or C# if you use a custom .NET assembly). There are RS-specific functions . ...Show All

• dk.suresh Sending and checking Null value on IIF

  I Want to check if i have null value (not empty string) on param if it is null i would like to send back null value (not "") I Just wrote small code probably not correct How should i correct it =iif(Parameters!SelectedSite.Value.equals(NULL) ,NULL ,Parameters!UserSites.Value) Help me a bit... Where do you want to send/use the value Is it in an expression If so what expression of course, The checking goes good the sending is problematic... :( Does your parameter accept Null Values nop, I tried, nothing on returning in RS equals to "" (string empty) Do you have another id ...Show All

• Kunk how did you upgrade from analysis services 2000 to 2005?

  i have followed the instructions online ,on how to upgrade from analysis server 2000 to 2005. i install a new instance of analysis services 2005, called instance 1, migrate all the cubes over, but when it comes to using the rename instance tool, i get errors. there is a reg key missing i have found that stops this tool from working. how have you guys gotten around the migration from 2000 to 2005 thats the version of the instanceRename tool but when i try to rename an instance i get this error: Cannot open regestry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Sql Bin under HKEY_LOCAL_MACHINE Thats the only version of the tool i have on my server. I installed sql server 2005 enterpr ...Show All