View Complete Post
I am getting an error while executing a SSIS Package from SQL Server Stored Procedure. But when I run it in BIDS, it executes successfully. Any help on this ???
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error Code: 0x80040ED. An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hresult 0x80040eD Description: "ORA-01017: invalid username/password; logon denied"
If I have the 'ExecutionInstanceGUID' value for an SSIS package that I know was started, is there a way that a stored procedure can programmatically determine whether the SSIS package still is running?
We are using SSIS 2005 and sql server 2005. My package has a boolean type package level variable. Eg: IsClientNull boolean type.
I call this package from stored procedure. In addition to passing values for other parameters, how can I pass boolean value.
My code is like this:
SET @CMD='dtexec ' +
'/FILE ' + @pShareName + @pPackageName + ' ' +
'/MAXCONCURRENT " -1 " ' +
'/CHECKPOINTING OFF ' +
'/REPORTING EW ' +
'/SET "\Package.Variables[User::StartDate].Properties[Value]";' +
CONVERT(char(10), @pStartDate, 120) + ' ' +
'/SET "\Package.Variables[User::EndDate].Properties[Value]";' +
CONVERT(char(10), @pEndDate, 120)
IF (@pClient IS NULL)
SET @CMD = @CMD + ' ' +
'/SET "\Package.Variables[User::IsClientNull].Properties[Value]";' +
I have a stored procedure insertXXX that has one OUTPUT parameter of type numeric. The stored procedure looks like:
PROCEDURE [dbo].[insertIntoTable]@outputID AS numeric OUTPUT
Can any body send code for how to execute a parameterized stored procedure using ssis dataflow script component transformation using .net
I know how to execute storedproc using control flow script task, but I need using ssis dataflow script component transformation.
Iam using 'Execute SQl task' which calls a stored procedure located in sql server database.The task's SQL source type is variable and the variable has the follwoing expression "EXEC PROC_SEL_MBO_REPORT "+@[User::V_SP_Job_Date]after evaluation it is like EXEC PROC_SEL_MBO_REPORT '01/NOV/2007'.It is working fine
Now the procedure is changed to Oracle.So I have changed it to "BEGINÃÂ PROC_SEL_MBO_REPORT " + "("+ @[User::V_SP_Job_Date]+")"+"; END"+";" after evaluation it is like BEGINÃÂ PROC_SEL_MBO_REPORT ('01/NOV/2007') END;.It is sucessfully executing from the task but no data is loaded into the tables which are used by the procedure internally.ExecutingÃÂ 'execute BEGINÃÂ PROC_SEL_MBO_REPORT ('01/NOV/2007') END;' is perfectly alright from SQl developer or sql plus.
Please help me.. thanks in advance
I am working on an asp.net application which uses quite a few sql 2005 procedures. Due to some change in requirement I had to modify a couple of the procedures.
During this change, I found that most of the procedures contain clause With Recompile, Execute As Caller.
I am planning to refactor the code in procedure but not sure if I can remove these clauses. Can any one please help me with these?
Thanks in advance.
I built an SSIS package using BIDS and saved it on a server.
I have other users of the DB that use SQL 2010 express. What I would like to know the easiest, or maybe the best way, to execute that package using SQL 2010 express?
If anyone can point me in the right direction that would be great!