Howdy,
I need to call an Oracle package, that does some process on a Oracle
Database and outputs 0 or more rows in a ref cursor. Is it possible to call
this oracle Package in a DTS Package and to insert the returned ref cursors

I have a similar excel sheet:
company_name     site_name
CompA                 site1,site2,site3
CompB                 site4,site1

I am trying to use DTS to move an SQL Server database, from one server  (A)
where I have sa access, to another server (B) using the DTS wizard.  I have
db_owner access to the database in B I am transferring data and objects to.
I am able to successfully perform the operation between ...

How can I pass two Global Variables in a dtsrun command?
I'm using coldfusion to run dtsrun with arguments.
<CFSET sArg = "/S ServerSQL /U userName/P pwd /N Import Text File /A
FilePath:8=#cffile.serverDirectory#/#cffile.serverFile# /A

I'm importing a text file to a table. I only want some columns info from the
text file so my transformation looks like this.
DTSDestination("AddressCountry") = DTSSource("Home Country")
DTSDestination("AddressZip") =  DTSSource("Home Postal Code")

I need to import various excel files into sql server. All Excel files
have different column names. To my datapumptask I want to provide
column mapping dynamically using map tables. One map table will be
maintained for each excel file. map table will contain mapping between

I'm working in an environment where there's a need for certain users to be
allowed to execute a pre-made DTS package to update a database. Running a
schedule for the update isn't sufficient because at times it may need to be
done immediately. What is the best way to allow a user ...

I've tried to use Oracle 10g Instant Client driver so I can transport data
from Oracle to SQL Server without success so far. Anybody can enlighten me on
this subject? Thanks in advance.
1. I downloaded and setup Instant Client according to Oracle documentations.

I have a database that I normalized to 3N. Now I have a large amount of data
from a 3rd party that is in a flat file that I wish to bring into the
normalized (but empty) database. If I simply needed to split the data up
into the appropriate tables, I can see to build multiple ...

Hi, I've created some DTS packages and they are scheduled every 30 minutes.  
There are send mail tasks in the execution flow - about 60 total send email
tasks contained in 7 DTS packages.
Now the admin has decided to restructure our server system.  The new

Does anyone know of any good DTS sites that have sample DTS packages for
common or specialized use?
I've been to sqldts.com and that seems to be the best site I've found.
Also, anyone have any good books/sites to recommend for coding DTS from VB6?

I am importing data from a csv file into a SQLSERVER table
I am having problems with a field in the destination table which is of type
binary.
The source data in the csv file is a Hex representation of the binary data.

I have a dts job, based on a Transact-Sql BACKUP command, which produces
regularly a backup file.
Immediately after it, another task should compress (zip) this file.
Which is the best way to realize this and which compress programm must be

I'm trying to pull files from an ftp site.  Part of the file name is the
current date.  I have put together an Active X script task to generate the
file name, but cannot get the dynamic properties task to use the generated
file name.  I read that following the file name with 3 ...

Someone can help me,Does anybody know the physical path of the DTS packges?, because I can not start operation system, i just have  access to one partition of HD. I wish know, if posible to copy msdb files and paste on another PC(backup) without lost DB's