all groups > sql server dts > june 2003
LoadFromSQLServer 2 servers
Posted by wahoo at 6/30/2003 5:10:26 PM
When I ran the LoadFromSQLServer on a machine that had sql & iis installed
on the same machine it worked perfectly.
But when I ran the LoadFromSQLServer from another machine (IIS only) - I get
error. Failed.
I copied the dts files needed to the IIS machine.
The SQL server is on a seperate se... more >>
DTS in ASP
Posted by Niranjan Ramasamy at 6/30/2003 3:46:31 PM
Hi,
I have written an COM object with the DTS components to upload the contents
of Excel file to the SQL Server Database table. The environment is Windows
NT (Web Server) - SQL Server 2000 (Database). The SQL Server 2000 Client
tools are installed in the Windows NT Web Server box. (So the DT... more >>
DTS query
Posted by shau at 6/30/2003 2:53:39 PM
Hi I have been given 400 files to import into sql server
2000 they are all the same layout I have imported one
using DTS GUI no problem how can I mass import the other
399 if possible thankyou for any help... more >>
DTS Custom Task in C#: How do I access the Package.Connections collection?
Posted by rhoegg NO[at]SPAM isisnetworks.net at 6/30/2003 1:04:17 PM
Hello,
I would like to allow the package designer to select a configured
connection in my CustomTaskUI property page. However, I have been
unable to find a way to get from my CustomTask to its parent package
in order to access the Connections collection. I have found some
posts about using ... more >>
Error File Path
Posted by Matt Crego at 6/30/2003 1:00:13 PM
Can I programatically retrieve the path of the exception
file used during execution of a DTS package?... more >>
Execute Process Task - Parameter Length
Posted by Robert R at 6/30/2003 12:20:55 PM
Is there a limit to the number of characters that can be passed to the
"Parameters" line or "Win32 process" line of an Execute Process Task?
I am using DTS on SQL Server 2000.
Thanks
Robert
... more >>
DTS Import Question using VB and First Row Contains COlumn Headings
Posted by amc29 NO[at]SPAM drexel.edu at 6/30/2003 11:38:58 AM
Hi,
I'm trying to dynamically import data into MS SQL Server 2000 from a
text file using a DTS Script written in VB. The first row of the text
file contains the column headings. However, the column headings for a
file will not always be the same, so I need to dynamically set them.
Is there... more >>
DTS Report Preparation Task running to long time
Posted by Svetlana at 6/30/2003 4:57:18 AM
Hi,
I tryed to run DTS with Report Preparation Task. And it
stucked with running Report Preparation Task for more than
an hour, so i had to cancel execution of DTS.
Couldn't find any reason why it happened in Package Logs
or event logs, or sql logs.
Maybe anyone had experienced same p... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error when running a DTS Package in SQL Server 7.0
Posted by David Oxe at 6/29/2003 11:59:50 PM
Hi,
sometimes I get an error when running my DTS Package. The
error log doesn't really tell me anything useful so I
need your help.
The error message is:
.... DTSRun: Executing... DTSRun OnStart: Drop table
INVST01 Step DTSRun OnFinish: Drop
table INVST01 Step DTSRun OnSt... more >>
|