I'm with Steve, is this going to happen a bunch or is this a one shot? Also is the spreadsheet ALWAYS going to have the same number of tabs...

Does the package have a password or is there any passwords saved in any connection strings? That is the first thing that comes to mind..

CEWII

At first glance you don't have a problem.. Your conditional split creates two separate dataflows, one for inserts and one for updates. Because of this you should not...

I can think of two really common reasons you could get that..

1. The email address you are trying to send is invalid, many systems will not accept an email for...

Well Alvin, that was going to be my suggestion as well..

CEWII

Not sure how you can get around using a script task in a dataflow. You can use the script as a source component to output the table into the...

Within a Dataflow task the metadata (column names/column count) cannot change at run-time. If you work with the same column count but the source has a different name with...

Are the referenced objects in the GAC? If so the GAC util can list them out, I have seem three values in processor architecture: AMD64, MSIL, and x86.

For the...

You mentioned using linked servers, I think that really was the first problem and really FTP is an answer but not the best. Did you consider using SSIS to...

I don't have a list but I have some questions/comments..

Any tool that can call an EXE file local to the SQL Server can start an SSIS package. But as...

So the real question is direct DB queries versus cube queries.

Well unless you are going to go through the effort of building accumulations and pre-calculated roll-ups the cube is the...

adrian.saunders (9/3/2010)

---

Install SQL 2000 first, make a note of where you put the tools and management console. Make sure its not the same location for the SQL 2008 install.

SQL 2008...

You are very welcome. As I have said many times there are usually a lot of good ways to accomplish any task..

CEWII

You guys are very welcome, always happy to help.

CEWII

Instead of referening a servername why not reference "(local)" which will reference the local SQL server each time.

CEWII