Susheel,

Is the .txt file located on the same location as the SQL server ?

This was taken from msdn

The source file that the Bulk Insert task loads can be on...

Brandie,

I ran into similar problem when using the FTP Task as well.I could not find max size that was allowed for the transfer .I ended up using a Script Task...

You are welcome. It tought me a thing or two as well.

Could you try to manually modify the variable that is being passed to ALL Caps and give a try with just the Execute Process Task enabled ?

Im running out of...

Could you check how the variable looks like while its being paased from script task to execute process task using the Local Window ?

Does @[User::strSourceFileZip] refer to fullfilePath or just the fileName?

What did you set for the working directory path ?

Could you disable the Script Task, and store the file name to be...

Could you post what exactly you have in your Execute Process Task and how you have set the variable.

I would like to compare it with mine.

A chick .....:D

Raghu,

Replace your argument in Expression tab as

"-e -o " + "\"" + @[User::fileName] + "\""

Let me know your output. Keep your file path as original

Raghu,

Look like the problem is because the file path has space in them "Information Technology"

I changed Information Technology to InformationTechnology without...

raghu (12/4/2008)

---

Hey its working...

when i use the this file path as variable

C:\t\Dral_ENC.zip

But my file is in another folder

C:\Information technology\Dral\Dral_ENC

Its saying C:\Information .zip is not found.....

What might be the error...

raghu (12/4/2008)

---

No still i am facing the same prob...

"-e -o " + @[User::fileName]== after cliking evaluation button

Its just showing -e-o......But still its not working ... [It will only show...

Raghu,

Try this,I revisited my code and did a test run.I was able to unzip my file.

Executable : C:\Program Files\WinZip\WZUNZIP.EXE

Argument : Leave Blank

Working Dir : C:\temp\

Now go to Expression Tab,...

I have done this before as below.Download Winzip Command Line Utility.

In Process Task

Executable : C:\Program Files\WinZip\WZUNZIP.EXE

Arguments : -e User::fileName

Working Dir : C:\Temp

Where User::fileName is a variable that stores the...

Have you tried enable logging on your SSIS packages.You might be able to find some information in the logs.

mpothier (11/20/2008)

---

Have your tried logging into the the server under the SQL Server agent account and running the PSFTP install there, so that the registry is updated with the program...