SSIS - ConnectionString Property of OLE DB Connection Manager

  • Good morning,

    My expression for the ConnectionString property evaluates with no errors but no connection is made at run time. Any ideas?

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • Found my answer which I already knew but I was just being stubborn!

    http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.connectionmanager.connectionstring.aspx

    It says:

    The format and contents of the connection string depend on the data provider, the data source, and the type of connection manager that is being created. To view a sample connection string, in SQL Server Data Tools, create a package, and then create a connection manager of the appropriate type within that package. Next, in the Properties window, examine the ConnectionString property of the connection manager that you just created.

    But my expression now looks like this:

    "Data Source=" + @[User::Server_Name] + ";User ID=" + @[User::User_Name] + ";Password=" + @[User::Password] + ";Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Gather_Server_and_Database_Information-{30870F9F-B4A8-4EFF-B6C9-0C2DFB43480E}" + @[User::Server_Name] + @[User::User_Name]+ ";"

    What's all this Application Name=SSIS-Gather_Server_and_Database_Information-{30870F9F-B4A8-4EFF-B6C9-0C2DFB43480E} nonsense?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • What's all this Application Name=SSIS-Gather_Server_and_Database_Information-{30870F9F-B4A8-4EFF-B6C9-0C2DFB43480E} nonsense?!

    Application Name is just an attribute that is part of the Connection String to SQL Server protocol which identifies the application that is connected to SQL Server, for example you can retrieve the list of applications connected to a server through the following DMV:

    SELECT program_name

    FROM sys.dm_exec_sessions

    The GUID at the end of the name is just an ID that identifies that SSIS package. You'll find it in the Properties of the SSIS package under ID.

    For a full list of keywords allowed within a connection string, check this out:

    http://msdn.microsoft.com/en-us/library/ms130822.aspx

    -----------------
    ... Then again, I could be totally wrong! Check the answer.
    Check out posting guidelines here for faster more precise answers[/url].

    I believe in Codd
    ... and Thinknook is my Chamber of Understanding

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

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