This probably has to do with the location of osql.exe. If you serach for that error message, you'll find some posts about the issue. Here's one that I...

This might give you a start.

SELECT

name = db_name(),

ftype = case when fileproperty(f.name,'IsLogFile')=1 then 'LOG' else 'ROWS' end,

fgroup = isnull(fg.groupname, 'Log'),

sortid = isnull(nullif(f.groupid,0),9999),

fname = f.name,

fileid =...

I did this once, but the server names didn't need to stay the same. We migrated an entire data center, including the web servers. There was configuration information...

This sort of thing is a problem with lots of third-party apps too. I found that, if you push back, it is sometimes possible to get more information about...

There's the Debug mode in SSMS.

I believe there is a security synchronization process in NAV that can do this if a database user wasn't added through NAV.

This seems to be a pretty good explanation of passing variables into and out of the Execute SQL task.

http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

You may be getting the metadata error because of having...

You could probablt accomplish the column renaming part by customizing the applicable sp_MSins and sp_MSupd stored procedures in the subscriber database.

No, just SQL Server counters.

Does the package have any logging set up? That can sometimes he helpful for identifying issues.

This is an extensive discussion of the issues. You have to have the 32 bit version installed on the server.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/289e29ad-26dc-4f90-bad4-ffb86c76e5f9/

This is good too.

http://msdn.microsoft.com/en-us/library/ms141766(v=SQL.100).aspx

We try to avoid shrinking files because of the index fragmentation that can result. Recently, we were faced with a situation where we really needed to shrink a set...

Probably by executing DTExec.

http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

You'd populate a recordset. This seems to be a good descriptino of how to acces it in a script task.

http://sqlblog.com/blogs/andy_leonard/archive/2007/10/14/ssis-design-pattern-read-a-dataset-from-variable-in-a-script-task.aspx

This could be applicable.

http://stackoverflow.com/questions/687727/ssis-external-metadata-column-needs-to-be-removed