|
Problem importing data with SQL
I have a problem importing data with SQL. I want to transfer data from one SQL server to another. Apparently I only managed to transfer data when the new table is empty. I am choosing Append data to existing table but this is not working for me.
What am I doing wrong?
***************************************** ...
Thu, 25 Nov 2004 09:35:43 -0800
|
Help with importing data
I am trying to import data from MSAccess. when I choose the data source and
enter the userID and Password I get the following error:
***************************************************
Error Source:Microsoft Jet Database Engine
Error Description:Cannot start your application. the workgroup information
file i ...
Thu, 25 Nov 2004 04:29:01 -0800
|
delete existing connections within DTS
Does anybody know how I can delete existing connections within DTS ...
Thu, 25 Nov 2004 03:39:03 -0800
|
Uplaoding excel file into SQL database
Hi,
How to upload data from an excel sheet into SQL database? We are using
ASP.Net Webmatrix and C# as backend.
Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! ...
Thu, 25 Nov 2004 02:00:17 -0800
|
How to FTP a Text file from DTS
I have sucessfully created packages that can FTP a text file form a server
and tehn import the data to SQL. Now I want to export data to a Text file
and then FTP it to another Server. There is no FTP task then can ftp to
another Unix Server ftp:/xxxx. Am I missing the obvious?
Thanks for any help
Marinus
...
Thu, 25 Nov 2004 09:37:29 +0200
|
browse for file
I'm writing a dts package that imports a file. I want to allow my user to
browse to the file, but can't figure out how. Any suggestions?
Thanks, Andre
...
Wed, 24 Nov 2004 10:54:55 -0800
|
Deligation of DTS Pakages?
Hi.
Some facts first:
Win2003 64-bit and SQL2000 64 bit on 3 Cluster nodes
Q:
I have to do Deligation of DTS Pakages to the Developers without giving them
sa rights. I have read the the following pages:
http://eddorre.com/comments.aspx?post_id=204
http://www.sqldts.com/default.aspx?212 ( how do i remove the ...
Wed, 24 Nov 2004 10:01:02 -0800
|
Package.Execute code no longer works in Yukon
In SQL2000 I can execute a DTS package with this code just fine
DTS.Package2Class test = new DTS.Package2Class();
object pVarPersistStgOfHost = null;
test.LoadFromSQLServer("myServer",null,null,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,"myPackage",ref
pVarPersistStgOfHost); ...
Tue, 23 Nov 2004 15:49:04 -0800
|
Import and Schedule DTS on MSDE
I have .dts file from another sql server. I would like to import and install
this file as a DTS package on MSDE and schedule it to run periodically.
How do I do this in MSDE 2000. ...
Tue, 23 Nov 2004 15:11:06 -0800
|
Querying Oracle...
.....is done best how ?
Have heard of Toad...or perhaps linked server and then use query analyzer ?
But this way I cannot get a list of tables on the Oracle database ?
And second (or third..) I need to have an Oracle client on the SQL Server
that needs to get data from Oracle ? Not just an odbc ?
...
Tue, 23 Nov 2004 21:35:18 +0100
|
DTS Error - Data too large for specified buffer size
I'm trying to import data into my table and I'm received an error message
that I've been unable to resolve.
The message is:
Error Source: Microsoft Transformation Services (DTS) Data Pump
Error Description: Data for source column 3 ("column_name") is too large for
the specified buffer size.
The destinat ...
Tue, 23 Nov 2004 10:55:54 -0600
|
DTS and Threading with VB.net
I have a Windows Service application that checks a queue for data
import requests. Everything works fine 90% of the time, but
occasionally the .Net runtime crashes, reporting in the event viewer
"Application has generated an exception that could not be handled".
My question is related to the ExecuteInMainThr ...
23 Nov 2004 08:53:36 -0800
|
Cannot Get Pass String Limitations In DTS
I am getting burned in every direction I take to get around this problem.
I have a loop in a Stored Procedure that reads records from a table to build
the SQL string to create the structure of another table. In this loop I am
concantinating the field names together.
Doing this I CANNOT exceed 4000 charac ...
Tue, 23 Nov 2004 08:21:02 -0800
|
Inremental Update in DTS
Hi All,
Can any tell me how can i plan only get the rows that have been updated only
after the last DTS Process.
Thanks,
Mansoor ...
Tue, 23 Nov 2004 18:51:38 +0500
|
Problem in runing job
Hi everyone
i have a package that have two tasks if the first one failed , it goes to
the second task
when i execute the package, it run succefully
but when i schedule it, the job take hours & doesent failed neither
successed , it stay runing so i stop it.
i repeat it many time & still the job doesent neith ...
Tue, 23 Nov 2004 12:21:52 +0200
|