How would you test if there is established connection to a data source and
then use this information
when continuing...?
If no connection abort operation....

Can any one give me an idea in how to plan the popluation of Fact Table
in a ware house ?.

How do schedule a DTS package to run at certain time using a certain userid?
Thanks,

I am trying to run  DTS pakage as a job and the job fails because it
does'nt have read access to required files in the file system. The job
runs to completion when run from the console but not from CmdExec in the
job. The files and directories have full control for all users. Any

I'm using the code sample provided at
http://SQLDev.Net/DTS/DotNETCookBook.htm to attempt to load a .DTS package
in C# through the COM Interop services, and execute it.
When the LoadFromStorageFile method is called I get the following error:

I have a DTS that access an .XLS file and imports the content to a SQL
Server table.  I am executing the DTS via a Windows .Net application which in
turns calls a store procedure which actually initiates the DTS Package.  
Folder/File permissions are set correctly.  In fact, I do ...

We have a dts that has been running for months. Now it won't run - it doesn't
even start. Nothing in the logs. And if we try and create a new job from the
package, it won't run either. We can't even run it manually.
Also when we create a new dts that runs fine when executed as a ...

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

Whilst importing a CSV file, DTS fails on fields with commas in them.
The text fields are surrounded by quotes and I've managed to get other
pieces of software to successfully read the file, but not Microsoft
Office products.

How do I compare data in 2 tables if tables are located in
2 different sql servers?

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 ...

Why DTS Designer doesn't shows description of Data Transformation Task, as
it does make for any other kind of task? It's pretty uncomfortably.
Thanks,
Vladimir Chtepa

I have a Transform Data Task copying from Oracle to MSSQL 2000 with this
code:
SELECT DISTINCT
DATAAREAID,

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:

If I have a simple DTS package, exporting rows from a table out to a
text file, will that spawn multple threads on the server, and if so,
can it be prevented, and if so, how?
Thanks!