Answer Questions

• Andeezle MySql SSIS Hangs with ODBC Drivers

  Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database. We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times. What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works ...Show All

• srini1122 Data transfer between Progress-SQL Server 2005-Oracle

  This will be a long post, but it is a complicated problem. Situation: We have 3 databases involved. Progress is the production database. SQL Server is the data warehouse. Oracle houses the combined financial data between Progress (via the data warehouse) and our other Oracle databases. Problem: 1. Data is imported successfully into SQL Server from Progress using a SQL script written by an INFOR technician Example: IF object_id ( 'insi ...Show All

• Devin G Is SqlServer Agent running?

  Hi, Can anyone give me some clues as to how I programmatically determine if Sql Server Agent is running. I'm using Sql 2005 and c#. I have found the JobServer property in the SqlServer object but this still doesn't tell me is the service is running!! Thanks for your help Graham this is really a useful class. but do u know how to obtain the machine name from SQL server name cos in my application, ...Show All

• Leon Bouquiet Restore Analysis Backup to new DAtabase Name

  I have backed up an AS database. Now I want to restore it to a new name so I have two copies to play with.  How do I do this Thanks, Chris Just an idea, I didn't have any time to try it, yet... But there is a way (as far as I remember) to script out a complete database... Save the script any modify it (i.e. the name of the database)... Then send the modified script to the server.. That might work... Change the file name of th ...Show All

• Sunil Hareendran (Error) Conversion from "DT_TEXT" to "DT_WSTR" is not supported.

  Below is the error I get when trying to convert a Visual FoxPro memo field to a DT_WSTR (4000 ) in a SQL table. It does not let me convert a DT_TEXT to a DT_WSTR. Thank in advance TITLE: Editing Component ------------------------------ The component is not in a valid state. The validation errors are: Error at NMF [Data Conversion [6328]]: Conversion from "DT_TEXT" to "DT ...Show All

• Rothariger ExecuteSQL Task with Parameters

  I have an insert statement that i am trying to parameterize based on a variable.  I have tried: INSERT MyTable(Col1, Col2, Col3) VALUES(1, @MyParam, 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4, @MyParam, 6) as well as: INSERT MyTable(Col1, Col2, Col3) VALUES(1,  , 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4,  , 6) The parameter is defined in the task.  It fails consistently.  The error in the output shows the SQL witho ...Show All

• SteveHagget Possible to set http://localhost/Reports default start report?

  SQL 2005 Is it possible to set a default start report I have a report which contains hyperlinks to all the other reports, I'd like to just load this one by default when a user hits: http://machine/Reports Perhaps I'm barking up the wrong tree and need to set this in IIS I want users to still be able to make their way back to the /Reports folder lists also. - Thanks in advance I would rather set a new virtual directory with pointing / redi ...Show All

• Sachin Shinde PackageID and GUIDs in ExecuteSQL task

  Am I looking at a potential bug here or do I not understand the feature properly I have an ExecuteSQL task that inserts into a table for logging and includes the System::PackageID as one of the values. It's stored in my table as a uniqueidentifier. When I set the output variable in Parameter Mappings tab of the Execute SQL task to VarChar, all works great. WHen I set it to GUID as the data type in that tab, it outputs a different GUID than the a ...Show All

• Mark Wilkins "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• Gene W Setting Permissions using Management Studio

  We're beginning to use Management Studio with some of our SQL Server 2000 databases and are having difficulty viewing and assigning permissions on objects to roles &/or users. Even though permissions currently exist they do not appear in the "securables" tab on the properties page. In order to view the various permissions you must first manually select all of the objects and they will then appear. Is there some way to get Managemen ...Show All

• Joao Lopes Second instance of Reporting Service cannot get to web page

  I am beginning to think I can't do anything right with Reporting Services. I was following Brian Welcker's web cast SS 2005 Reporting Services Management and Configuration. I have successfully created a second instance of RS (demo) and all is fine until I try to browse to the port 81 web site. I cannot see the web cast well enought to see what he changed in order to get to the demo site. http://localhost/reports get to the first instance of RS. ...Show All

• Kamran100 Authentication Problem x64

  Win 2003 Server x64, .Net 2.0 x64 Reporting Services 2005. RS Database is a remote SQL 2005 on the same Domain in the same room. I can only get the report manager to authenticate local users; it will not authenticate Domain users. If I set up a local user and add a New Role Assignment all works OK. I have no problem adding a Domain user to a New Role Assignment, it allows this, but it will not authenticate the user. Adding the Domain user t ...Show All

• Scott Lentz Migration from Cognos ...

  Hi, I've been asked to investigate for a client the migration from Cognos Decisionstream (7.1), PowerPlay and Impromptu (7.3) to SQL Server 2005.  Key driver (so far) is to reduce licensing costs.  I can't say I'm a Cognos guru.. so.. Has anyone done this / doing this / thinking about this What are the key benefits What does Cognos offer that we don't What are the biggest issues Did you have any problems What other items should I ...Show All

• Brijwasi SIngh SQLServer2005_SSMSEE.msi or SQLServer2005_SSMSEE_x64.msi ?

  A little guidance please. I have installed SQL Express 2005 and Web Developer 2005, and would also like to install the SQL management tool, but which one should I install SQLServer2005_SSMSEE.msi or SQLServer2005_SSMSEE_x64.msi My system is a DELL P4 630 3.0, 512, I'm not sure if this is 32bit & 64bit system.   Any help would be appreciated. Thanks Steve. That worked fine. Many thanks for yo ...Show All

• VJV Error:rsErrorReadingNextDataRow

  An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow) Please Help!Thanks! Even i m facing same problem at client place. Did any one find the solution for this I guess this error might be related one of the following two things 1 Connection. I am able to reproduce this error only when i disconnected the network during report g ...Show All