I have a small DTS package that try to get data from Oracle to SQL server.
Package runs without any issue when execute interactively, but when schedule
it fails. My guess this could be a permission issue, how can I resolve this
issue. How could I grant access permission to Oracle ...

If anyone from Microsoft is out there, please help because I know this HAS to
be a bug and you would think Microsoft could give us a fix!
We have Mainframe data being exported to a text file in fixed column format
with 600 columns and growing in the future.  I then go into the ...

What's the best way of populating the From and Thru date Global Variables for
a DTS to use as parameters in extract queries?

I have some SQL Server 7.0 DTS packages that use Microsoft data Link files
(*.udl) to define the DataSource for DataTransfer/pump tasks.  The source DB
are Sybase ASE11 Databases.
The UDLs are defined like.

I've figured out how to do a DTS to run a view and dump data into Excel, butI
had to hardcode the Excel filename.  How do I get the system date and save it
as something like "Accounting_05MAY2005.xls"?
Where do I start?

Getting error below when try to run inport job automatically.
Job saved in MSDE on WinXP box.
Importing from SQL2000 on Win2000 Server.
I can execute the job manually OK.

I am managing a large database--several hundred tables. The current system
I inherited employs an Excel spreadsheet to manage the details (description,
business rules, etc) of the tables and fields. We would like to convert the
information in this spreadsheet to a more ...

I'm going to rebuild my SQL Server and would like to know the best way to
backup my DTS packages.  I'll be completely blowing away the partition where
SQL is installed, and re-installing SQL from scratch.  Is it best to simply
copy my msdb db somewhere, install sql, stop sql, ...

Does anyone know of a method using File System Objects to
monitor for filenames that are date & time stamped.
The filename will always follow the form "BACS Day File [ddmmyyhhmm]"
There should only ever be ONE file present in the directory - however

I am trying to figure out if I can build a dynamic text file connection in
the DTS Designer.  The datasource will be a text file, but the name will
change...
Any pointer or links to articles would be helpful...

created package through sql using the all tasks extract info selected a
mdb file on my server.  then asked this to create a dts package and
scheduled it for once a week.  when I run it manually I have no problem.  
When it runs through the scheduler it cannot find the mdb file on ...

Topic: DTS export data to a text file. One table to a text file. Works
perfectly well.
Problem: The next process that is using the text file does not admit file
size greater than 2 GB

  I created a SQL scheduler which copy the files from one server to local
server.
But I still getting a error message "Access Denied .......". Is it a user
priviledge issue or something else ? Please help.

I'm getting some funny error. I've developed a c# (console
application) code - .exe - and Using DTS (SQL 2000) Execute Process
Task to run the .exe.
I run the process every month. Now when I run the process, I get

I'm trying to create a simple DTS package to copy some data from Server1 to
Server2,
but Server2 doesn't appear in the Server dropdown list in the OLE DB
Provider's Server list in the DTS Designer, even though I can see the box in