Thanks for your replies.  I have a query related to passing parameter
to a stored procedure in a DTS package.  The code below is whatI am
using.  Basically, the code does not seem to be picking up the
'EndDate' parameter that I am passing to the 'usp_PaymentExt' SP.

Is it possible to write and compile my own class libray in c#, compile
it and then reference it in a script task in SSIS? How would I go ahead
and do this?
Thanks

How can I execute a DTS Package and send parameters to it .
The execution must be performed via TSQL commands, not from a client app
(e.g from a job).
Thanks in advance,

I'm trying to do a copy database from 2005.  The source server is sql server
2000 and the destination is a sql server 2005.  I can copy the db over
without a problem, but every column that I have setup as Identity=true on the
source comes over to the destination as Identity=false ...

I need to backup my CRM databases to another SQL server 2000 computer using
the copy wizard but i received this error message " there are 2 active
connections to the database" so the database was not copied to the second
server.

I have a ASP (classic) wepage the running a SQL Server 2000 DTS package
which creates a text file and drops it in a specified network folder.
I need to know which user needs to be given write permissions on this
folder so that they can drop the file in the folder once the DTS

I have an SSIS ackage that I have setup to import multiple flat file
sources. Each flat file source is different since the number of columns
and formatting (tab or comma) vary from file source to file source.
Now, in a perfect world this would work assuming a file is always true

Does anyone know how to make this simple SQL query using a SSIS Data
Flow Destination Task?
IF NOT EXISTS (SELECT * FROM Table WHERE Username = @Username)
BEGIN

I have a DTS/ETL package that is running perfectly. The data from the data
marts is currently imported into SAS/SPSS for cleaning and weighting. The
SAS/SPSS jobs are kicked off manually. I want to be able to schedule these
SAS/SPSS jobs so that they automatically execute after ...

I have DTS packages that import data from SQL Anywhere and MS Access.  The
ones that import from SQL Anywhere run fine (that was last month's battle).  
Only the jobs importing from MS Access are failing with the following message:
Executed as user: FED\service. ...n OnStart:  ...

Hi, I'm new to sql...
I want to transfer data stored in an MS Access database into SQL2000. When
the process is complete I find that the dts process does not:
a. convert autonumber fields into identity(1,1) columns.

I'm setting up an SSIS package that needs to transform latituded / longitude
degrees, minutes, seconds values to the decimal equivalent.

this is my case.  I have an ini-file containing info about server location,
password and database name.  My "dynamic properties task" reads from the
ini-file and the specified values.  My next step is a SQL Execute task where
I want to create a database based on the name from the ...

We've got DTS running to duplicate our data from our main Oracle server
to our website MSSQL database server.  Some of our jobs run as
frequently as a 10 minute interval and 99% of the time it works great.
These little jobs run quick (about 2 seconds long).

In setting up a datawarehouse we're starting out with about 30 tables
that need to be transfered.  What I would LIKE to do is build a lookup
table that holds the Names of those tables in their source, and the
names we are going to use in the warehouse, then cycle through that