Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSIS DATA FLOW
Add to briefcase

SSIS DATA FLOW Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
sathiyan00
Posted Monday, September 03, 2012 11:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:34 AM
Points: 60, Visits: 325
Hi all,
I'm new to sql server,so please help me to know about this.

1) whether the ssis package will process 1 row at a time or whole rows.
(i.e) it will take one record and process all the transformation then next or it will take all rows and process in each transformation.

2) how to assign a value to a variable at run time after each row processed.


Thanks and Regards
Sathiyan
Post #1353712
rhythmk
Posted Tuesday, September 04, 2012 12:02 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603
sathiyan00 (9/3/2012)
Hi all,
I'm new to sql server,so please help me to know about this.

1) whether the ssis package will process 1 row at a time or whole rows.
(i.e) it will take one record and process all the transformation then next or it will take all rows and process in each transformation.



Both ways are possible 1 row at a time i.e. Synchronous Transformation and all rows i.e. Asynchronous.
Please have a look on below URL

http://msdn.microsoft.com/en-us/library/ms136114.aspx


2) how to assign a value to a variable at run time after each row processed.



You can have user defined variable and assign them programatically at later stage.
For more information please see below URL.
http://msdn.microsoft.com/en-us/library/ms141085.aspx

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1353717
sathiyan00
Posted Tuesday, September 04, 2012 12:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:34 AM
Points: 60, Visits: 325
hi rhythmk..
thanks for ur reply...
i want to join u in gtalk my id 'sathiyan.raul@gmail.com'

Thanks and Regards
Sathiyan.R
Post #1353726
rhythmk
Posted Tuesday, September 04, 2012 12:52 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603
sathiyan00 (9/4/2012)
hi rhythmk..
thanks for ur reply...

Thanks and Regards
Sathiyan.R


Will send you the invitation on the same.However I am not frequently using it.

Also please avoid to put your personal detail(email id) on public forum as it may flood your mailbox unnecessarily with junk mails
You can use private meassages for the same.

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1353728
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.