Hi Team, I am basically DBA guy, i dont have exp in SSIS and C# Right we are migrating DTS- SSIS packages from 2000-2005 &08 also But iam facing prob in writing code in Visual Basic 2005 and C# How can develop these two programming skills for this reason only i am facing alote of prob Developers please guide me how can i improve to writing code what types of steps i have to follow i have time this weekend i need to learn some basic code please help me on this. Thanks subu

I would advise you to pick one language to start with, VB or C#. Writing for SSIS script task is similar like writing any other back end code, so pick any training and skip User Interface part.

you should not learn the Complete aspects of VB.NET or C#. but you can learn about scripting in SSIS with this book: http://www.amazon.com/Rational-Scripting-Integration-Services-Preview/dp/1932577211http://www.rad.pasfu.com

Hi Reza, thank you very much for your reply.. Can you please guide me some sample basic scripts it is really helpful to me.. small programs please help me Tx subu

There are two types of scripting in SSIS: 1- scripts which you write in control flow, you should use SCRIPT TASK for that. this is msdn link of script task with lots of samples: http://msdn.microsoft.com/en-us/library/ms141752.aspx 2- scripts which you write in Data flow, you can use SCRIPT COMPONENT TRANSFORMATION for that. there are three types to use script component: script component as source http://www.rad.pasfu.com/index.php?/archives/38-Script-Component-as-Source-SSIS.html script component as destination http://msdn.microsoft.com/en-us/library/ms135939.aspx script component as transformation http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx also there is another division in script component. this dividing is based on Synchronous or Asynchronous loading data in data flow: Synchronous script component http://msdn.microsoft.com/en-us/library/ms136114.aspx Asynchronous script component http://www.rad.pasfu.com/index.php?/archives/19-How-to-use-Script-Component-as-Asynchronous-Transformation.html there are samples on each links above.http://www.rad.pasfu.com

1) There are subtle differences between C#.NET and VB.NET in SSIS compared to original C#.NET and VB.NET. 2) Mainly the differences are when the SSIS properties , variables, columns,connections in SSIS are accessed in script. 3) Remaining concepts like variable declarations, assigning, functions, etc.,. remain the same. 4)Point to be noted is whenever there is SSIS thing in Script, the syntax (or rather a completely different syntax) comes into picture.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

Hi Team, I m getting below error. .please suggest me In OLEDB Source i have put read only in script task i checked where can i change data type but iam failed can you please suggest where can i changed it. the eror is showing readonly -- write only plz suggest me..and correct me. im in learning stage.. TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [Script Component [1]]: Error 30366: 'Public ReadOnly Property siteID() As Integer' and 'Public WriteOnly Property SiteID() As Integer' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'. Line 18 Column 30 through 37 Error 30366: 'Public ReadOnly Property siteID_IsNull() As Boolean' and 'Public WriteOnly Property SiteID_IsNull() As Boolean' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'. Line 23 Column 30 through 44 Error 30451: Name 'Output0Buffer' is not declared. Line 23 Column 18 through 30 Error 30451: Name 'AddRow' is not declared. Line 24 Column 17 through 22 Error 30524: Property 'SiteID' is 'WriteOnly'. Line 25 Column 27 through 36 Error at Data Flow Task [Script Component [1]]: Error 30366: 'Public ReadOnly Property siteID() As Integer' and 'Public WriteOnly Property SiteID() As Integer' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'. Line 18 Column 30 through 37 Error 30366: 'Public ReadOnly Property siteID_IsNull() As Boolean' and 'Public WriteOnly Property SiteID_IsNull() As Boolean' cannot overload each other because they differ only by 'ReadOnly' or 'WriteOnly'. Line 23 Column 30 through 44 Error 30451: Name 'Output0Buffer' is not declared. Line 23 Column 18 through 30 Error 30451: Name 'AddRow' is not declared. Line 24 Column 17 through 22 Error 30524: Property 'SiteID' is 'WriteOnly'. Line 25 Column 27 through 36 Error at Data Flow Task [Script Component [1]]: The script component is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Component Editor by clicking Design Script button to cause binary code to be generated. Error at Data Flow Task [DTS.Pipeline]: "component "Script Component" (1)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ BUTTONS: OK ------------------------------ subu

could you tell us more about your overall schema? did you used script task or script component? if script component , did you used it as source/transformation/destination? and what is your script exactly? paste the code here.http://www.rad.pasfu.com

Hi Reza, Thank u very much for ur help .. i m really sorry i am using script compentent Dim arr() As String = Row.Readings.Split(","c) Dim iReadingCount As Integer = 1 For i As Integer = 0 To arr.Length - 1 With Output0Buffer AddRow() .SiteID = Row.SiteID .ReadingID = iReadingCount .DateOfReading = System.DateTime.Now .Reading = CType(arr(i), Integer) iReadingCount += 1 subu

the question is : why you did this? seems you are going to have an Asynchronous Script Component! and my question is what is your case scenario? what you trying to do? maybe the asynchronous is not good solution for it. tell us what you trying to do exactly.http://www.rad.pasfu.com

Hi Reza, iam taking oledb souces and script task oledb destination. in source table all rows transfer to destionation.. this is the situvsaction. subu