Post reply

Parameterize connection manager not working

  • August 11, 2015 at 2:52 am

    #319694

    Hi,

    I am using project deployment model in SSIS 2012. I have a created an ADO.NET connection at the project level .The same connection shows up in my package and I am able to connect to the database in a data flow task.

    When I add a parameter at the project level for DbConnstring and parameterize the connection manager by using property ConnectionString = @[$Project::DbConnString] It says cannot connect using userid testuser.

    My parameter dbconnstring is a

    Data Source=testdb;User ID=testuser;Initial Catalog=TestDatabase;Persist Security Info=True;Application Name=SSIS-TEST.SSIS-{9F6B44D7-D4E5-41C3-82D9-3CE4F691B20E}testdb.TestDatabase;

    It fails to connect when I parameterize else it runs fine when I just use the connection manager with no parameters.

    Thanks,

  • August 11, 2015 at 3:19 am

    #1818822

    test user looks like a sql account , are your missing a password in your connection string

    Jayanth Kurup[/url]

  • August 11, 2015 at 3:40 am

    #1818832

    Thanks. I added the password it works now.

Viewing 3 posts - 1 through 2 (of 2 total)

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