Phil,
I am sure we got exactly the same error. My assumption having spoken to the DBA was that no Access drivers were installed.
We tried running in 32 and...

Dude,
When you  start a package by  using the  green "play" at the top of Visual Studio it will start the package it is configured to start.
in Visual Studio

I have gone for 32 bit for a number of reasons.
1. The old server  20085R2 used the 32 bit provider and and ran in 32 bit mode.
2. My...

Need a little more information.
Are you trying to correct the data in a data flow in SSIS. i.e. are you looking at doing this change between a data source...

Resolved. Got an admin to run bids as admin, open script component. Editor fired up. Then close down bids.

Then I opened up solution and could edit script component.

Guessing...

Thanks,
Saw that page on one of my trawls on the subject. Been through most of that. Cant touch registry as it is a corporate machine and as such locked...

That's the most I have ever spent on a Kindle book!

That's an observation and a compliment not a complaint. If it saves me one hour of grief it will have...

Thank you,

I hope to enjoy the journey through the book. I also noted there was short session SITC LDN 2014 on you tube so will watch that when I fopnt...

Just had a look through the contents list and that looks like its goin to do me just fine.

Thanks

E

It previously included most of the columns but as some columns had been added to the table but not the index I looked to add the new columns.

I have had...

Thanks,

Standard edition so no chance of ONLINE. Currently its whirring away slowly. We are now at 4 hours!

Its a non cluseterd index on one column including approx 30...

Cheers,

I think that answers the question. I looked at some of the objects and they had all been create today so must be temporary work objects created by the system.

Cheers

E

Thanks,

that makes a lot of sense.

E

Currently in the same situation.

Cant create any Database style connections in SSIS packages.

I can add flat file etc but not OLEDB providers?

Cheers

E

Sorry,

that was 9 years ago I have forgotten so much of what happened back then 😀

However yes, it probably is that you are unable to connect due to some corporate...