Thanks Jason. I'm not sure what to think about the near lack of discussion on the first part and effectively no discussion on this part..

I'd like to think it...

Like the poster ahead of me, I have worked with it and all previous versions, but upgraded almost as soon as 6.5 became available.

CEWII

It looks like it uses Excel and there are no 64-bit Excel drivers, run it as 32-bit using DTExec or check the box in SQL 2008..

CEWII

Ok, all of that sounds good.

Well you could add a step near the beginning of the package that uses an EXEC SQL task to do some noop command against the...

Robert Biddle (6/23/2010)

---

In a nutshell, I'm already doing that. I'm passing a recordset object to my ForEachLoop. The ForEachLoop processes each record and assigns them to a variable.

Edit:

From further research...

Wow, that is quite a request..

I generally don't like to use a staging DB unless I need to, it depends a lot on the data and the transformations.

As far as...

You are correct, the package will not update the file using any out-of-the-box methods.

You could write a Script Task to do it, but I am unsure if the file would...

I think we solved his problem a year ago..

CEWII

How are you executing the package? Also was it a true conversion or do you have a bunch of EXEC DTS 2000 tasks?

you might consider setting the DelayValidation to...

Where are you doing "When I open my .dtsx file to run it fails."

Also does your connection to the database use a password or does it use trusted security?

CEWII

Your problem stems from the fact that sprocs don't provide a "contract" of what they are going to output, unlike views and functions. What you really need is the...

Hmm, I wonder if the data was in some way triggering a bug.

I wish I had a really good answer, but I don', sorry.

CEWII

I have used the deployment utility and I was, underwhelmed..

I think a better method was reference by da-zero, package configurations, using either files or a table. I have used...

You can look at http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70346/

CEWII

This isn't really an SSIS problem it just so happens you noticed it using SSIS but it has been this way for as long as I can remember, going all...