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

Open the .dtproj project file (it's just xml) and check what packages it is trying to open.

If you rename the package, you always get a message that asks you if...