I have 10 csv  files with different names in c:\mydirectory\.
I created global variable "ImportFolder" which has value "c:\mydirectory\
LDP_*.csv"
files names are

Allan,
I wanted to get definition of a table dynamically from source whenevr it
runs, source is a file system , it has odbc driver to support the file
system. when i run manually thru wizards it is creating table and loading

I have an Oracle table which has about 30 millions rows on it.  I have a SQL
table which has about 20 thousand rows on it.  I want to pull from the Oracle
table the corresponding rows from the SQL table.  Would I use DTS for this?  
Is there a way for me to join the information ...

Hello Friends,
I have created a DTS package and created workflow connections between my
different tasks.  I also changed the default Task and Step names as per my
conventions.  All of the individual steps execute fine.  However, when I try

My DTS package contains Environment Variable assigned on local server. When
manually run the DTS, it works fine. But when I schedule this DTS as SQL
server job and run as job, I get error: "Environment Variable not found."
Are there any recommendations to solve this ptoblem?

I have 10 csv  files with different names in c:\mydirectory\.
I created global variable "ImportFolder" which has value "c:\mydirectory\
LDP_*.csv"
files names are

How can i query excel meta data. I need to know column name, datatype,
maxcol size. I want to use this information in importing excel into
SQL.
Thanks

I'm trying to extract data from an Oracle 8i database to convert it to SQL
Server and I'm having a problem with one table.  This table has a CLOB column
(text in SQL Server) and I believe that this is the problem.  I'm using DTS
and I've used both the ODBC provider and the OLE DB ...

I am pretty much a novice on DTS, I have used it on very simple extractions
from Access to SQL.  I am wanting to set an extract from an Oracle Table
which has a very large number of rows (millions) and I want to set up a DTS
package which will run weekly and pull 1 weeks worth of ...

I am trying to import an Oracle table with CLOB datatype. The ODBC and OLEDB
drivers does not provide this functionality. Is there any way to import the
CLOB data? Are there any ODBC drivers(preferably free) that can provide this
functionality?

Hi I have the following code and I get an error.
Propably syntax but I m new to DTS
sql = "UPDATE Weeks SET  WeekStart = '"& ww &"'   FROM CurrentWeek
WHERE Weeks.WkNo = CurrentWeek.Wkno + 1"

When i try to import from access, some date field fails with the following
Messages
(Date Returned, DBTYPE_DBTIMESTAMP)
who can help me with this error?

I'm wondering what the best approach to this would be....
I have an Excel spreadsheet that users update and then save to a common area
on a network drive.  I then need to get the data from the Excel spreadsheet
into a SQL table.  Once the data is in the table, I then use some ...

I need to run an external command (secure ftp client) that will return a 0
if successful or 1-8 to signify different error conditions.  My DTS job will
need to branch according to the specific return code.  I spoke to MS support
and they tell me there is no functionality in DTS ...

Maybe some one can help me...
I have 2 tables with the following structure:
CREATE TABLE [table1](
[GRID] [int] IDENTITY (1, 1) NOT NULL ,