Hi all, I've searched this forum quite a bit and haven't found anything
to assist me in what I am trying to do.
We are FTP'd at various times 2 files to be 'imported' into a SQL
databse. The .txt file contains the record that actually needs to be

I have a possible project to work on where I will have to
(unfortunately) pull data from multiple servers, each with it's own
dialup connection.
My question is, is it possible to dial a connection from within DTS,

In order to test the data from the source file, I changed the DTS load job to
use an ActiveX script instead of just a copy.  I noticed that data with  a
zero length string are getting converted to nulls and this is causing an
issue.  There is nothing in the command which tells it ...

Is it possible that a DTS job reports success, but isn't?
I created a DTS job and saved it. The query was:
select * from table where date >= '20061024' and insert the results to a
table on another server of identical stucture and name that had no records in

I created a DTS package which loads data from Access to SQL Server.   It will
be used in 15 different databases.  The table names are exactly the same in
each database.  As I rolled out the package to each database, I changed the
connection object to point to that database.  I  ...

I'm using SQL Server 2005.  I've built a DTS.  Essentially it does this:
Create a table and insert data
Delete an excel file
Export the table to Excel

I am trying to query the database and based upon which I have to
generate multiple excel files as per the number of users. I am planning
to use DTS...and I think activex scripting needs to be done. Does
anybody have any sample code which I can look at?

How to identify the DTS package that is used in the SQL jobs?
Thanks

I have an SA credentialed connection for both the source and destination
server. Both servers are SQL Server 2000 standard. The job fails with an
"unspecified error" which obviously is little help. I know it is connecting
to both servers as it even shows me which jobs are already ...

Hello.  What is the best way to transfer data from DB2 to SQL Server
2000?  Any feedback is appreciated!

I have a DTS that is not executing any of the steps.  They are not disabled
and checked to run on the main thread but they come up as not run.  I
running Sql 2000 sp 4.
Thanks

Can anyone tell me how I can get an ODBC connection from the Connection
Manager window into the Control Flow or Data Flow windows?
I have 3rd party ODBC drivers that are essential to gaining information from
our non-SQL systems in order to create data warehouses for AS cubes.  I ...

I wonder if there is a work around for the following problem, I have a DTS
pack that imports a number of uploaded files as well as files that show
errors that we have had in the files that we have uploaded.  The DTS works
fine when there are errors listed in the Error file but ...

     I need to refresh the database1 in TEST. In an other word it has to be
restored. I have a database file database1.db. Do you know how a can proceed
from Enterprise Manager?
Thanks

I created a package which executes 15 other packages.  Each of the inner
packages contains 3 variables which determine which files to load.  Is there
a way to set these variables once on the main package and then have them
propagated to the sub packages programmatically?  The ...