Try this thread:

http://social.technet.microsoft.com/Forums/en-US/itprovistanetworking/thread/c3fc9f5d-c073-4a9f-bb3d-b7bb8f893f78/

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Jack Corbett (8/2/2011)

---

Man, reading about phone problems in other countries makes me less upset at what I consider poor customer service in the U.S. Like most...

Well, I don't know your environment of course, but you mentioned that the package only hangs when other processes have been running prior to the SSIS package. Maybe some of...

I have no idea. BIDS can sometimes be a pain in the *ss. 🙂

If you go to the OLE DB Destination properties (F4), can you set the AccesMode property to "OpenRowset using Fast Load"?

Are there any other expressions? Maybe on the OLE DB Destination itself?

Are you sure the second Destination is an OLE DB Destination? And you are using an OLE DB connection...

splinter-740692 (8/2/2011)

---

The package is called using a parameterized stored procedure which will execute the DTEXEC utility via XP_CMDSHELL

Note: The user account has full privileges (SYSADMIN) on the PROD server. So...

At first sight there isn't anything wrong with that expression.

The only difference that I say between those two OLE DB Destinations is the table name.

In the first it uses square...

OK. How does the package run on the server? Is it started by a SQL...

In BIDS, do you use the same configuration as on the server?

The icon is actually good. It is a notification from BIDSHelper to indicate that the connection manager is configured by an expression.

Can you post the expression here?

What happens when you open the package in BIDS? Does the validation succeed?

I use configurations on my connection managers all the time, and the fast load option never dissappears.

It sounds really strange to me, as the OLE DB Destination and the connection...

Do you run the entire package, or just a single task by right clicking on it and selecting "Execute Task"?

Maybe you have permission problems?

Are you running the package manually or on the server?