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 ««12345»»»

SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers Expand / Collapse
Author
Message
Posted Friday, August 29, 2008 8:28 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
Hi Paul,

You are correct and I was not - thanks for pointing that out. OLEDB providers return ADO Recordsets. To get an ADO.Net Dataset you have to use an ADO.Net provider in the connection manager.

Thanks!
Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #561246
Posted Wednesday, September 3, 2008 4:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 10:44 AM
Points: 70, Visits: 224
Thank you for posting the article. You've no idea the amount of tears and tantrums you've saved me :)

Once you get a good working example SSIS really falls into place - which makes me wonder why they're so rare.

Anyway this really helped me out and got my project moving again.

Cheers,

Andy



Post #562913
Posted Wednesday, September 3, 2008 10:24 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
Hi Andy,

Thank you for your kind words. I can't tell you how much they mean to me.

:{> Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #563182
Posted Tuesday, September 23, 2008 6:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 23, 2010 9:29 AM
Points: 7, Visits: 66
Hi Andy,

Thanks for the information.. I m trying to with OLEDB and ADO.net Connection to execute Execute SQL task but OLEDB is taking 5.11min and ADO.NET is taking 5.28min.

Could you tell me the reason why...

Thanks in advance...
Regards,
Baswaraj.
Post #574265
Posted Thursday, September 25, 2008 7:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
Hi Baswaraj,

The point I was trying to make in the article (and I may not have done a good job) is that I use ADO.Net to call stored procedures that return scalars and small datasets. I find ADO.Net is faster for those operations.

OLEDB is still my preferred provider for large data loads.

Hope this helps,
Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #575983
Posted Thursday, September 25, 2008 11:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 23, 2010 9:29 AM
Points: 7, Visits: 66
Thanks very much Andy.... :)
Post #576517
Posted Thursday, November 13, 2008 8:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 16, 2009 9:20 AM
Points: 24, Visits: 100
The was great into.!!!!!!!!!

Need a little though. I have doing same thing except I need to add a where clause to SQL in the Excute SQL Task!

How does that work?
I tried:
Select AdjustSQLCode from _ut_PCA_Client_Import_Format_Cycle_Adjust
WHERE FormatID = @FormatID

Mapping Paramter:
Variable Name = User::FormatID Direction = input DataType = Long Parameter Name = 0

Post #602154
Posted Tuesday, November 18, 2008 3:47 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 292, Visits: 776
Terrific article, Andy - many, many thanks.
This got me started with understanding how to shred SQL data using the Object variable type. This understanding will now help me implement all kinds of great functionality at work.
Thanks again.
- Simon
Post #604748
Posted Friday, February 6, 2009 3:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 16, 2009 2:48 AM
Points: 2, Visits: 10
i didnt unserstand from where we have to configure the store procedure so that its performance can increase twice from earlier..plz im cinfused..if im calling the store procedure from C# file..how can i do this.i will be realy thankful to u
Post #651479
Posted Friday, February 6, 2009 8:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 26, 2010 7:48 AM
Points: 59, Visits: 86
good article, can't wait to try it Thanks;)
Post #651686
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse