Answer Questions

• _M_ SSIS Excel source read problem

  I have a problem with reading data from an Excel file in SSIS. I'm trying to read a column that mostly consists of decimal values, but there are couple places where column entry is 2 numbers separated by a slash (e.g. "100/6.0"). SSIS tries to be smart and identifies the column data type as decimal and when it reads the cell with the slash in it, it reads as NULL. I tried to make my excel source reader component to read that cell as a string, but it gives me an error. If anybody has come across something like this, I would highly appreciate some help -Erlan Have a look at http://support.microsoft.com/kb/189897/EN-US/ It's the only way to "trick" Excel into seeing certain types. ...Show All

• here SQL 2005 long running job error threshold breached

  We are seeing, on a Test server running SQL2005 SP 0, several MOM alerts with the following type of message: "Description: The SQL Server Agent Job "test del" has breached the long running job error threshold of 120 minutes. The job has been running for 37429 minutes." These are all for SQL Server Agent jobs - some of them SSIS packages, others (like the one above) an invocation of a simple .bat file. Others are for SQL stored for BizTalk 2006. We have quite a few of these. Looking in activity monitor, we cannot find anything like these (with one exception on a BizTalk process that is 22 days old, and appears to be suspended). I suspect that this may be a state table or something that SQL is keeping, that has not been u ...Show All

• Ezira Outlook 2003 closes when you press print?

  when you press print in outlook 2003, outlook closes. Any Help You might try product support: http://support.microsoft.com/ Cheers, Isaac why by the hell did you posted this question in the " .NET Framework inside SQL Server " forum :-) :)....can't find any answers any were else or on the web Do you know the answer by any chance. ...Show All

• Javier Martinez Database mail configuration

  I have configured database mail using the wizard, but when I try to send a test message I receive the following error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 Exception Message: Cannot send mails to mail server. (Failure sending mail.) Is there some more configuration I must do I have enabled mail using the surface area configurator. Thanks Hi Tim, I had the same problem as yours and I solved it configuring the Relay options of my SMTP server. HTH, We are using SQL Server 2005 and its database mail option, not the old SQL mail that 7 and 2000 use. Sorry about that - ...Show All

• Shlizar Axis Alternating Lines for multiple groups in a table region.

  I have created a report that has two groups. I want to have alternating colors on the inner group. When I use the following expression: =iif(RowNumber(nothing ) Mod 2, "Red" , "WhiteSmoke" ) it does not work and I do no get my alternating lines. If I replace 'nothing' with either the name of the grouping or the table region name, I still do not get the lines alternating. Can you suggest how I may be able to solve this problem. Thanks YOU have to specify the group name within the group to make use of the alternation within the group: =iif(RowNumber("YourGroupName" ) Mod 2, "Red" , "WhiteSmoke" ) HTH, Jens Suessmeyer. --- http://www.s ...Show All

• barkingdog Breakpoint only works on first iteration in child package

  I have a ForEach loop that executes a child package. I want to examine the variables in the child package upon each iteration, so I set a breakpoint on a SQL task in the child package (OnPreExecute event - Always). It works for the first iteration, but on subsequent iterations it does not break. Shouldn'[t it also break on subsequent iterations (SP1 installed) Thanks. ...Show All

• Markus Sch. Access/Server

  How do you change the connection string of a DataSet We have been using MSAccess for our database, but have recently upgraded to SQLServer Express. I was able to successfully upsize the Access database and now all information resides on the server. In my VisualBasic program, the dataset itself has around 200 queries total spread out on multiple table adapters. The problem now is that none of these queries work because the dataset is bound to the Access table. I have changed connection string through code and am able to display the information, but am unable to interact with it until i get the dataset connection changed. I would rather just change the connection of the dataset somehow rather than build a new dataset, reconnect all form ...Show All

• Darren M. Bork Header on Matrix Rows

  Is there any way to add a header to a Matrix row in RS SP2 Much like a header for fields in a table. I have multiple row groups in my matrix and want to label them so as to avoid confusion. However, I haven't had much luck in finding a way to do this. What I have looks like this: Tasks, Users, Billing 01 Jan 2005 Time External Billing (￡) 1 to 1 2       SubTotal 5.25 270.00 6.2       SubTotal 1.50 0.00 10 South Way 1       SubTotal 3.50 245.00 106 Wetherby Road (Ian Mcleod) CS0344       SubTotal 0.50 17.50 I want to add a header to columns 1 and 2. Thanks, Corwin ...Show All

