Answer Questions

• Mary Lingel MSFT dts migration

  Hi, How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database Regards Nit This question is not related to SSIS. I'd try another forum if I were you. https://forums.microsoft.com/MSDN/default.aspx ForumGroupID=19&SiteID=1 -Jamie ...Show All

• denken Pdf Export using WebService- Error

  Hi, I am trying SRS2005 export into pdf using webservices,I got an error msg as below,any suggestions appreciated. System.Web.Services.Protocols.SoapException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for perform ...Show All

• Bertil Syamken BUG: SSIS imported package errors with 'Guid should contain 32 digits with 4 dashes'

  I have imported a package using SSIS into the Maintenance Plan folder from another server. It imports fine, but when i Modify the package then click save I get the following error : 'Guid should contain 32 digits with 4 dashes'. This has been reported on other forums without resolution. Pete Any news when this will be fixed Cannot create new maintainence plans from scratch in SQL 2005 ...Show All

• Michael Patrick how to get SQL SERVER 2005 NETWORK CONFIGURATION...

  hI ALL,   i wrote my problem before also...n it was I have installed SQL SERVER 2005 CTP,Version 9.00.1314 but the problem is...as soon as i m trying to connect..i gave the local server name as SHUCHI during the installation and now i m trying to connect to it... then it gives me error as : cannot connect to SHUCHI additional information: An error has occured while establishing a connection to the server . When connecting to SQL Server ...Show All

• Mohamed A. Meligy Query on Custom source Component

  Hi in the acquireconnection method Using the below statment I can get a connection Object oledbConnection = cmado.AcquireConnection(transaction) as OleDbConnection; from the connection object I can get the connectionstring from the object by calling oledbConnection.connectionstring() property which will have all the details like DataBase, UserName & other Inofrmation but there is no password Info. How to get the password I ...Show All

• Kees van der Oord Doing away with like '%%'

  Here's the setup @searchcondition varchar(50) --is a parameter passed into a stored procedure IF(@searchconditions is null) BEGIN SET @searchcondition = '%' END ELSE BEGIN SET @searchcondtion = '%' + @searchcondition + '%' END select * from sometable where somecolumn like @searchcondition Now the procedure is fine if the user passes a string, but if it's null, it seems really inefficient to search for '%'. ...Show All

• 83kwan Data Source from Informix

  Hi, I setup Informix driver 2.90 TC3. In my project, I create a data source by IBM Informix OLE DB. And the test connection is success. But I create a data source view, there is an error message as follow: TITLE: Microsoft Visual Studio ------------------------------ IErrorInfo.GetDescription failed with -2147024769(0x8007007F). IErrorInfo.GetDescription failed with -2147024769(0x8007007F). ------------------------------ I have no idea wher ...Show All

• Leddo How to encorporate IF

  How can I put an If statement saying If # RECORDS returned from the query below IF  # records returned is > 1 then     SUM(rmstranamt) AS  rmstranamt10   ELSE rmstranamt AS  rmstranamt10   here's my statement ------------------------- SELECT     RMSFILENUM,           rmstranamt AS rmstranamt10   <-----If statement goes here ...Show All

• ian1974 Problem with Client Side Printing

  After the Cumulative Security Update for Internet Explorer (912812) the client side printing doesn't work any more. Almost each client get the error: "Unable to load client print control." Other clients get an error with code '0x8007F304'. What can i do Will SP1 solve the issue Client Print is an Active X control. The security update may have disabled the ability to run Active X controls. Ch ...Show All

• John E Katich Teradata, SSIS OLE DB Source error (0x80040E21)

  I am trying to use SSIS to pull data from teradata to SQL2005. 1. When setup ole db source, firstly i setup the connection manager. I tested the connection to teradata, it prompted Okay without problem. 2. then, there are 4 types of data access mode for selection.     If I select view directly, it works fine for copy specific view directly. But if I select SQL command(or from variable), it will prompt an error msg as below Error at ...Show All

• ery Scripting entire DB to multiple files or comparing DB objects

  We are training ourselves to use the new SQL 2005 SQL Server Management Studio. One of the things we do regularly in the earlier SQL Enterprise Manager is to script out all DB objects to individual files. We then use Source Safe to compare the objects from one version of the DB to another to identify where changes have been made. In 2005, although you can script the entire DB, there is no option to create individual files for each object. ...Show All

• ChrisDurbin Programmatically creating .csv file

  Hi there, I got a user who is requesting a weekly report to be exported in csv (comma delimited) format.  But this process will run weekly using schedule job and he wants the file to save to a certain directory on the network.  Two part questions... 1. Is there a way to create a .csv file programmatically after runing the query 2. How would I save the .csv file to a specified directory on the network  TIA ...Show All

• moker Msg 3616 Transaction doomed, Triggers and Error logging

  I am trying to use the uspLogError and uspPrintError stored procedures found in AdventureWorks and I have a problem.  I have a stored procedure called Is_uspProcessLeads that processes some customer information that is in xml format.  Part of the process is to check to make sure that the xml is well formed and if it is validated.  Each step along the way, Is_uspProcessLeads updates a status field to indicate how far along in the p ...Show All

• micvos Problem in SqlServer while doing RDA....

  Hello, I'm developing a project using RDA. My mobile device has SQL Server CE and the server PC with IIS is set for this job. I developed a simple application at first, I wanted it to access a db named "MikroDB_V11_2005" and table "STOK" and when I put the .exe to the mobile device and run, I get an error in the server machine which says : "0x100061cc address referenced to 0x0000000.Memory couldn't be written. OK ...Show All

• S0nny88 Replicating Account Intelligence for a Financial Reporting cube

  Hi, I have the Standard edition of SQL Server 2005. I have created a Financial Reporting cube that has an Account dimension containing the company's Chart of Accounts. This dimension includes an AccountType attribute, which is used to determine whether each account is an Asset, Income, Expense etc. In order to report the different account types differently over time, I tried to add Account Intelligence using the Add Business Inte ...Show All