non local administrators or domain admins cannot access my SSIS server!
so the developpers can't access it.
I have changed the MsDtsServer DCOM object permissions but this change
nothing.

I've been trying to find something on the web but can't seem to find this
issue anywhere.
When i create an SSIS package and do a transfer Objects task to move a table
to another database or server

can someone point to me on some guides on how to do a flat file merge? i've
been looking for a way to do this in SQL IS but can't find anything
useful... any advise?

Can anyone recommend a good book on SQL Server 2005 Integration
Services?  I've had a quick look around (and poked my head in a few
bookshops) and the only text I can find (online) is Professional SQL
Server 2005 Integration Services

I an running into an issue when I try to import a table with null values in
date type fields from an iSeries (i.e. AS400).  The date is converted to
01-01-0001.  Since this is outside of the acceptable date range of SQL
Server 2005 the data conversion fails in a Data Conversion ...

I'm using SSIS to pull data from a Unix based ERP system using an ODBC
driver and keep getting the following error.
[DTS.Pipeline] Error: The PrimeOutput method on component "Source - Query"
(1) returned error code 0xC02090F5.  The component returned a failure code

Does anyone have any wisdom to share concerning very large import and export
packages.
For example, outputing 140 columns in csv format X 60 million rows.
The sql statement includes 4 joins - each on a column that is PK clustered

I am using SSIS to transfer an entire database from a SQL2000 server to a
SQL2005 server.
It produces the following Output:
________________________________________________________________________________________________

It seems I am unable to use parameters when executing a stored procedure for
a data flow source. Here is my setup.
I am using the OLE DB provider and have set my "SQL command" to "EXEC
[Historical].[dbo].[spFetchClearingPositionsForRisk] ?, ?".

  Today, I tried to create a SSIS Project using Visual Studio 2005, but there is an error occus, here is information:
  Failed to save package file "C:\Documents and Settings\owen\Local Settings\Temp\tmp1ed.tmp" with error
  ox80040155 "Interface not registered".
  I searched on ...

I am trying to create a near-realtime ETL (extract / transform / load).
(near time being < 2 min)  When a database table is inserted/updated, I
would like to have that data transformed and sent to another database.
I have looked into using the service broker and have a working ...

I'm trying to create a package which will populate an Excel worksheet with
the results of a stored procedure that returns a result set. The stored
procedure I need to execute requires an input parameter.
I'm facing a couple of problems trying to figure out how to make this work.

I have an end user tool thats designed for non dba's to create dts jobs to
run some sql and process cubes etc. and allows scheduling using the agent,
my security simply checked the windows user was a memeber of the olap admin
group and logged in as a preconfigured sql user to dmo ...

I am not sure this is the right group to post for this problem, but I am
trying to test a package created in an integration services project.
I try to use DTExec in command line to launch a package with some /SET
options, and there are spaces in the PropertyPath in the /SET option ...

Hi and a happy new year.
I've created a SSIS Package on my local Workstation. Inside Visual Studio
(on my local workstation an on the DB Server) the package runs just fine.
But when I upload the Package into the Server Store of my SQL 2005 and try