Results 1 to 2 of 2

Thread: SSIS DTEXEC Date Variables

  1. #1
    Join Date
    Jan 2013
    Location
    Kenya
    Posts
    1

    SSIS DTEXEC Date Variables

    I have a SSIS package will am executing by calling a store procedure. The script of the store procedure
    as below

    ALTER PROCEDURE [dbo].[Generate_TrialBalance]

    @TBDate varchar(50)

    AS
    BEGIN

    DECLARE @dtsExecCmd varchar(4000)
    SET @dtsExecCmd = @dtsExecCmd + ' /SET "\Package.Variables[User::TBDate].Properties
    [Value]";' + @TBDate

    EXEC master..xp_cmdshell @dtsExecCmd

    END

    When i Execute the store procedure like EXEC [Generate_TrialBalance] '01/01/2013' it returns no error except NULL in the result pane.
    Where am i going wrong. Note that the ssis package has a package level variable called TBDate mapped appropriately to a parameter in my oledbsource query parameter.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you print out @dtsExecCmd and double check? Does it work in dos prompt?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •