Hi,
I'm new to DTS so wondered if this was possible and if it is does anyone has
any pointers on how to do it or good places where I can learn?
I need to run a query to generate a list of servers. The DTS package then

I received the following message from a DTS package that fails. 'Subquery
returned more than 1 value. This is not permitted when the subquery follows =,
!=, <, <=, >,>= or when the subquery is used as an expression'. It occurs
during an update with the following statement:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour.  I would like to "skip" the job during a small time
frame, and then restart after that time frame passes.   For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM.  I

Hi, In my source (text file connection) there is a date field but the date
is stored yyyymmdd (20080226)
I need to convert this into a real date 02/26/2008 and then import it into
the sql server database into a datetime field.

Since getting an MSDN subscription a few months ago, I have made about 6
posts. I received one response from a Microsoft person telling me that my
post was in the wrong ng, I received another response from another user, the
rest went unanswered to this day.  I had an MSDN ...

ummm. sorry, I've read and seen the tutorials but somehow missing how
to do this.
I have a foreach container. Inside a dataflow task, with an XML
source, a data conversion (cause of urrr UNICODE) and and an ole DB

i'm new to world of SSIS(just 2 days). While creating few samples i
came across a issue where i need to do look up. Let me tell u my
scenarion say i have 2 tables - CustomerInformation which stores
customer information like CustID, first name, last name address etc

I know how to DTS data from one table in a database to an identical table in
another database in SQL 2000.  It's pretty easy.
But, what if you only want to move certain specific records (based on date
criteria) from one table in a database to a table in another database.  In

I have an SSIS package that is dynamically executing other SSIS packages
through an Execute Package task.  That is all working fine.
The problem is that when the child packages runs into an error, the package
appears to hang and not shut down.  This happens even when the package ...

I'm using ADO.NET Oracle Client as the provider to connect to an Oracle 9i
database in SSIS 2005. The problem is after the package finishes, the
connection to the DB isn't released. Is there any way to close it?

I need to stop a SSIS package from logging to the windows eventlog. I have
disabled logging and it still writes to the event log if the package fails.
We have a monitoring system in place that alerts our production support staff
every time an error is logged to the eventlog. Due ...

I have a excel file that I import into sqlserver. then I execute a sql task
to alter some data. after this task I want to export the data to access
database. How can I tell the DTS to export to access when the sql task has
completed?

I have an 'Execute SQL task' which saves its rowset into an output global
variable. Is there a way to transfer this data to Excel without using a
physical table in the database?
John Dalberg

I have a DTS package that imports some data into a database and when the
package it finishes with a mailtask that sends a mail on completion.
Some of my users run this DTS package with Enterprise Manager locally
installed, and som users execute the package with DTSRun run locally.

I need to build a dts package to do to the following:
* run a vbscript in a remote sql server
* copy some tables from the local to a remote sql server
* execute some update queries on a remote sql server