Post reply

Make sure that the required parameter is set - error

  • September 4, 2015 at 8:25 am

    #302884

    Dear all,

    I'm trying to create an SSIS package job in SQL server 2014 but I get the following error when trying to change the Package source and confirm. I have alsredy checked the connection mangers and they were all successful, I'm not sure what I should be checking.

    "Make sure that the required parameter "name of parameter" is set"

    Thank you in advance!

  • September 4, 2015 at 8:54 am

    #1824698

    Are you using parameters for your source query?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • September 4, 2015 at 9:00 am

    #1824701

    Yes, I'm setting the source database to get the information and also a parameter for the destination sever.

    Thank you!

  • September 4, 2015 at 9:36 am

    #1824717

    Go to the parameters tab on the source and destination objects (not the connections) and define names for the parameters. If I remember correctly (as I don't have SSIS right now) for OLEDB you need to name them as 0, 1, 2,.., N.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • September 4, 2015 at 10:32 am

    #1824740

    Thanks for your reply!

    The parameters are all running fine. I'm only having the issue when setting up the job in SQL but executing the packages in visual studio all seem to be fine, any other thoughts where I might have missed please?

    Thank you!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply