Nice question, thanks!

If it happens only at your system, you should take a good look at your computer. Is there enough RAM?

Maybe you can try to re-install BIDS.

I see you have a for each loop, is the dataflow inside this loop?

The OnPreExecute and the OnPostExecute event handlers can be fired more than once (especially the ones on...

There are some many things that can cause this.

Do you open all the packages at the same time?

Do you use a lot of package configurations?

When SSIS opens a package, it...

Setting Precedence Constraints on Tasks and Containers:

http://msdn.microsoft.com/en-us/library/ms141221.aspx

Adding Expressions to Precedence Constraints:

http://msdn.microsoft.com/en-us/library/ms140153.aspx

1. Place your entire package logic in a single container

2. Before that container, put an empty script task.

3. Connect the...

Just to make sure, is the project property Run64BitRunTime set to False?

Does the entire column show NULL values, or just some specific values?

Great question, thanks.

No problem, glad to help! 🙂

Christian Allaire (7/11/2011)

---

Thanks for the reply.

The data is read by the data source and shows up in the data viewer only if I run the the Data Flow Task directly...

Question not clear. No information given.

--->

Do you get some errors?

What doesn't work?

Did you check the logs?

You need to run the package in 32-bit mode.

In the SSIS jobstep, there is a checkbox that you can select.

This question wasn't worth two points???

:hehe:

How is this topic different from this one:

http://www.sqlservercentral.com/Forums/Topic1138118-148-1.aspx

Don't use the OLE DB source. Use string variables and the Execute SQL Task.

Janaa (7/11/2011)

---

The SELECT query is not static. It varies depends upon unique_id of sql table, that's why I tried to get the query inside the sql_column, and insert into #temp...

After I've read Phil's comment about the way SSIS works, I started thinking about easier alternatives, and I've found one:

* you select the SQL statement from the table and store...