Good morning,
I'm writing a transactional dts using Execute SQL Tasks and Data
Driven Query Tasks to move data between 2 servers.
Working from my own workstation with a Login that I know has no Server

I have this code and am getting an error near group.  I do not see anything
can someone else's eyes locate the problem;
select [tblparticipating_entity].[entity_id], [tblperson].[first_name] & " "
& [tblperson].[last_name] AS [Consumer Namr],

I'm trying to create a DTS to simulate the following - because of security I
cannot use linked servers - however I am allowed to query the servers via
DTS.
If I was allowed a linked server - my TSQL may look like this:

I'm the newbie to DTS.
I've a listing of excel file that would like to load to the sql DB.
each excel file has a different name (i.e. prefix + yymmdd.xls) --> e.g.
dts050202.xls

Is there an easy way to more a large number of dts packages from one server
to another?
thanks
mike w.

Hello i have a dts packet how export a excelfile from sqlserver table. My
excelfile is existing like a form and I export some data from sqlserver and
then I change the excelfile name and I attached it to a mail and send it.
Question:

 What is the minimal permission for users to run a DTS  Package?
Not only that, I assure they also need permission to execute all underlying
tables which are fired off by the DTS package as well, am i right?
Thanks

I currently have a DTS package that outputs to 7 different text files based
upon criteria in the SQL query. The text files are dumped as comma delimited
files and goto different folders on the Network. Is there a way (Global
Variables) that I can run this package without having ...

I have a stored procedure (syntax available on request) which counts the
number of records that fits a certain criteria.  I would like to know if it
is possible that when this stored procedure is called during the execution of
a DTS package the "on faliure" would be tripped if ...

I'm trying to retrieve a value from a stored procedure I'm running on a MS SQL Server database.
I've added an Exec SQL Task, which I've defined as:
        exec niisp_HasMovedFileToday ?,?,?
The stored procedure is defined in the database as:

I want to set the properties of my SendMailTask based on the results of
a script that runs and processes a text file out into a table.  I can't
seem to find any code that shows me how to set properties for an
existing SendMailTask using VBScript.

SQL Server Agent reports the following error when attempting to execute a
scheduled DTS pacakge:
---------------------------------------------------------------------------------------
Step Error Source: Microsoft Data Transformation Services (DTS) Package

I looked through the archives but couldn't find anything
there.
I make a connection to an excel file and move a single
worksheet through a data pipe to a table on sql 2000. The

I am trying to append records from a .csv file into an existing table in
SQL Server 2000 using DTS.
The existing table looks like this:
Field1  Field2  Field3

Hi!!!
I am a newbie and need know how can I use the DTS to transfer one DB from
SQL 7 which has CP850 as a code page to a SQL 2000 which has the collation
SQL_Latin1_General_CI_AS.