Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS DATA FLOW Expand / Collapse
Author
Message
Posted Monday, September 3, 2012 11:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
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
Posted Tuesday, September 4, 2012 12:02 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
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
Posted Tuesday, September 4, 2012 12:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
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
Posted Tuesday, September 4, 2012 12:52 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
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