|
DTS falied to acces file on drive D
Hi,
I made a very simple DTS Strutured Storage File with a connection to a SQL
Server and a bulk insert. If I try to use data file on drive C everything
is OK but if I try it On Drive D it failed. I checked permission on both
drive and everything are the same. I put full control to everyone on drive
D an ...
Thu, 13 Jan 2005 15:02:36 GMT
|
Oracle and parameters in Transform Data Task
I have a Transform Data Task copying from Oracle to MSSQL 2000 with this
code:
SELECT DISTINCT
DATAAREAID,
Name
FROM
CompanyInfo
WHERE
DATAAREAID in (?)
The task executes without errors, but no data is transformed. When I
hardcode (substitute ? with 'aaa,bbb,ccc') correct data is transformed.
...
Thu, 13 Jan 2005 09:57:56 +0100
|
How to write to predefined excel file with DTS?
Hi!
I have e excel file that has two sheets and both sheets have text on them.
There is text placed on few first rows of these sheets.
I want to place data that comes from a strored procedure at the bottom of
these sheets. How can I do that? I know I can easily place data on an empty
sheet. But how can I ...
Thu, 13 Jan 2005 10:46:35 +0200
|
Global Variable Already Exists in the Collection
Hello,
I'm getting the following error when executing a DTS package from
VB.Net. The DTS packages runs fine from the designer and used to run
fine as well from VB.net
"Global variable 'ExportedRowCount' already exists in the collection"
Here's my vb.net code. The error occurs right after the
..LoadFromS ...
12 Jan 2005 16:13:09 -0800
|
importing from MS Project using Microsoft Project 10.0 OLE Db prov
When trying to import data from MS Project (.mpp) using DTS, I get 3
consecutive errors.
1. unexpected error occured, the provider has returned an error without an
error message.
2. Context: Error calling get_rowset to get DBSCHEMA_TABLES schema info.
Your Provider does not provide all the schema rowsets ...
Wed, 12 Jan 2005 11:41:05 -0800
|
Moving Large Volumes of Data from SQL Server to Oracle
Hi,
I currently have a DTS job that movers about 40k to 50k rows from SQL 2K to
Oracle 9i DB. I am using Oracles own OLE DB to connect to the Oracle DB as
its quicker than ODBC.
Its taking 7 minutes to move 2000 rows using a transform data task. So I
guess its going to take over 2 hrs to move 40000 rows ...
Wed, 12 Jan 2005 18:32:31 -0000
|
Excel truncating leading zeros
I am having trouble with this, and when I google the topic there aren't
any threads with solutions.
The field is postal code, and when I open the file in excel, it says
reads "the number in this cell is formatted as text". The
destination field in our table is nvarchar, and I formatted the excel
field as text ...
12 Jan 2005 09:48:22 -0800
|
SQL Mail-DTS-Job
I have sql mail set up on my sql server. I have a dts package that
sends an email to me. The dts works fine if I run it in the Enterprise
manager. But when a job tries to run it, it hangs up and never emails.
Help appriciated..
Thank You,
-Pranay
...
12 Jan 2005 09:47:16 -0800
|
MSDTC resource in a Cluster
I've read and heard some conflicting information about the best method for
setting up a MSDTC resource in a cluster. I am running MSSQL 2000 SP3a and
Windows 2003. 2 node cluster with currently only once instance of MSSQL
with a great chance of growing.
A few questions I have:
Should the resource be in the ...
Wed, 12 Jan 2005 11:42:57 -0600
|
DTS seems to ignore quoted fields.
Help, I'm going mad with this.
When importing a CSV file, DTS appears to ignore that I've told
it that text fields are quoted and where a quoted field contains
a delimiter, it's simply split that field into two, making the
transformation stop due to "extra" fields....
Please, any thoughts appreciated befor ...
Wed, 12 Jan 2005 16:56:19 +0000
|
strange error on DTS scheduling
Hi Folks, I am getting this strange error while scheduling a DTS.
What I am trying to do is copy data from DB2 on mainframe to a SQL
server table. I created the DTS package and runs fine manually. But
when I schedule it, I get this error :
Executed as user: MYDOMAIN/SQLADMIN. DTSRun: Loading... DTSRun:
E ...
12 Jan 2005 07:41:24 -0800
|
Setting path to source file for DTS package
Hello!
On SQL 2000 I created with Import Data Wizard package "dtsTest". I get
data from Access file on location "C:\Temp\dbTest.mdb". Wizard created
"Connection 1" and "Connection 2" icons if I select Design package. I
call that package from VB.NET 2002 that way:
---
Dim pck As DTS.Package2Class
pck = Ne ...
12 Jan 2005 05:24:10 -0800
|
udl file and SQL Server authentication
When using Microsoft Data Link as Data Source, I use SQL Server
authentication with the correct password (including the sa account) I test
the connection and it succeds. However when I try to get the dts package to
use the udl file I get a package error:
Login failed for user 'xxx'.
...
Wed, 12 Jan 2005 02:07:02 -0800
|
Transform data pipeline timeout
We have several scheduled DTS packages on SQL Server 2000 sp3 moving data
from an accounting package. The transforms occasionaly hang up and the
problem may go unnoticed, is there a way to timeout a transform or any other
way of detecting this situation?
Julian Bowker
Marble Steps Systems
...
Wed, 12 Jan 2005 09:27:40 -0000
|
Missing steps in DTS export package?
Hi
I am struggling to get a working SQL 7 DTS package for exporting data
to ms access, to be deployed on machines running MSDE 1.0.
When I run my VB program to execute my package, I get the following
error:
"The Microsoft Jet Engine cannot find the input table or query XXX.
Make sure it exists and that ...
12 Jan 2005 00:16:11 -0800
|