Hi,

in one of my projects we have used triggers to capture those changes applications made to database tables and then processed them into the tables of another database.

This implies that...

Hi,

you need to start from Add/Remove Programs (or whatever it is called in an english environment).

select SQL Server2005 and the Change button.

Michael

Hi,

I found Integration Services at the same level as SQL Server.

Concerning your connection problems I was thinking...

Hi,

you may check the network configuration and/or client configuration in Configuration Manager, but the default config should be sufficient for you.

The next step is using the Surface Area Configuration and...

Hi,

seems you are starting to mix up two things here.

If you really want to design SSIS packages you need to use Business Intelligence Development Studio (BIDS). Ther you have a...

Hi,

I assume you may set the default values of variables in your package in a way as to check them and fail the package in case the configuration doesn't override...

You will need several work-arounds in such cases.

One may be that you have to convert some date values when you need to insert them into an SQL Server table. Insert...

Hi,

for a start you can use the import data wizard from SQL Server Management Studio.

Right click on a database, select Tasks and then Import Data ...

Follow the wizard, but take...

Hi,

I do not know of any limits in the number of fields usable. Even if there are, 50 fields cannot be a problem.

I found on the other hand that some...

Hi,

I had a similar problem when connecting to an Oracle database. I solved it by using passwords to encrypt the sensible information in my packages.

The ugly thing is that you...

Hi,

I ran into that problem even when importing from an Excel table.

It's of no use trying to fix the type of the columns in the data source, as the error...

I think that my predecessor is right in assuming that the error comes from the source data.

The error message about 'loss of data' is a strong hint.

You have another alternative...