I have VB.Net code that executes a store procedure that executes a DTS package.
Everything works fine on my development workstation which has SQL Server
installed locally.  I moved the DTS package to the production server and
installed the application on the production server.  I ...

I used the Import Wizard to Import part of a table from AdventureWorksDW
sample database into my Tst Database. I define a  sql query to give me the
first 200 records. I parse and preview the data ok (no error there).
I ask it to save the pakage and I get a prompt with encrypting ...

I'm new to SQL DTS services. Am trying to build a test data warehouse
on SQL Server 2005 and I have 4 dimensions and a fact table. The
dimensions contain auto generated keys. In the fact table, there's a
single field that depends on the combination of the foreign keys that

How do I programatically schedule a job? I need to set the properties like
DTS package name, time and date in which the package should run and also
frequency of the run.
Please let me know how I can achieve this programatically.

I have a cursor that I am running to QC some data.  I would like to output
the results to an excel file, but being that the cursor will return multiple
datasets I am not sure how to do this.  I am doing some frequencies on the
data so for every field in my table I am doing a

Hi,
Can someone explain why DTS package failed because no related error message
shows on the view job history? I have 2 database copies to secondary site,
this one failed but another is OK. Please see details as following:

I'm trying to use the FTP task to send files to a vendor.  The vendor has a
testing and production environment setup.  I cannot figure out how to create
the FTP connection that will send the file to the vendor's testing server
when the SSIS package is executed in my testing ...

I am having problems with the XML result set type in the Execute SQL
Task. When I run the package in debug mode my string variable
containing the result reads as follows:
<ROOT><?MSSQLError HResult="0x80004005" Source="Microsoft XML

I am trying to use a stored proc as a source for a data transformation.
This sp uses temp tables.  When I preview the data everything is fine.
But when I try to map the transformations I get an error "Invalid object
name" saying the temp table does not exist...

I need to loop through a connection setting the DSN Name, User,
Password of an ODBC connection to Sybase each time to something
different. I know how do do looping in DTS using ActiveX script tasks.
In the object model for DTS it looks like the "connection" object only

I have created a import process that creates the ActiveX transformation
based on control tables and column mappings.
My question.
Is there a way to easily COUNT the columns in the import file as some of the

I'm trying to use the SSIS "OleDB Data Source" object to create a
connection to our Informix DB.  I'm not having any luck.  I'm totally unsure
about how to translate our working connection string parameters into
SSIS OleDB Object properties.

I have to pick up some files from an FTP server each day, and want to
automate it. As the files are then loaded into SQL server, I thought the FTP
DTS task would be a good place to start...
From what I can see, to use the FTP task, I need to select the files I want

I have a complete format excel file which needs to be mapped to a Sql server
2000 table. I am looking different options currently available. It looks as
if DTS does not have enough functionality. What it basically offers is direct
mapping to table. I would like to split a cell ...

I have 3 Self-Referenced Table with the same structure
(Subj_ID,Parent_ID, SubjText, Notes) with the child/Parent relation between
Subj_ID, Parent_ID.
subj_ID in all tables starting from 1,