Answer Questions

• Hassan Ayoub smtp test

  hi, would you know how to know if a connection can be established to an smtp server without even issuing any smtp command i want to be able to do this using ssis, script component. thanks. thanks loonysan. but what i want is to just check if i can connect to the smtp server without even sending an actual message. this is just a pre-validation method. Do you want to just check if you are able to ping SMTP server at port 25 before sending an email. May be evern after that kind of validation -you might have to still use TRY/CATCH block in the script task or use OnErrorEvent Handler while connecting to the SMTP Server to catch any kind of exception emerging out of SMT ...Show All

• LSATL Survey Application: Multiple Charts on one Report

  I have written a custom survey application and am currently using ZedGraph in my reports for charting purposes. For example, let's say the survey contains ten questions...the report would then display each question and a tally of the answers for each question. Along with the tally I am producing a chart that serves as a graphical representation of the answer tally. Example: Question 1: What is your age range 10-20: 15 21-30: 20 31-40: 35 41-50: 3 <<Bar or Pie Chart goes here>> Question 2: What is your gender Male: 50 Femaile: 23 <<Bar or Pie Chart goes here>> Right now I am using a stored procedure that returns two datatables (into a dataset). The first datatable contains the questions, and the second datatable cont ...Show All

• Bert Lefever Clustering failure on install

  Hi, Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster Thanks adminup, did the article help You can certainly post here about any clustering issues you may encounter. The SQL Server 2005 Failover Clustering whitepaper will be released soon (and has full install instructions with screen captures). As far as prereqs, the link that was provided is good. But make sure that your Windows level cluster is rock solid and tested before installing SQL Server. The security is a bit different with SQL Server 2005 failover clustering, so pay attention to that. Other than that, the install itself is ...Show All

• e.henriquez MS SQL Express 2005 Client?

  hi to all, newbie to ms sql here. i just installed the free sql express edition and i do not know what i need to access the database... shouldn't there be a gui somewhere that shows how to create, edit, connect, to a database thanks in advance hi to all, thanks for the reply. just finished downloading the 240 mb download! yep, there is the client gui there. thanks again! phil You can also use the Visual Studio Express Editions to access SQL Server Express if you already have these. Or use sqlcmd Download the SQL Server Express Managment Studio: http://msdn.microsoft.com/vstudio/express/sql/download/ HTH, jens Suessmeyer. --- htt ...Show All

• Jagoop create global temporary tables in SQL SERVER

  I m trying to create a global temporary table whose data will be deleted after the end of the session.. the DDL in oracle is CREATE GLOBAL TEMPORARY TABLE STUDENT ( name CHAR(20), ) ON COMMIT DELETE ROWS ; I want to know the corresponding DDL in SQL Server.. when i try the following CREATE TABLE ##STUDENT ( name CHAR(20), ) the table gets deleted at the end of the session..help needed There is not such a thing. You can create a permanent table and include in it's key the process_id value (which you can get from @@spid). Then you just delete the d ...Show All

