I would have a lookup table containing the various currency codes with their conversion rate to IPR

~PD

if exists(select * from sysobjects where name = 'Yourtable1')

begin

....do data transfer here....

end

here is a bit of an "off the bat" suggestion (use it dont use it...)

Set up a linked server to your 2000 instance, and query for keys ( i would...

You will most probably end up taking control of the excel object model within your scripting task

~PD

I suppose it depends on your interviewer, and their respective knowledge of the tool.

~PD

Certainly does sound like the software did some unencountered things to your environment.

I would start with a process of elimination, first stop and start the agents before I go any...

uhmmmm,

Really stupid question here, if the date is on your table, why bother with the calculation in SSIS

Surely you could just use getdate() as well as datediff as part of...

This shouldnt be a problem, I export lots of tables between 2000 and 2005.

The only time I hit some issues is with collation

Good luck on this one

~PD

There was a similar post recently

http://www.sqlservercentral.com/Forums/Topic513014-148-1.aspx

Basically, layer this in a stored proc

~PD

It may have something to do with your database collation settings being different from source to destination

~PD

Terry,

I understand that you are saying sendfiles and receivefiles is flawed, but what I am saying is that I was able to use a receivefiles component without it staying yellow...

Strange....

I use an environment variable per environment (dev, preprod, prod), all telling SSIS where the package configurations are stored.

I elaborated slightly, and have 4 different tables(FTP, Database, File, SMTP). In...

I would go for creating a test database (as Michael suggests), or a test environment, which would allow me to do everything as required, and to configure everything with SSIS...

You would have to EncryptSensitiveWithPassword.

Personally, my eyes would be popping out of my socket the moment someone tells me they cant do anything with sa, because why are you using...

For sure you can...

Basically anything you configure on your SSIS palette can be stored in a configuration.

Click on SSIS>Configurations, and have a look at your options.

If you need a little...