Answer Questions

• Dz0001 Storage of packages: file system or Sql Server?

  HI, we are beginning a new project at my company and I was wondering where is the best place to save SSIS packages: file system or SqlServer. I have used other ETL products and they always create a repository on an RDBMS. Since SSIS offers us the choice of DB storage or file system, is there pros and cons of both approach Will the deployment of our application be simpler by using Sql Server since we would onky move metadata instead of files ...Show All

• VB_Devil Cannot create a report - VS 2005/SQL 2005

  I cannot seem to create a Report based on an SQL Server 2005 database. The IDE and the database server are on the same machine. The reports server is installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install. I create a reports project - when I right click the reports folder and select Add New Item > Report - nothing happens. When I invoke the Report wizard and continue till the last step - pr ...Show All

• Bob Davidson Accessing SQL Mobile Databases in VB2005 - Pocket PCApp

  I am using VS 2005 to develop a Pocket PC 2003 application and for some reason I dont have the ability to assign my datasource to a SQL Mobile Database When opening Server Explorer, right clicking Data Connection, Add New Data Source, Change Data Source, the only options I get are Microsoft Access Database File Microsoft ODBC Data Source Microsoft SQL Server Microsoft SQL Server Database File Oracle Database <other> I was trying to follo ...Show All

• Vasen_c Updating data

  Hello. Is it possible to somehow update data as it is copied from source to destination using SSIS. Currently I extract data from Database A, load it into database B, then clean/update the data in database B and then load it into database C using DTS on 2000. What I would like to do is extract data from database A, clean/update it, then load it straight into database C without having to load it into database B first. I am unable to c ...Show All

• Tyler Free Export a report to Excel : Data in a column become several columns

  Export a report to Excel : Data in a column become several columns When i export a report to Excel, the problem is coming, the report data that is in a column become several columns in Excel. Why the problem happens How to solve it. I have solved this problem! The solution is simple : i made the header's width equal to the body's width! [ May i ask some questions about you: Fang Wang is seemed to a Chinese name[王芳or王方]! Ar ...Show All

• Judah SQL Server Express 2005 vs. PHP 4.4.1

  Hi all, I've installed on my system(win2000 with all updates) SQL Server 2005 Express Edition, Apache 2, and PHP 4.4.1. The SQL Server seem's to work, I can run queries with Server Management Studio Express and with MSDE Query also. But I can't connect to the server with php, and I don't know why :( In php.ini I uncommented in the extensions section the line of Mssql. I've found in another topic, that another version of ntwdblib.dll ...Show All

• joeller SQL Server 2000 and SQL Server 2005 have the different behavior

  SQL Server 2000 and SQL Server 2005 have the different behavior when they close record set earlier opened from the same client application (used ODBC or DB-Library). SQL Server 2005 sends to client a large amount of data while SQL Server 2000 does not do this. Probably these data are the rest of the result set on the SQL Server 2005, which application did not read completely. The difference in query processing can be observed if the SELECT comma ...Show All

• WPF Fan Try Catch Block

  Hi: one of our study group members noticed a strange behavior and has the following question. Any thoughts are appreciated. I am unable to understand as to why the CATCH block is not executed when an INSERT is made On table T3 which is dropped after the first transaction. The severity of Insert into t3 values ( 3 ) is Msg 208 , Level 16 , State 1, Line 2 Invalid object name 't3'. BOL says ...Show All

• Martin McNally Hr=80004005 ERR:OpenDB failed getting pub version 28627

  I am getting the error " Hr=80004005 ERR:OpenDB failed getting pub version 28627 " in the SQLCESA30.LOG log file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory - the directory set up as the Virtual Directory in Internet Explorer. This occurs when I try to set up a .sdf file to be replicated to a SQL Server 2005 Mobile database (I'm following the instructions from the Microsoft Tutorial - ...Show All

• Dahl Berg Error using Datareader Destination

  Hi guys, I'm in dire straits here - really hoping someone can help me. I'm using a datareader destination and consuming it in a C# app. When I fire ExecuteReader on my DTSCommand object to return some data I get the error: "Could not obtain a datareader object from the specified data flow component" So we don't have a clue why this isn't working. Although...I'm intrigued by the line about "specified data-flow component". In the C# app you d ...Show All

• Lee Springthorpe AdventureWorks Sample Reports

  Hi folks, Newbie question. Anyone knows how to create dropdown selection boxes in a report just like in the Employee Sales Summary report Cheers! Moving thread to the Reporting Services Group If you install the sample reports, you can just open them in report designer and investigate the Report - Report Parameter settings in the VS menu. The Employee Sales Summary report uses a query to determine the ...Show All

• PrimeTime Is there a function like SUBSTRING but for integers?

  I'm wondering if there is a function in SQL that works like SUBSTRING function but for integers. Like for example if I have a number like 20010112 and I want to cut it to the first for digits so that it reads 2001 You use LEFT function. SELECT LEFT(20010112, 4) You should get 2001 This function works on string too. this left function is for string. if you pass in a integer, the integer value is ...Show All

• chvmadhav Why would sysconstraints and syssegments views do not show under system views in some databases

  I have no clue how this happened, I was getting an error altering the views, and I noticed in one database of mine sysconstraints and syssegments views shows under user created views , in other databases I noticed they are listed under system views section. How can I move sysconstraints and syssegments back to system views Thanks 2000 with sp4 Which version of sql serve ...Show All

• Bloke No 7 Why can't query analyzer be made to work for SQL 2005?

  I know my investigation is pretty light but it appears that DMO works fine against SQL 2005 (we use the same code to generate script against a SQL 2005 server that we do for a sql 2000 server). Why prevent query analyzer from being able to use the same DMO so that it works on SQL 2005. I really miss the simple ways of using query analyzer that I have become accustomed to and would love to be able to keep it in my toolbox foruse with both d ...Show All

• Ernie_Quest reportviewer control

  How do i Refresh a reportviewer control to have it reflect the changed RDL file in SQL Reporting services It sounds like the report is cached (maybe by your web browser) Try to clear the chache manually after the first output and then render it again... Hi, I tried that..but did'nt work out.In my app i have 3 dropdowns and acc'g to the selection s made in the DD's a RDL fi ...Show All