Viewing 15 posts - 2,551 through 2,565 (of 4,272 total)
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...
March 8, 2010 at 8:35 pm
Wayne,
I would have to take a little different approach.. It is unacceptable for the fileserver to be down for 3 days..
CEWII
March 8, 2010 at 3:02 pm
I believe they are certificate revocation lists.
CEWII
March 8, 2010 at 1:56 pm
I am about 99% sure you can't because SSIS will NOT store unencrypted passwords in a DTSX file in the file system.
CEWII
March 8, 2010 at 1:05 pm
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...
March 8, 2010 at 12:00 pm
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...
March 8, 2010 at 9:10 am
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...
March 8, 2010 at 9:04 am
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...
March 5, 2010 at 2:32 pm
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...
March 5, 2010 at 2:07 pm
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...
March 5, 2010 at 1:58 pm
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...
March 5, 2010 at 1:14 pm
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....
March 5, 2010 at 1:03 pm
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...
March 5, 2010 at 12:59 pm
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. ...
March 5, 2010 at 12:51 pm
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...
March 5, 2010 at 12:42 pm
Viewing 15 posts - 2,551 through 2,565 (of 4,272 total)