We have a large development team and they create DTS to load some data into
DEV environment and often need to change the connection properties.
Since only members of sysadmin role has access to change the settings if
there a way to give access to the developers so that they can ...

In SQL2000 DTS you could execute a package from the DTS designer and see how
long each step took. Is there any way to do this in SQL2005 SSIS?

I am trying to use the package migration wizard to transfer a package
from Sql Server 2000 (DTS) to Sql Server 2005 and I get the following
error no matter what I do/change.  Any help would be great.
This wizard will close because it encountered the following error:

I am trying to import data into SQL 2000 through an ODBC and keep getting an
error, I tracked down the error and it is because the program that I am
trying to pull data from has invalid dates (by design, not mine). It uses the
31st day in all months. I am trying to get figure out ...

We have a number of DTS packages running on a SQL 2000 server, pulling data
from a non-relational accounting database.
The package is set up using an ODBC connection to this database, which uses
a system dsn on the machine.

I am trying to copy a "snapshot" of a remote sql server 2000 database to a
local sql server 2000 database.  I just want to run a simple Copy Objects
dts, but it is choking on a user defined function.
Another object needs the udf but the udf hasn't been created.  Is there any

Environment: SQL 2005 EE RTM
I am trying to provide a dynamic XMLA string to an Analysis Services
processing task using a package-level variable.  My XMLA string is
about 5400 characters long.  I am able to put the value into the

Hi I would like to export sql server tables in text files.
I have a metadata table "tables" with the tables name that I want to export.
i would appreciate some idea how can i do that.
The main porpouse .. when I have more tables I just want to enhance the

I have arround 100 packages in all packages I have put IP of the server
in the connection.
Now I want to use all this package on other 2 servers.
So I need to change the IP in the connection for all this 100 packages.

I have just installed SQL 2005 Developer Edition on a Win2003 Server.
I have an installation of SQL 2000 on the same machine, which I use for DTS
package creation.
Since the SQL 2005 installation, my DTS packages are breaking on the DTS

Environment : SQL Server Intergration Services Beta 2.
Requirement is that moving the contents of all CSV files in a
particular folder to multiple tables in database.
What we have done so far.

In my DTS package, I want to define my connection DataSource using dynamic
properties. I'm using a query to initialize the source.
Can I use a global variable in this query and how to use it ?
Thanks for all

I am trying to import all tables from an Access 2000 database into a
SQL Server 7.0 database. The import seems to work fine and says it was
successfull, but the tables are not listed under the Tables node. If
you look at the permissions for the Public database role, the tables

In my ADP I start a DTS pakcage from my vba module (use the object
dts.package2), I display the status of the progress in a pop up form.
My issue is the DTS package takes ages to complete and if a user use
another application and come back to the Access application the got a

Facts:
I have a Windows 2003 Standard server that has SQL 2000 Standard installed.
Both MSSQL and ServerAgent services are running under a windows user.
Issue: