Dear All, i am creating a SSIS package that is executing successfully in 1 mints 30 second with dtexecui utility. But when i am loading same package with vb.net code package execute successfuly without any error but execute some starting tasks not all.when i am executing same package by using Threads all are going wel.can anyone explain me why package is not executing without Threads successfully.

Ghazanfar Ali Programmar (MSTS,MCPD)

i am working on Sql Server 2005 BI (Integration Services) can anyone help me how to set and get value of user defiend variables.I want to passed some variables like connection string,login,password and paramerters to Integration Task and i want to used that paramerter value in where clouse of my query......very welcome for quick reply...

Ghazanfar Ali Software Engineer (MSTS,MCPD,MCITP)

i think you can protect your database by right clicking on register server then change sa password,now when someone trying to open database it pop up for password window.

Ghazanfar Ali Programmar (MSTS,MCPD)

u include a checkbox in datagrid by defining its datatype boolean exp. dc = New DataColumn("Is Male") dc.DataType = System.Type.GetType("System.Boolean") dc.DefaultValue = false dc.ReadOnly = True dt.Columns.Add(dc) here dt is datatable.

Ghazanfar Ali Programmar (MSTS,MCPD)