Answer Questions

• 48050 Blanks in columns

  Quick Question I hope. Does having a lot of blanks in a column cause errors In 2 or 3 packages where I get 95% of the data in the Error Colomn I can find nothing wrong with the data at all it all either seems perfect or there is no data in the column in question usually I would have maybe 800 rows where data would have been inserted but in the other 40, 000 rows the column is blank Using the "Retain null values from the source as ...Show All

• beigewy Determine if Service Pack 1 is installed on SQL 2005 ?

  How can I determine if SP1 is installed for SQL Server 2005 TIA select @@version Frank Since this is the SSIS forum, I thought a SSIS specific method my be usefull. Since you don't have to install the DB engine, you may just have SSIS installed, so the normal @@VERSION does not work anymore. One method is to check the File Version of the SSIS Service, C:\Program Files\Microsoft SQL Serv ...Show All

• star_spark RS Web Service

  Hi, I am getting the following error when tries to call any web method of ReportExecution2005 Web Service from a 2003 Web application. "Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/01/12/reporting/reportingservices/LoadReport ." Please someone suggest me how to fix this issue. Thanks Anobe Let's back track - First what is your environment: Your web ...Show All

• mustafa1974 Vista 5270& user instance mode

  Is there any means to enable "user instance" mode on Vista for sql express Thanks. ...Show All

• Lizard1850 The target service name could not be found.

  Hi : I am creating a queue application using Service broker. I was able to send and receieve messages between 2 databases in the same instance. Now I am trying to communicate b/w 2 different instances. I am getting the following error... The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied.. The routing informations is as follows DROP ROUTE ...Show All

• Mark Garcia SSIS EVent driven query

  Hi, We have 8 SSIS jobs which need to be made dependent on the arrival of a single file. All the flows need to be triggered based on the presence of a file Whats the way to do this Thanks Manish You couldI would use the FileWatcher Task to watch for the file. When it arrives, use Execute Package Task to fire off your 8 packages. To be honest, it depends on you. Do you want SSIS to ...Show All

• Thom_ Identity field settings not copied by Import Wizard (2005)

  It appears that when you use the import/export wizard from within Microsoft SQL Server Managment Studio, the identity attributes of the table being copied are not transferred. For example, say the source table has a column [ref] [int] IDENTITY ( 1 , 1 ) NOT NULL, When the import wizard is done the destination table will have a column named ref, but will not be an identity column. The column definition will be [ref] [int] NOT ...Show All

• vmit Parameter Questions

  Good day! I have a question regarding the parameters. when you vreate a parameter. is the default view in the webforms is in the combo box type is thier anything that when you create a parameter and the view in the webforms is not in combobox. is thie can we used a check box or other controls Hi, The default is textbox ...Show All

• troubled How do you pass a T-SQL parameter into an SSIS package at runtime to get the right data to dump into an OLEDBDestination?

  How do you pass a T-SQL parameter into an SSIS package at runtime to get the right data to dump into an OLEDBDestination For instance. I have a query that get data out of a number of different tables depending on what a particular _id is in the parent table (they are all linked through primary and foreign keys). I need to pass this _id into a package at runtime to get the proper data to dump into an access db. can any one give me any ideas ...Show All

• RobertaK How do I control the order of SELECT query result?

  I got a table which has a primary key, say, 'PartNumber'. A large portion of whole records have part numbers starting '#' letter. When I run 'SELECT * FROM myTable', the result set returns '#Parts' first and then alphabetical parts. I can use 'ORDER BY' but reverse order is not what I want. I want alphabetical part numbers first in order and then '#Parts'. Like executing two separate queries of following: SELECT * FROM myTable WHERE P ...Show All

• Yoni Raziel Calling report from other machine (without domain)

  Hi: I have an stand alone win2k Advanced Server (without domain). I created a folder (rpp) an I upload all my rdl reports.    Now I can see all reports in my server but I can’t see them in other machines IE show me a message asking for a user, password an domain but I’ve not domain in my server. Sorry, but It’s my first time using reporting service and IIS at the same time. Thanks   ja Can you (or anyone) go i ...Show All

• retuchntousender suppress the display of a txt box when null

  I have a text box in a list, which i only want to display if it is not null. How can i do this in reporting services. thx la Yes, you can conditionally set the visibility on both the row and / or group based on the value. Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. That's all You m ...Show All

• agnerc I'd like to get a good book of SQL...

  Would all of you give me a suggestion of valuable book in terms of SQL I confused what kind of SQL book is going to be good for me to study since I begin to jump into MS-SQL... Furthermore, I'd know that various level of book as begginer, intermediate , advance... Thanks for your help in advance.. In my opinion the best T-SQL book is The Guru's Guide to Transact-SQL by Ken Henderson http://www.amazon.com/exec/obido ...Show All

• kscdavefl source database information

  Hi, Yet another question. Where do reports store information about connection strings to their source databases and credentials that are used to access those databases. So far I have only found that report rdl file contains info about data sources, but it's in format: <DataSources>    <DataSource Name="ExperimentSource">       <rd:DataSourceID>xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&l ...Show All

• New to VB General Network error

  I am using Windows Form with web service, I am getting error ocassionally when I am accessing records " System.data.sqlclient.sqlexception General Network error " , When I click again the error disappears. The information here is really not sufficient for us to help figure this out.  Can you give us some more detail as to what your configuration is   Are you running .Net 1.1 What version of SQL Server are you running It c ...Show All