• Stephen Craig SQL server 2005 express and MS Project 2003 server

  Does anyone know how to install MS Project 2003 along with SQL Express 2005. Looking at the Req ( http://www.microsoft.com/office/project/prodinfo/serverreq.mspx ) for project server I do not think that it will work with Express, You will need SQL Server analysis services for some of the functions, and from memory you might also need the full text options. You really need to talk to the Project Server guys about what you are tring to do as it looks like the functions that are in Project Server and SQL Express do not match up. Also on the Min Req SQL Express or for that fact the older MSDE are not listed. I can not find a specific support statement about Project Server 2003 and SQL Server 20 ...Show All

• SteveC_65 Problem with data-driven subscription

  I have a data-driven subscription that launches once a day and delivers emails to subscribers. The problem is that it delivers only about half the emails. It runs ok and then it produces error. I ran it once and it ran ok and completed without errors. 20 minutes later it produced errors. Log looks like this: ReportingServicesService!library!c!11/16/2006-10:27:45:: i INFO: Call to RenderFirst( '/Subscribed notifications/Subscribed notifications' ) ReportingServicesService!library!11!11/16/2006-10:27:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzIn ...Show All

• Jessica Alba Variable Value: How do I set it from value in flat file at runtime

  I have a number of DTS packages I am trying to convert and am totally new to Integration Services. I have a flat file that I reference to get a date that I use in some SQL statements in the package. It seems like the best way to do this would be to create a variable to hold the date and set it at run time from the flat file. I've been searching the documentation and the forum and can't figure out how to do this. This is so basic that I feel like an idiot putting it on the forum but I need some help. This whole Integration Services thing is a big shift from DTS (which I eventually became pretty good at) Now I'm back to ground zero. Any help would be appreciated. If you can direct me to any basic training resources that would be cool t ...Show All

• Neo_xx range - left our join

  hi all, how can i do a range left outer join. i know how to do a ranged lookup but it does not allow null. example: suppose I have tables t1 and t2 in table t1 I have fields f1 and f2 and in table t2 I have fields f1, f2 and f3 I want to left outer join t1 and t2 on t1.f1 = t2.f2 and t1.f2>t2.f2 and t1.f2<t2.f3 in other words. t1.f2 is betwee t2.f2 and t2.f3 thanks, joey Is this an SSIS question Are you trying to do this in a lookup transformation yes, a range lookup that returns null when the look up value  is not in the lookup table. Do it with a where clause as a lookup SQL command SELECT FROM LEFT OUTER JOIN ON t1.f1 = t2.f2 WHERE t ...Show All

• shinoy Connect to SSIS Service on machine "Servername" failed: Error loading type library/DLL.

  Hi, Anyone who can tell me why I get this error ! I can connect to Integration services on the server from another client. Pls help //T I have the same problem from one server but it's working fine from another server. Scenario: Our developer have set up a SQL 2005 x32 with Integration Services. Everything works fine. I set up the production server (x64) clustered and without SSIS. Later on I installed SSIS and configured it according to the guide for failover clustering. From the "old" x32 dev sever we can connect to both SSIS instances but not from the "new" prod server. We get the same error as in the initial post. Ideas anyone http://support.microsoft ...Show All

• DreamingBear Analysis Services, msmdpump.dll and IIS.

  Hello: I have two servers, one hosting Analysis Services and the other just serves as webserver. I have configured msmdpump.dll on the Analysis Services server succesfully using basic authentication. But now I need the webserver to provide Analysis Services data. I thought that I would be sufficient to repeat on the webserver the same configuration steps that I folowed on the Analysis Services server and change the <ServerName> tag in the msmdpump.ini file to point to the last one. Well, this isn't working. What am I missing Is there any tutorial or resource to accomplished Some files inetinfo.exeRandomNumber.mdbp or .hdmp (c:\windows\pchealth\errorrep\userdumps) and RadomNumber.cab or.txt (c:\wi ...Show All

• John Sobernheim Gaining control over report parameters

  Hi All, I have not heard any news on this topic elsewhere so thought I would ask here.... I would like to gain control over parameters in terms of: 1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example. 2. Access to the parameter text via a custom assembly to support multi-langauge reports. I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now Thanks Hi Mark, this topic is discussed at length in the hitch hikers guide to report services...which is a very good book by the way...not sure if they are ...Show All

• DavidThi808 How to pass parent package parameters to a package executed by SQL Server Job Agent

  Hi, I'd like to know if there's a way to pass parent package parameters to a package executed by SQL Server Job Agent It appears that sp_start_job doesn't have any variable that could accomodate this. Hope to hear your ideas. Jon Limjap wrote: Hi, I'd like to know if there's a way to pass parent package parameters to a package executed by SQL Server Job Agent It appears that sp_start_job doesn't have any variable that could accomodate this. Hope to hear your ideas. Jon, If you use the cmdexec subsystem of SQL Agent (which you should always be using by the way - see here for why: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html ) then you will be able to pass in the values that you need using the / ...Show All

• TedCullen Control+Z when you design a package???

  Hi everyone, Is Microsoft thinking over the possibility to implement Control+Z in order to avoid drawbacks when you're writing a package I mean, when you drop a container then you aren't able to retrieve again . That same behaviour happened with Sql2k-dts. Thanks in advance and regards, enric vives wrote: Hi everyone, Is Microsoft thinking over the possibility to implement Control+Z in order to avoid drawbacks when you're writing a package I mean, when you drop a container then you aren't able to retrieve again . That same behaviour happened with Sql2k-dts. Thanks in advance and regards, Log it at Connect. I will def ...Show All

• Phuong Nguyen Tuan Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All