• cnugget0 Replicating Schema Changes

  Hi there, I'm using Sql 2005 merge replication and I have noticed something, I'm not sure if this is true or not:... My publication is set to replicate schema changes (replicate_ddl = 1). Now, I have noticed that schema changes are only replicated if the current snapshot is valid. Is this right If so why My next question carries on from the first. If I'm about to run a TSQL script on my publisher that will add a column or two to a published table, how do I ensure my snapshot is valid inorder for the ddl changes to be replcated Should I be using: EXEC sp_mergearticlecolumn @publication = <publicationname> , @article = <article name> , @force_invalidate_snapshot = 1 , @force_reinit_subscriptio ...Show All

• Ruben T xquery question

  I have imported the contents of a xml file into a xml data type. If I then want to return the values of a particular node as a relational data type, how do I do it I'd want to return every value for that element in the data type. Therefore multiple rows/elements. Therefore in the following xquery : DECLARE @x xml SET @x = ' <Root> <row id="1"><name>Larry</name><oflw>some text</oflw></row> <row id="2"><name>Joe</name></row> <row id="3" /> </Root> ' SELECT T . c . value ( '@id' , 'int' ) as id , T . c . query ( 'name' ) as NAME FROM @x . nodes ( '/Root/row' ) T ( c ) GO it ...Show All

• eldiener Jump to Report Without Parameters

  Hi, Is there any way in Rs2000 "Jump to Report" Action, to pass only some off the target report parameters, and when the report opens fill the rest from the target report parameter area I can make this work in VS2003 but not in Report Manager. In Report Manager when you click the link it just clear the screen and stays like that. Thank you for your help Rgranada i do have a crude way of doing it and i still looking out for the best way to do it. for example, lets take @Empno is the parameter and u want to make it optional so declare another variable like @ES when u r passing employee number , then pass @ES = 'S' ( means selected) when u do not want to use @EmpNO , then pass @ES = 'A' (me ...Show All

• ACCOUNTINGONLINE.US Need Help on this SQL Statement

  Hi All, sqlLstProds="Select * From PRODUCT_DEF "&_ "WHERE productID IN(Select productID From PRODUCT_DEF WHERE (IDProductCriteria = 5) AND ([Value] = '"&getSession("ModelID")&"')) "&_ " Order By IDProduct, IDProductCriteria" I have the above SQL Code in an ASP page. This queries the Product_Def table, however there is also a table called Product_sType, the primary key in that table is productID which corresponds to productID ub the Product_Def table. I need to add to the query a where clause, where active = 1 active 0 is obviously discontinued products, how would I do this So basically, it's somewhat of a join of some sort, like select * from Produc ...Show All

• cbpd86 SSIS does not recognize CRLF as the en of line

  Hi all, I'm having a strange behavior here, or maybe I'm doing something wrong, I'm not sure. Anyway, I have a csv file, the Flat File Connection Manager is configured like this: Row delimiter: {CR}{LF} Column delimiter: {;} For some rows in my file the last two columns are empty and the there is no semicolon for these empty rows but these rows are still ended by a CRLF but SSIS does not consider the CRLF as the end of the row, it consider the first 2 columns of the next row as the last 2 columns of the current row. Sample: CSV file: Col 1;Col 2;Col 3;Col 4;Col 5 AAAA;BBB;CCC;; AAA1;BBB1;CCC1;; AAA2;BBB2;CCC2 AAA3;BBB3;CCC3 Imported rows in SSIS: Col 1 Col 2 Col 3 Col 4 Col 5 AAAA BBB CCC AAA1 BBB1 CCC1 AAA ...Show All

• kennethmac2000 Why cannot others connect to my database?

  My system is windows server 2003,others' are windows 2000.I have set the connection as the document,but they still cannot see what in my database is. Thanks so much,I will try as you told. Have you made sure that the remote connections are turned on.. also do the users have permissions to connect to the database. I would try and use the odbc connection manager on the clients and try to make a connection, you will recieve an error message if they can not... When you get this message post it to us and we wil have a look at it. ...Show All

• Takashi Toyota Reporting Services installation question.

  I have installed Developer edition Sql Server and Reporting Services 2005 on my Windows XP machine (peer-to-peer network not domain). If I try to access the Report Manager home page ( http://localhost:8080/reports ), a login dialog appears but my own login is denied access, even though I am a member of the computer administrators group. If I change the access of the reports virtual directory to permit anonymous access then I can get to the Report manager home page, but of course there is then no site settings tab. In the Rpting Svcs Configuration, the following are maked completed: Server status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity (set to LocalSytem), Web service ident ...Show All