Apparently, the account that SQL Server Agent uses to execute jobs on the production server doesn't have sufficient rights to access the folder where the package is located.

Either give that...

Another question:

what operation is selected in the File System Task?

In my experience, the "Rename" operation works best for moving files.

Check out the stairway series on SSIS:

http://www.sqlservercentral.com/stairway/72494/

What is the protection level of the package?

What changes did you make?

How did you save the package: did you save it to a new file or did you an overwrite of the old file?

Is the package in...

Abbas-418434 (11/6/2011)

---

thanks for the reply....

shape file is available on ineternt...

I checked the with a different technique...

Just removed the title of town and able to preview the report...

I added town...

SELECT MAX(Payment_due_date) FROM MyTable

The entire SQL statement:

EXEC xp_cmdshell 'C:\Program Files\Microsoft SQL Server\100\DTS\Binn>DTEXEC.EXE /F "C:\DbfExport.dtsx"'

TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

You can't.

The Lookup component can only use an OLE DB connection manager.

I would stage your GUID table in SQL Server, than use the Lookup component to perform your lookups against...

Maybe check the advanced editor of the source component to check if datatypes are used correctly.

Not with SSIS out-of-the-box.

SSIS will fix the metadata, so it can read the file faster. If the metadata changes, SSIS will crash.

CozyRoc has a commercial component that can handle this...

Nice question, thanks.

Nice question, thanks.

Here you go:

http://www.codeproject.com/KB/database/SSISMultiResultSet.aspx