Hi
Does anyone know how I can get the name of the connection in an ssis package using the package or connections object in c# code?
View Complete Post
I'm trying to read Connection Manager properties, but am stumbling when trying to access anything beyond the generic ConnectionManager objects. In it's stripped down format the code i'm using to read a Property is this:
string InputProperty = string.Empty; PropertyInfo PropInfo = null; // Uses System.Reflection to get property info foreach (ConnectionManager v in package.Connections) { PropInfo = typeof(ConnectionManager).GetProperty(InputProperty); }
However if i'm trying to read an input property that's specific to a type of connection manager, e.g. Flat File Connection manager property HeaderRowsToSkip, the above code fails as the ConnectionManager object only serves up a few generic properties.
Now, I assume that I need to cast or similar to get the IDTSConnectionManagerFlatFile Connection type... but at this point I get lost. Can anybody give me a helpful pointer?
Cheers, James
We have a custom connection manager in an SSIS 2005 package. We're able to click on "New Connection" in the Connection Manager section of the data flow task, and see the connection manager in the list. But how do we leverage this new custom connection manager as a source? The DataReader source doesn't seem to be an option anymore. We can't seem to create a new data flow task using this new connection manager as a source.
Ironically, the package runs as is after conversion from 2005 to 2008. It's just that we can't change it or add new data flow tasks using this new connection manager as a source.
I have a SSIS package which is run by Active bactch job daily morning and generate the three text file at different network location. But the sometime the package is failing during the execution with following error message.
" <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Times New Roman"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; m
hi,
actually we are planning to move data from GreenPLum data base to SqlServer 2005 data base using SSIS as ETL tool. What type of connection manager can we use. Is to good to use OLEDB connection manager or ODBC connection manager.
Please give me a reply as soon as possible.
thanks
sashikanth
Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.
Marcus Perryman
MSDN Magazine December 2008
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend