About the only way to directly call a web-service from SQL would be to use SQLCLR, HOWEVER, with that said, you have to import several assemblies into SQL before you...

Wayne,

I would have to take a little different approach.. It is unacceptable for the fileserver to be down for 3 days..

CEWII

I believe they are certificate revocation lists.

CEWII

I am about 99% sure you can't because SSIS will NOT store unencrypted passwords in a DTSX file in the file system.

CEWII

I work with a number of environments that the backups are not done locally at all, they are all written to a fileshare on a file server that is backed...

I did a quick little bit of research and it looks like the difference in configuration from a file source to a SQL source is largely that a package name...

You could build a ForEach Loop with a package exec task in it to execute them, then you would need to name them so that they were retrieved in the...

Ok, I have some thoughts and comments.

It sounds like you have a process that an SSIS job populates a table, you called it a temp table, is it a true...

You can accomplish some of the same things but a lot depends on what you are doing. Data updates tend to need to be done at one place or...

I'm sure SSIS could do it, but I'm thinking that you could use transactional replication to Oracle.

Look here:

http://www.sql-server-performance.com/articles/dba/peer-to-peer_replication_p1.aspx

Just thinking about the method you have outlined and it seems to have...

If that is all you are worried about then you could build a VERY simple SSIS package that uses the Transfer Logins Task to copy the logins. I would...

Short answer, you don't..

Are you using any of the directly supported upgrade methods, such as side-by-side.. A method such as this can move most of what you really want....

I think a bigger question is do you own Hibernate already? So faster/slower may not be any issue. Also, 100K records is not much, I doubt I...

That is a LOT of steps to make this work, as well as a lot of places for it to go wrong. You are saying 200K/day right now. ...

One, you really can't using the method you describe, however, you may be able to accomplish the same thing another way..

Why don't you explain in more detail the problem you...