SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Leonard » SSIS 101: Object Variables, ResultSets, and...

64 posts, Page 2 of 7

««1 2 3 4 5 »»»

SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Leonard

Posted Friday, August 29, 2008 8:28 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

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

russella0-96423

Posted Wednesday, September 03, 2008 4:59 AM

Valued Member

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:50 AM
Points: 69, Visits: 194

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

Andy Leonard

Posted Wednesday, September 03, 2008 10:24 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

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

Baswaraj Mulge

Posted Tuesday, September 23, 2008 6:38 AM

Forum 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

Andy Leonard

Posted Thursday, September 25, 2008 7:37 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:53 PM
Points: 375, Visits: 947

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

Baswaraj Mulge

Posted Thursday, September 25, 2008 11:43 PM

Forum Newbie

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

Thanks very much Andy.... :)

Post #576517

mxwebb

Posted Thursday, November 13, 2008 8:14 AM

Grasshopper

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

Simon E Doubt

Posted Tuesday, November 18, 2008 3:47 PM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:47 AM
Points: 274, Visits: 635

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

rana.narpal20

Posted Friday, February 06, 2009 3:08 AM

Forum 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

Old_D

Posted Friday, February 06, 2009 8:03 AM

Valued 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 »

64 posts, Page 2 of 7

««1 2 3 4 5 »»»

Permissions