I see. That's interesting because I always thought objects were ByVal when declared instead of ByRef. So that means Im assuming that if I change some data in...

Oh, forgot one last question on this. If I load the data right into datatable object in my first dataflow task, do I have to declare an instance of...

Ah I see. Makes sense. Looks like this way is a little more work, but is very usefull if one wants to go right to datatable object from...

CozyRoc (11/20/2009)

---

You can definitely load your data directly in data set. However you have to implement a script component for that. Regarding the release of the COM object I would...

CozyRoc (11/20/2009)

---

Strick,

The adapter you are using is just an adapter. It takes ADO recordset and populates .NET data set. This is making your memory consumption at least twice as much...

Sorry, I misread your name 🙂

Strick

Hi Strick,

The recordset is not cleared , but it is at the end after you finish executing the second data flow. What you have to do is move the pointer...

Hello,

Thanks for your reply. However, the issue does not stem from attempting to reuse the recordset object. I am able to do that. The issue is after...

Hello,

Thanks for your response. I am looking to access the message itself. Basically I want EXACTLY what's on the message tab word for word as if I ran...

No, a member can pay in advance all the way up to the Dues total for that year. I thought about triggers, but they won't prevent someone from paying...

Hi, unfortunately whether it's read or write won't matter. I'll still get the error stating this must be done in the PostExecute section.

Strick

Hi thanks for your response,

Sure, basically I have a variable called DaysToRun which will be supplied externally. This variable will be responsible telling the script componend (as a source)...

Hi,

You may need to use the script component to read the data and load a dataflow with it. You'll most likeley use the .NET streamreader object to get the...

Great! thanks guys

Strick

Yeah, both statements are what I'm going to communicate to our DBA. ...