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 do...

Yep, It has been going on for awhile. Sounds nice though 🙂

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 because...

stricknyn (11/19/2009)

---

Hi all,

I have a weird SSIS recordset issue. In my first data flow, I am summing and outputing some data (Only 2 colums, a count coulmn and a...

Hi,

I have experience with these two:

Subversion[/url] - open source and free

Team Foundation Server -...

Shawn-859490 (11/15/2009)

---

We have some programmatically generated SSIS 2005 packages and these are the ones that are not running after installing SQL 2008 last week. The error specifically occurs when...

Gkhadka (11/16/2009)

---

thanks COzyRoc...yeha I got the message. ..It was a one time thing for me, since they have not saved any datafile from previous load before I came to this...

I have sent you a private message.

Download and install SSIS+ from here. Then go to the control flow toolbox and enable the Data Flow Task Plus. If you have issues, do not hesitate to contact us.

UnderCoverSSIS (11/11/2009)

---

How can you reference the expression builder at the package level?

I have only seen it on the Expression Property of SSIS Task.

How do you access the expression builder at...

stricknyn (11/10/2009)

---

Hi all,

I have a SSIS package which has been deployed to a server. It has 5 variables. I have a SQL Server job which is set on...

Check if your dataviewer includes the extra column.

The CLSID it shows in the error is for "Microsoft Visual Basic Scripting Engine". It looks like your installation is corrupted. Try reinstalling SSIS client tools and framework. Also make...

I would recommend you use script task and message boxes and then execute your package to find out if the variable you need is being set. As I said earlier,...

Just define the variable on the package scope and it will be accessible from everywhere.