Got it!!

Here's the solution:

exec master..xp_cmdshell 'c:\"Program Files (x86)"\"Microsoft SQL Server"\90\DTS\Binn\dtexec.exe /File "D:\SSIS Files\IEX39 Transfers\IEX39 Transfers\IEX39 - Pull down one month of SchedHeader.dtsx"'

Double quotes around each parth part with a space...

I need to run this from a tsql script. Here's my code that doesn't work:

exec master..xp_cmdshell '"c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /File "D:\SSIS Files\IEX39 Transfers\IEX39 Transfers\IEX39 - Pull down...

I'm running 2000, so no Management Studio and I am setting up this DTS job so that it can be automated daily.

Thanks for the reply.

Having the admin of the other server create a SQL Login would be my next option if I cannot get connected this way.

I can bring...

I guess posting the error message that I get would be helpful :

Login failed for user '(null)'. Reason : Not associated with a a trusted SQL Server connection.

Peter Schott (10/28/2008)

---

I know some people who are Christians and don't think logically. Therefore it logically follows that ALL Christians fit in that mold. I know of some...

Good points Phil. We are currently running 3 production servers - 7.5, 2000 and 2005. The 7.5 server is running just fine. Upgrading that server is really...

My bad, I...

PLEASE OH PLEASE AMERICA DON'T ELECT McCAIN/PALIN!!!!

I do not want to take the chance that a right-wing christian will be president of the United States(in the off-chance that something horrible...

I have to call that last post. I'd consider myself a Christian, but definitely question my government, will freely admit to having periods of doubt in my life, and would...

I just...

I can't decide on which candidate, but I know that I don't want to take the chance of Palin being president, if McCain's cancer comes back. I don't want...

I think the problem I originally had was that I had copied this project to connect to a different database. I think it still had some kind of link...

Thanks for the reply, but I was asking about shirinking, not truncating. I have also already looked through the event, application and system logs and found nothing.

None of it is at runtime. I actually fixed this error this morning by deleting the object and recreating the transfer. Thanks for the reply.