Answer Questions

• Graknil Executing an oracle stored procedure from SSIS

  Hello, Is there an oracle provider out there that will let me invoke a parameterless stored procedure that is in a package in my Oracle source Better could that stored proc receive a prameter Still better, could I use a stored proc in a OLEDB source component and get the resutls from its only out variable (ref cursor) into my SSIS dataflow I haven't been able to get any of these basic functionalities working with either the Or ...Show All

• Irenej How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. ...Show All

• Lazarus Darkeyes MSMQ & Integration Services

  I have a SSIS package in SQL Server 2005 that attempts to publish some data into a MSMQ Private queue located on another machine. While I was creating the package the connection string was pointing to the local server something like: localhost\private$\csin Now I'm trying to get to the remote machine but I'm not sure what type of connection string I need to enter: I tried: mw59\private$\csin where mw59 is the name of the remote mach ...Show All

• AndrewSiggemann Create and manage Store Procedures from inside VS

  With a local conn to SQL2000 I can edit sprocs no problem, but if I change the connection to a remote computer (to which I have all permissions) I cannot create or manage stored procedures from within VS IDE Is there a work around I noticed that a procedure written for the localhost accepts CREATE PROCEDURE and changes it to ALTER PROCEDURE. When I script the sprocs from my development machine to the server, those scripts with ALTER in them do ...Show All

• daxu failure in starting the process for the user instance

  High everybody, I have a set of winforms (.NET 2.0 assemblies) ( 6 total ) that each tries to open a connection to the same Database file using the same connection string. In the connection string, UserInstance is set to true. If each winform is started manually after opening the session on the computer, the connection to the database performs well for every winform. If the same winforms are automatically started at the opening of the u ...Show All

• Antonis Howto suppress FETCH output

  Hello, I'm opening a cursor with the sole purpose to select rows for deletion DECLARE test_cursor CURSOR FOR SELECT ... OPEN test_cursor ; FETCH NEXT FROM test_cursor WHILE @@FETCH_STATUS = 0 BEGIN IF -- check some condition DELETE FROM .. WHERE CURRENT OF test_cursor ; FETCH NEXT FROM test_cursor END For each row that is deleted sqlserver prints several lines of text with the contents ...Show All

• Mark Ainsworth problem with custom conflict resolution

  Hi Well.. I implemented the business logic handler. It was registered successfully and my table was changed to use this business logic. Below the part of the code I use: public override ActionOnUpdateConflict UpdateConflictsHandler(DataSet publisherDataSet, DataSet subscriberDataSet, ref DataSet customDataSet, ref ConflictLogType conflictLogType, ref string customConflictMessage, ref int historyLogLevel, ref string historyLogMessa ...Show All

• Yudhbir Sajwan Using Custom Code

  I have written a bit of custom code in the report parameters using a function that returns a unique value that I need for a textbox. After writing this code, it was my understanding that in the textboxes expression I could do =Code.FunctionName(parameters). When I type in Code.FunctionName, I get an error for "Unrecognized Identifier". Is there more I have to do for the code I am using SQL Server Standard. Could the version of SQL be ...Show All

• Roman H Unable to set Default Schema for a group

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on ...Show All

• milocr Import/Export causes fatal error- in Server 2005 Eval. version

  Have the 2005 Enterprise Evaluation version. Trying to import data from a flat file to DB table. Tried running wizard from designer studio and from creating a data flow in SBIDS Either way I am able to setup and start excution and then bombs with a fatal error. " SQL Server Import and Export Wizard has encountered a problem and needs to close. We are sorry for the inconvenience." Asks to Debug or close.. Tried installing on 2 ...Show All

• CaveMike Why I couldn't run the Transfer Database object Task with SQL Authentication

  Hi all, I have created a package to copy 10 tables from a database to another one. I have created a datasource with SQL Authentication mode. And it couldn't run until I changed the datasource connection to Windows Authentication mode. How could it be like that, it's just the authentication mode Is there anyone have the right answer for this situation thanks you very much It was a bug in SQL Server 2005 RTM. It was fixed in SP ...Show All

• Guard 2 data sources

  I am trying to create a report that creates 2 datasources - that are from differnent servers. I can get most everything to work, but on one page of the report I want to have information from both sets. Now a query like this will work =IIF(Fields!Master_Job.Value = 5536,123,0) but if I try to go to datasets and choose the same thing, it fails to work. =IIF(First(Fields!Master_Job.Value, "Set1") = 5536,123,0) I would eventually like to ...Show All

• Rup HowTo Union a given query across n duplicate databases

  I can't seem to accomplish my task of having T-SQL return a recordset that is Union of any given select query against n databases. I am working in an environment that has several databases with duplicate structures within the same SQL instance. The passed in SQL will be a select statement and I need the SP to return a Read-Only recordset. The code I think shows what I am trying to do. I can use any other approach as long as I can ...Show All

• ZaeSr Multiple Log Files

  Using an expression to set the log filename to include the date and time results in 3 log files being created. Ummm. Why I only ran the package once. Is SSIS not sharing my log file connection among the different components On first thought my workaround would involve using a script task to "set" the log file name to a variable and use an expression to set the log connection to the variable. But the problem with that is that logg ...Show All

• JacksonJones The path is not valid. Check the directory for the database.

  Hi My program in design time preview data and work with Sql Data Base (sdf) activesync connected device. but when run the program This message appear: The path is not valid. Check the directory for the database. help me thank you mahyar Hi! I am having the exact same problem! I am using the following tutorial to build my first mobile app: http://msdn.microsoft.com/library/default.asp url=/library/en-us/d ...Show All