Creating non-text ToolTips in code

Ken Spencer

MSDN Magazine September 2003

Paul DiLascia

MSDN Magazine October 2000

Jeff Prosise

MSDN Magazine June 2000

I am to create a bunch of SSIS packages for a customer who wants to maintain these packages afterwards with Business Intelligence Development Studio. To speed up the development process, I have started generating the packages from .NET code.
When I open my generated packages in Business Intelligence Development Studio, one thing is missing: Annotations on paths between data flow components.

For packages created in Business Intelligence Development Studio, output paths for components of type lookup and conditional split are (by default) annotated with "Lookup Match Output" (or "Lookup No Match Output") for lookups, and output name of the condition for conditional splits. This makes it much easier to read and understand the data flow.

I can easily annotate paths for my generated packages if I open them in Business Intelligence Development Studio and change the PathAnnotation property of all paths, but I strongly prefer to do this from my .NET code instead.

My question is: Is it possible to create a path annotation for the non-error output of a data flow component from .NET code? (I should note that error outputs of my generated components are always annotated, not that I am aware of having done anything specific to obtain this).

I the same issue or something close.

Except I have one Field (27) that get a trunacation error

Error:

Data conversion failed. The data conversion for column "Column 27" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

Data looks like:Red Text is the field that is throwing the error!

00000412,

0000000011411001,

0273508793,

01,

"RUTH           ",

"EDWARDS             ",

19500415,20080401,

"N",

04488013,

"1",

"F",

365094,

20080401,

000472162716,

"1447203880    ",

43995202341210,

Hello i want that site manager will create his own tables in the Database in 2 steps!!! the first one is to create table in the database the user can choose the name of the new table by textbox and the table get only one ID column:

SqlConnection newCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            newCon.Open();
            String st = "CREATE TABLE DataBaseConn.dbo." + tableName.Text.Trim()
                + "(contactId INTEGER PRIMARY KEY IDENTITY)";
            SqlCommand newCmd = new SqlCommand(st, newCon);
            newCmd.ExecuteNonQuery();
            newCon.Close();
            newCon.Dispose();

in the next step i want the user will add/insert the columns to the table (one column each time) the user will have textbox for the column name, drop down list with few kind of data type (datetime, int, varchar) and after press button the column will add to the table. ANY IDEA?????

Hi,

We have a requirement to connect to oracle from ASP.NET and we installed ODAC(ODAC1110621) components  on the server but still we are getting the following error while opening the connection. Please find the details below:-

OCIEnvCreate failed with return code -1 but error message text was not available.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.

Source Error:

Line 16:     {
Line 17:         OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["HRDBA"].ConnectionString);
Line 18:         con.Open();
Line 19:         Label1.Text = con.State.ToString();
Line 20:         con.Close();