Answer Questions

• OmegaMan FTP Task - Delete remote files always fails

  Hello, I have two FTP Tasks configured in my SSIS package. One is for "Receive files" and the other is set for "Delete remote files." Both use variables for the source/destination paths. My remote path variable contains a wild card in the name field such as /usr/this/is/my/path/*.ext and it is working to FTP all the .ext files to my working directory. I then rename the files and want to remove the original files from the FTP server. I use the same variable as the remote path variable in the delete as I do in the receive. Using the same FTP connection manager for both tasks I am always getting a failure on the delete. The FTP connection manger is setup to use the root user. Using a terminal I am able to open an ...Show All

• D.A.V.E. HELP !! HELP: Trigger to send REPORT !!!

  Hi all, Report Manager is failing to email out the reports !!! And... I can not use Report Manager to configure the trigger ! How can I trigger manually to have SQL 2005 email out the reports again OR how can I trigger to run those emailing jobs again Thanks, Frank Yes, I meant you could use Sql Server Agent or do as BenniG. Suggested and have an app call the FireEvent method Ok... let's say I want to use SQL Server Agent to run the job that can trigger the Report Manager to email out reports, do you guys have any documents that can show me how to do so I checked and ran some jobs under the SQL Server Agent, I don't see anyone of the jobs that were created ...Show All

• dig412 SQL-NS 2005 resources and 3rd parties

  Hi All, I am new to SQL-NS and the community of users. Can someone explain the difference between this forum and microsoft.public.sqlserver.notificationsvcs , in terms of scope, activity etc. Are there other sources for getting technical help, e.g. in MS Also are there 3rd party extensions, e.g. for channels (fax, print, SMTP with attachements) I saw http://www.microsoft.com/sql/ns/partners/delivery.asp but trying to follow the links got nowhere. Thanks, -- Shaul Dar ( shauld@medcon.com ) I was able to dig up another old link for delivery channel partners - http://www.microsoft.com/sql/ns/partners/delivery.asp . I don't know if it's being maintained, but at least the link works. :) ...Show All

• mikenwood [SQLCE Mobile]Do Select during Transaction

  Hi, I need to do a Select and after a Insert during a Transaction. But when i want to commit this transaction i've the following error message : The transaction can not be committed if there are any opened cursors in the scope of this transaction. Make sure all data readers / result sets are explicitly closed before committing the change. I don't understand this error message. How can i close my cursors. Before my Insert i'm closing my SqlCeDataReader and i dispose it. My SqlCeCommand are also closed and dispose. Do you have any ID Thanks. Hi Kardath, I tried to repro this here and could not reproduce the problem. I am able to have both INSERT and SELECT in a single transaction. C ...Show All

• Jeroen Bransen - J-Thread SQLServer dll's disappeared

  When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:\ProgramFiles\Microsoft SQLServer\90\SDK\Assemblies:  .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more.  How can I re-install these   Are they in the SQL kit, VB, SDK Any help would be appreciated.          If you need the SMO package and in common the feature pack you can use the following link: http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Jens - Thanks Very M ...Show All

• Sameep Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. D'oh! I forgot that :) Joey gives an answer how. You could also do: declare @query varchar(max) set @query = 'select col ' + cast(@param as int) + ' from table' Or if the column names aren't actually numberd, use a CASE expression to pick the columns. The question I have is why do this If all columns are only useful one at a time, this is probably a design issue. ...Show All

• HarrySimpson Windows and Forms Authentication issues

  I have a user who is trying to access the SQL 2005 server with 2 seperate accounts(using Windows Authentication).  With one account he can connect just fine, but with the seccond he recieves a logon fail error.  The only difference that we can tell is that the first account uses a password for our kerberos domain, and the second (that fails) uses a longer pass phrase (which does use spaces as characters).  My intuition tells me that shouldn't matter, but I've been wrong before.  Can anyone confirm this, or correct me if I'm wrong   This is using ASP.NET 2005 for the front end.  The exact Exception details are: "System.Data.SqlClient.SqlException: Login failed for user 'domain\user "  The stack tra ...Show All

• rheaney Open SSIS project error: Unable to cast COM object of type

  When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong TITLE: Microsoft Visual Studio ------------------------------ Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)). I've no idea but it seems some realated with the apartment for a COM object, maybe S ...Show All

• R1ZWAN Error while setting "Initialization" Configuration

  Hi, I have my pc setup with windows xp sp2. I installed the sql reporting successfully .I setup the configuration also successfully. But when i click on the tab "Initialization" it gives me this error. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help I tried to install it on another pc also. But no success. When i run the http://localhost/ReportServer/ it gives me same error. I have tried to install this on 4 pc. and same error on all the pc. I tried to look on the forum for this error. Tried to implement almost all the solutions but no success. This really frustrate me. I spend my 2 days for this. But still no success. Please help. ...Show All

• Jason Dam Problem when a IS tries to move data between servers

   Hello, I have a problem: I have created an Integration Services in SQL Server 2005 that moves data from a table in a server to another table in another server. I have set the protection level property to "don't save sensitive". The problem is when I try to execute it with a dtexec command. I get this errors: 'An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Communication link failure".' 'An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "TCP Provider: An existing connection was forcibly closed by the remote host.' 'An OLE DB record is available.  Source: "Microsoft SQL Native Clie ...Show All

• Mark Cryer Adding a user to only access data no adds/edits/deletes

  I'm hoping someone can get me pointed in the right direction we have SQL 2005 and I need to add a user account to let some only view the data no edits / adds / deletes can any one help thanks David Thank you can you tell me how to add & Map a user thanks David By default any created user and mapped user account is only member of the database role public. This role by default can’t Select, Insert, Update nor Delete anything. If you grant only Select to the user, he will only be able to select the data and will get an error message if he wants to do anything beyond that. (But don’t forget that the user will automatically inher ...Show All

• fafnir Get number of business days between dates

  Hi. Is there a way to get the number of business days or hours between two dates Also, is there a way to have it ignore weekends and U.S. holidays Thank you. The method described by Tom is the method that I have implemented most frequently; it is a good way to go. Thank you, Tom and Mugambo. Your suggestions worked. i am using this script to get amount of business days Code Snippet set datefirst 1 declare @sdate datetime declare @edate datetime select @sdate = '20070516' --for example, start date May, 16th select @edate='20070531' --end date May, 31st select datediff(day, @sdate, @edate)+1-( select (case datepart(dw, ...Show All

• crazyabtdotnet MSsQL2005; OPENROWSET, BLOB/IMAGE and STORED PROCEDURE problems

  All, I work with Microsoft SQL Server 2005 on windows XP professional. I'd like to create stored procdure to add image to my database (jpg file). I managed to do it using VARCHAR variable in stored procedure and then using EXEC, but it don't work directly. My Table definiton: CREATE TABLE [dbo].[Users]( [UserID] [int] IDENTITY(1,1) NOT NULL, [Login] [char](10), [Password] [char](20), [Avatar] [image] NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [UserID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] My working solution using stored procedure: ALTER PROCEDURE [dbo].[AddUser] @Login AS VARCHAR(255), @Password AS VARCHAR(255), @AvatarFileLocation AS VARCHAR(255), @UserId AS INT OUTPUT AS BE ...Show All

• Weixiao Fan How to make a File Share Subscription running on Vista?

  I recently migrate to Vista.   I had a bunch of reports with file share subscriptions that were running fine on XP.   After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager.   As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’.   I thought that this was the signature of a successfully configured subscription.   But surprisingly, there is nothing in the file share. The directory is empty.   Anybody has an idea why   Anybody knows how I could possibly find information on my ...Show All

• Dual Cortex Firefox Issues in 2005...

  Can someone please verify that the following items are not supported in Firefox. Our app issues an http request to the report server (url access). The following differences are seen between IE and FF: 1) The message "Report is being generated" does not disply in FF during report generation. 2) The printer icon does not appear in the toolbar. 3) Is there any plan to support search functionality within the report in the future Thanks. I'm not sure about #1 or #3, but for #2, client side print is only supported in IE. This is because the client side printing is done via an ActiveX control. Thanks Daniel. I'm recommending to my clients that the IE Tab add-on be installed in Firef ...Show All