Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Using Variables in SSIS Tasks

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-12-02 : 14:49:40
hi all,
I have this procedure to remove certain characters from file names.

The SQL Task has this: exec dbo.spCleanseFileName @strFileName = ?, @strFileNameCleansed = ?

The stored procedure:
CREATE PROCEDURE [dbo].[spCleanseFileName](@strFileName varchar(40),@strFileNameCleansed varchar(40) output)

I have it in an SSIS package and my problem is that, after that SQL Task completes, the value for the
),@strFileNameCleansed variable is blank. I HAVE confirmed that the procedure DOES set the correct value inside the SP.

What am I doing wrong, please?
Thanks

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-12-02 : 17:00:22
This has been solved folks.
exec dbo.MySPname ?, ? output
Works correctly now Thanks
Go to Top of Page
   

- Advertisement -