wzunzip.exe" is the command-line unzipper is not available for Win 2003 Server.  I just checked and we have the Integration Services running on a Win 2003 server. 

Any other inputs...

Thanks for your input.  I will use execute process method, and I do have winzip installed on the box but no winunzip.exe file is a part of that install.  This...

I made the change suggested with guess rows and that works on a 32 bit machine, but my Sql Server 2005 is on a 64 bit machine and there is...

Hi l0n3i200n

The SQL Server 2005 install is on a 64 bit machine and I do not see

Jet under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft in...

The column uses the default database collation which is set to SQL_Latin1_General_CP1_CI_AS

The specific column in the table has data for more than one language.  The problem arises when the we...

Have u converted the legacy packages to the new SQL Server 2005 format? 

See the following link to address my post :  http://www.whiteknighttechnology.com/cs/blogs/brian_knight/archive/2005/12/19/34.aspx

Thought it would be helpful.

Manisha

I am using the SQL server agent account to run the job. 

Never mind I figured this.  Execute SQL task is what I should use.

Thanks for your input.

Manisha

I see that you can execute a stored procedure using an ole db command task, but not a sql statement like this:

select count(*) from foo where x = y and...

I figured this out  myself.  For those who are interested, you have to set up the credentials and then a proxy woth privileges to run certain types of job.  Then...

Thanks Jamie. 

Will look into using OS step type.

Thanks,

Manisha

Thanks Kathi.  That worked.

I have been trying to do this and it is only possible thru code I believe.

Thanks,

MShah

I am fairly new to using SSIS and have not found the usage of properties on in your blogs.  May be I missed it.  Any inputs or a pointer in...