Viewing 15 posts - 8,506 through 8,520 (of 9,715 total)
ArkWare (1/5/2009)
Brandie,Does the "DiffShareFolderName" have any relation to the source "ShareFolder"?
Nope. As I said in my last post:
Brandie Tarvin (1/5/2009)
January 5, 2009 at 6:40 am
Actually, now that I'm examining your code, I don't think that will work for me.
What I've got is this:
\\SourceServer\ShareFolder\DB1\DB1_db_200812011600.bak
\\SourceServer\ShareFolder\MyDatabase\MyDatabase_db_200812011700.bak
\\SourceServer\ShareFolder\TempDB\TempDB_db_200812011200.bak
And all files should be copied as:
\\DestServer\DiffShareFolderName\DB1_db_200812011600.bak
\\DestServer\DiffShareFolderName\MyDatabase_db_200812011700.bak
\\DestServer\DiffShareFolderName\TempDB_db_200812011200.bak
Notice the missing subfolders. Also, the...
January 5, 2009 at 5:13 am
You say you use the string to add a folder. What happens if the folder is already there? Does it overwrite or delete & re-add?
January 5, 2009 at 5:07 am
Okay, then.
Off the top of my head, I don't know of any issues between Terminal Services and SQL / SQL Express that would require one to be installed before the...
January 2, 2009 at 10:31 am
You need to throw a Try - Catch in the script task so it throws an exception, than write the error to your job log file.
Use the following in your...
January 2, 2009 at 8:21 am
Nevermind! My problem isn't a security issue. I forgot to write out my path variables in my Script task so the File System Task could find the source &...
January 2, 2009 at 8:15 am
Stephen,
In my experience, applications that use SQL Express usually include SQL Express in their install package. You might want to contact the app vendor to verify this before you go...
January 2, 2009 at 7:46 am
There is no common list like you're seeking. That's why the phrase "least privledge" is used, because what one person does with their code isn't necessarily what other people use.
I...
January 2, 2009 at 7:42 am
Thanks for telling me, William, but the problem doesn't appear to be my website. It looks like the hosting server is down.
I'm going to call tech support shortly if...
January 2, 2009 at 6:35 am
Actually, I like the adjustable display idea too.
But it does seem like an awful lot of code to rewrite in order to get it working to begin with.
December 31, 2008 at 12:51 pm
The Execute SQL Task takes in a parameter in the stored procedure.
Goto Parameter Mapping on the left side menu. Enter in the variable name and call it 0 in the...
December 31, 2008 at 8:42 am
Okay, here's what we've got.
For-Each Loop with an ADO Enumerator. The configuration is set to an Object variable (as you said) with the mode as Rows in the First Table....
December 31, 2008 at 8:07 am
Aha! That's the detail that was missing. @=)
Give me a few. I think we have a package that does something similar, but we use a WebService, so I'm not...
December 31, 2008 at 8:02 am
Wow. I'm going to fill up this thread will all of my own replies.. @=)
I just figured something out.
Error:
Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error:...
December 31, 2008 at 6:49 am
Viewing 15 posts - 8,506 through 8,520 (of 9,715 total)