all groups > sql server dts > august 2003 > threads for august 29 - 31, 2003
Filter by week: 1 2 3 4 5
DTSRun
Posted by Evandro Braga at 8/31/2003 7:31:51 PM
Hello everybody,
does anyone has real samples of DTSRun DOS shell statement ??? I
don't need the syntax, just real examples of how to use the DTSRun...
best regards,
Evandro
... more >>
How can I schedule DTS job withou sql server agent ?
Posted by Gloria at 8/31/2003 12:27:39 AM
Coz sql server agent service could not be started.
Any other methods to schedule DTS package to run without
sql server agent ?
Thx !
... more >>
dts
Posted by Zarish at 8/30/2003 6:21:20 PM
hi
i would like to give one of my tables to my friend .
so that he can have the exact table at his home. with the data and all.
how do i do that.?
i thought about using dts. but how?
...using dts i can successfuly transfer tables from one db to another.
thanx
Zarish
... more >>
Putting a OPENROWSET into a query?
Posted by Deke at 8/30/2003 2:06:05 PM
Hi,
I have a Foxpro db Linked Server. I'm trying to make views(queiries) with
the OPENROWSET command, it works when I run it from within the view builder,
but it wont let me save it?
SELECT *
FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;
SourceDB=D:\Dir... more >>
How do you transfer a DTS package between Servers ??
Posted by les at 8/30/2003 1:57:00 PM
I tend to search for answers before posting new ones, but
searching for "Transfer DTS Packages" yields too much.
So, how do I transfer DTS packages themselves between SQL
2000 servers ??
Thanks,
LES... more >>
FTP Error
Posted by Erik Benz at 8/30/2003 12:09:15 PM
I can access an FTP site through the browser but when I
try through DTS using same site information, username and
password I get the following error:
FTP Error
Unable to connect through internet! Please check the
source site information, your username and password.
SQL 2000 sp3a.... more >>
How to get an existing connection for use in a CustomTask?
Posted by mxc NO[at]SPAM magicmail.co.za at 8/30/2003 5:12:01 AM
Hi there,
I am writing a custom task in c++. In the UI component I allow the
user to select an existing coonnection that the custom task should use
to perfrom its operation.
This is done by populating a drop-down list with the names of existing
connection so that a selection can be made. In... more >>
DTS Schedule Error
Posted by Evandro Braga at 8/29/2003 9:39:58 PM
Hello everybody,
I have a package (Local Package) in the DTS session - in my
SQL-Server 7.0 sp #4. It was working two weeks ago, but after a maintenance
(some new tasks), I cannot reschedule the package. It runs perfectly if I
start it manually, but if I try to schedule it, rig... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Blank Screen When Designing DTS package
Posted by gax700 at 8/29/2003 3:40:36 PM
Hi all,
Whenever I go to design view in a DTS package, it
looks like the package is opening. However, after a couple of seconds the
design window appears blank.
Anyone else experienced the same behavior?
Tried to reinstall SP3, MDAC 2.7 but...
Thanks
Cris
... more >>
Possible buffer overrun using File Source destination
Posted by marco.russo NO[at]SPAM loader.it at 8/29/2003 6:43:40 AM
I had an error (Package Editor crash) while using File Source as
destination for a transformation.
After a few test, I isolated the problem and discovered that probably
if you write too long column names in table definition (for the output
of the transformation), the package editor will crash.
... more >>
|