Is it possible to give all the exact error messages?

Maybe you could try to write the updates to a staging table and do the updates after the data flow in...

How did you exactly try to connect to SSIS?

What were the errors that you got?

Is the service up and running? (check the SQL Server Configuration Manager)

You're right, that is just a bug.

I have it right...

I'd start with designing Entity/Relationship diagrams (E/R diagrams), normalization...

It depends.

Are you using Windows Authentication or SQL Server Authentication?

What is the protection level of your package? (properties of the package)

ADO.NET --> uses ActiveX Data Objects for .NET

OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)

DelayValidation --> validation of executable is delayed until runtime. For example, if you read from a table that has not yet been created, the package will crash when you start...

Well, that is quite a lot to mention in one forum thread 🙂

I think it is best that you search this site and the net for interesting articles on the...

It is the other way around.

If you create a primary key on one or more columns, the...

What do you mean with basic database structure?

Best practices regarding table design? Column data types?

Indexes? Normalization?

Wow Steve, you're on a roll! 😀

(I'm afraid I had to guess on this one :blush:)

And the ID and the password are saved into that dtsconfig file? Just to make sure 🙂

How did you try running the...

Stringzz (2/8/2011)

---

The DBA informed me that the system user is a startup user for sql server and agent service and has "SA" rights, so it should have more rights than...

I have a background in computer science engineering.

I do not appreciate the...

mike.frederick (2/8/2011)

---

Sorry it took so long to reply to your suggestions. I got pulled off onto another assignment. Koen hit it on the head with the TYPEGUESSROWS setting....