Viewing 15 posts - 38,671 through 38,685 (of 39,804 total)
For tackling the programming, I'd suggest reading lots of articles and practicing what is written. Modify it for your environment. Build yourself some tools, even if you throw them away,...
January 11, 2002 at 2:52 pm
You can setup the FTP task and use the dyanmic properties task to change the files that will be picked up. I am not sure you can automate this if...
January 11, 2002 at 2:49 pm
I would think ODBC, but I am not familiar with everything you are asking. You can setup a linked server and allow access through SQL Server, but I am not...
January 11, 2002 at 2:44 pm
January 11, 2002 at 2:38 pm
I agree with Brian. If you cannot be sure this will not hang something, I wouldn't do it.
One thing you could test is executing it with the NT scheduler on...
January 11, 2002 at 2:37 pm
Can you predict the filename? If so, you can use the dynamic properties task to change it.
Steve Jones
January 11, 2002 at 2:34 pm
January 11, 2002 at 2:33 pm
Ahh, I just saw it. In this line:
strFileSource.Move(strDestination)
strFileSource is a string variable, not an object. The syntax is object.move( source, destination).
So you would change to objFSO.Move( strFileSource, strDest).
Steve Jones
January 11, 2002 at 9:53 am
January 11, 2002 at 9:47 am
January 11, 2002 at 9:44 am
You will have to be more specific. There are quite a few differences. The Oracle and MS sites have some caomparisons, but these will be biased. Is there some reason...
January 11, 2002 at 9:36 am
January 11, 2002 at 9:09 am
An identity column has no "relationships" by default. If you want an identity to be the PK or an FK, you set that separately. If you reset the identity value,...
January 10, 2002 at 3:33 pm
January 10, 2002 at 3:01 pm
January 10, 2002 at 1:08 pm
Viewing 15 posts - 38,671 through 38,685 (of 39,804 total)