Post reply

Connectionstring & Variable Question

  • April 17, 2009 at 6:06 am

    #133180

    Hi

    I'm having problems setting up a connection string variable. I've created a connection in the connection manager. Set the svrname & dbname, checked that it works, then in the connection properties set the connectionstring expression to be the my connectionstring variable. This doesn't want to work though.

    The connectionstring is "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;"

    The error i receive is connection "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;" is not found.

    Any help would be appreciated. Are there any tutorials as to set connectionstrings as variables as I can't seem to find any.

    Cheers

    Lbob

    (I inadvertently put this in the Business Intelligence forum as well)

  • April 17, 2009 at 9:51 am

    #979765

    lbob (4/17/2009)

    Hi

    I'm having problems setting up a connection string variable. I've created a connection in the connection manager. Set the svrname & dbname, checked that it works, then in the connection properties set the connectionstring expression to be the my connectionstring variable. This doesn't want to work though.

    The connectionstring is "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;"

    The error i receive is connection "Data Source=DevSvr;Initial Catalog=DevDb;Provider=SQLNCLI.1;Integrated Security=SSPI;" is not found.

    Any help would be appreciated. Are there any tutorials as to set connectionstrings as variables as I can't seem to find any.

    Cheers

    Lbob

    (I inadvertently put this in the Business Intelligence forum as well)

    In which component do you see this error? From the error I can deduct you are setting the connection manager name because it tries to find connection with the name listed above. Try setting the ConnectionString property with expression.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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