yes, this was a permissions issue. But a buried one. The SQL Server service account had R/W access to the file the SSIS pkg was looking to use...

Bewildering.. this 2008 SSIS package, executes successfully on 64-bit by remote desk topping onto the SQL Server and right mouse clicking/executing the pkg from the SSIS file system.

When I run...

To transfer the SQL 2000 logins, SIDs, and their passwords from the instance of SQL Server 2000 on server A to the instance of SQL Server 2005/2008 on server B...

wanted to apologize for my comment(s) last week. You guys (& gals) have been nothing short of tremendously helpful to me over the years. Sincerely sorry -- my...

I inherited this SQL. I'm wrapping up a DTS to SSIS 2008 conversion for approx 50 pkg's (just about done).. all dynamic in nature (XML config to get into the...

Not a bad idea.. I'll need to view the size of the tables on Sybase.. If they're too large, it may be prohibitive to stage all of them for this...

ahhh.. the Bill O'Reilly approach worked.. Thanks for the feedback..

please reply with technical solutions, not jibber jabber -- I can find that in the bafoons/democratic blogs.

thanks Frank.. You led me down the right path. My problem was a permissions issue.

-- When I ran the pkg from Visual Studio IDE, I was running under my...

Actually - I'm using a Stored Proc to invoke DTEXEC for upwards of 40+ SSIS pkg's.. and it's running fine. The only difference is that for the first time,...

Here is an additional error

Error: 2009-08-19 13:11:04.09

Code: 0xC001401E

Source: MY_SSIS_Pkg Connection manager "TXTFile"

Description: The file name "\\MyServer\MySubDir\MyFile20090820.TXT" specified in the connection was...

I'm familiar w/ alias.. but not sure what you mean by "changing the query to use the alias" ???

I tried the TOP 1 idea prior to your suggestion.. but due to the fact that my source is Sybase, the TOP 1 ORDER BY idea does not work.... ...

Matt - thanks. The missing "\" (suffix) was exactly my problem.

Appreciate you looking & resolving this for me.

The 2nd paren is valid.. (I tried removing it for the heckuvit -- no difference)

Also, just ran the exact SQL in Embarcadero's DBArtisan against the source DB and...