Answer Questions

• ibrahem "A Drawing Error Occurred" when Exporting to PDF

  Hello, I have a report that I need to export to PDF, when I do so and re-open the report, I get a message stating "A Drawing Error Occurred". Plus when I have a textbox with a large amount of data, it always kicks to a different page, instead of print what it can fit on the previous page and the rest on the next page. Any help on this would greatly be appreciated. Thanks in advance. ...Show All

• adandreamohr The package execution failed. The step failed.

  when i right click and execute the package from the Management Studio, it runs fine, everytime. When i schedule a job to execute it, it fails, everytime. "The package execution failed. The step failed." i have made sure that the package and job ran using credentials with more than enough access to everything. Still, with no luck. PLEASE! I am at my wits ends here, and the boss is getting antsey... Any and all help is greatly a ...Show All

• Clark008 Report model GetUserID() function

  Guys, What is "GetUserID()" function returns when the report server, report builder and everything is using windows authentication http://msdn2.microsoft.com/en-us/library/ms156292.aspx Enkh. "Just use USERID" What do you mean USERID Is that a global variable, windows authentication username Enkh. Just use USERID I don't really unde ...Show All

• Jason Presley Error Msg 141 on Bulk Insert

  I've got the following SP to automatically insert all files in a directory into the database: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE Imp_Header_PO_sp @FilePath varchar ( 1000 ) = 'D:\EBT\Outbound\' , @WIPPath varchar ( 1000 ) = 'D:\EBT\Outbound\WIP' , @ArchivePath varchar ( 1000 ) = 'D:\EBT\Outbound\Archive' , @FileNameMask varchar ( 1000 ) = '*Header.tx ...Show All

• Manasa SQL Mapping Almost Complete

      I created my SQL databases and my mapping schema to bulkload my xml files.   I’m able to bulkload into the Pdata table without any problems. My Claims table adds one line to the table with the B110 ID number, but no other data is uploaded.   I believe the problem is in my mapping of the SQL fields. Please take a look at the code below.       Th ...Show All

• rockinthesixstring Problem Installing AdventureWorksDB.msi

  I'm running on a stand alone machine. No network connections. I get the following error message when running this script: "Error 1316. A network error occurred while attempting to read from the file C:\Program Files\Microsoft SQL Server\AdventureWorksDB[1].msi" So how do I resolve this problem, so I can get the Adventure Works DB installed   >This often has to do with ...Show All

• project_tek MDQ Query Question: Passing sets into a function

  I've created a stored procedure that calculates the "Kendall's Tau" statistic when given a set as input. The result is a single Double value. I have an MDX query that works to return a single value for the set of data for a single sample site. What I want though is a query that will return the Kendall's Tau statistic for the samples from multiple sites. with set [data] as 'nonempty(crossjoin([Site Hierarchy].[Site Hierarc ...Show All

• Anonymous888888888kjhkiy098er6e5 SSIS Sequence container,data flow task

  I am creating a staging database in which I am loading required tables from 2 different sources. I have 30 different tables to load from source 1 and 10 different tables from source 2. This is the way I am doing, in Control flow task I am using Sequence container and in that I included the data flow task, the data flow task has source OLD DB connection from where I select the table and then destination OLE DB connection where I load the data ...Show All

• Azhar_kazi Proxy Account in Clustering server is not working

  Hi, We are having 2 node clustering server and insalled SQL server 2005. I have a requirement to run a job using proxy account. I have created a proxy account using my ID as a Credential and i'm part of admin. If i running a job uisng proxy a/c getting the ollowing error. Is there any work around on this issue. U nable to start execution of step 1 (reason: Error authenticating proxy xxx\username, system error: Logon failure: unknown ...Show All

• Dinesh Kulkarni General network error. Check your network documentation

  I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop. I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field. I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card. I have a test table with 10 images, not one more than 4 MB.  I cannot complete a test run prior to re ...Show All

• xx_Moe_Man_xx Problem with multiple datasets

  Hello. Here is the problem: There are 3 datasets in my report: ds1 ------- select id1,field11, field12.... from table1 where field11=@param11 and field12=@param12 .... ds2 ------- select id2, id1, field21, field22 from table2 ds3 ------- select id3, id1, field31, field32 from table3 ds1 contains a data for main part of report, ds2 and ds3- for it's tables. there are references: table1.id1=table2.id1 and table1.id1=table3.id1 i set values of @par ...Show All

• DeanFurness How to backup a database to a network drive

  It is OK to backup a database to the local drive (C:) on SQL Server 2005. But when I tried to backup a database to a mapped network drive (N:) on the server,  it failed. Here is the message: System.Data.SqlClient.SqlError: Cannot open backup device 'N:\db.bak'. Operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo) The network drive N: is accessible through Windows Explorer.  Currently, we ...Show All

• xanthom Fill label of chart X axis

  Hi! I have a report that diplay the sales per month from 2 date (start date, end date) passed in parameters. For exemple if the dates are 2006-01-01 to 2006-12-31 i want to diplay the sales for all the month between 2006-01-01 and 2006-12-31. Right now my graph display only month where sales exist. What i mean is that for this range of date my chart display only March april and may month because there are no sales for the other month. My proble ...Show All

• liquidPhix Error renaming analysis services project

  After renaming an analysis services project in bi development studio I receive the following error when deploying the project to SQL2005 AS (SP1): Error 1 The 'Database' with 'ID' = 'AS UPC Chain Sales ' doesn't exist in the collection. 0 0 However the database is available on the server and can be processed and used. Any ideas how to fix this error Try to rename your live database on the Analysis Server using SQL Management Stud ...Show All

• freddyboy Change query issues

  I am trying to take this statement: Select Total = SUM(gt) FROM (Select Distinct CustomerName, CustomerNumber, FeeGoal_AZ AS FG, FeeSchedule, (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt from DCR WHERE branch='00002' group by CustomerName, CustomerNumber, FeeGoal_AZ, FeeSchedule ) as dTable and change up (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS ...Show All