Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - ConnectionString Property of OLE DB Connection Manager Expand / Collapse
Author
Message
Posted Thursday, October 18, 2012 3:31 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:08 AM
Points: 708, Visits: 3,286
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

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
Post #1374218
Posted Thursday, October 18, 2012 3:51 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:08 AM
Points: 708, Visits: 3,286
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

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
Post #1374231
Posted Thursday, October 18, 2012 4:16 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:57 AM
Points: 91, Visits: 163,984

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.

I believe in Codd
... and Thinknook is my Chamber of Understanding
Post #1374248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse