I am sorry I have issues writing what I am thinking sometimes. It is in windows explorer. example below.

C:\SQL2005\SSIS\GermanShepherd\BloodHound\bin\Deployment\*

So once you build it puts it out there. ...

Are you referring to the property called "CreateDeploymentUtility" that is located in "Deploment Utility" in the tree?

--Yes

Is the manifest file you refer to actually a package file with a...

So when you import the dts into BI-2k5 you have not uploaded the file to the servers integration server. There is a process to get that file on the...

ok it is very late and I am still playing with this.  It has something to do with the server it is on.

The server is called bloodhound and there are...

sorry if sa is the owner and still can not connect it must have to do with the integration server. Did you upload it through the manifest file? ...

Have you tried it in the 2k enviroment?  There could be reserved characters.  Beside that I do not know.  In 2K I am not having that trouble it works fairly...

SQL logins verse nt right?   So try the sa in the connection manager to see if it is a permission thing between the agent and your login.

Good question.

First of all I did not like the way SSIS defaulted to my documents.

So I created a directory on the SQL server call.  You can change the folder defaults...

Hey thanks for the info.  We are currently paying 3K quaterly so that should make the boss very happy

If you have a chance will you tell me the vendor?

I know this is kind of a goofy question and I know I can download from USPS.  I have a table with all the data for the first 5.   I...

That sounds about right.  Either way if you drop the DB they will not be able to access it.  Now if that login is used in multiple DB's then I...

now that is complicated. Is the integration server the default or is it a named instance? 2005 is tricky with that. For instance my machine is...

I was thinking about this and why would you want to limit read only rights in SSIS.  the connection to the DBengine would limit the ability to do anything.  That...

You need to add a field to the table or make a view to pull from