how can Unzip file text file using SSIS

Hi,

I am pulling text files in gzip format from UNIX system. I want to unzip these files and then import data from these files into database using SSIS.

Run your favorite unzip utility (there are plenty of gzip-compatible archivers out there, including gzip itself) using Execute Process task.

How can i use the formula in crystal report 8.5

Hello,
is there somebody who can help me to create a formula in crystal report 8.5.
this formula must convert a date ex : "01/01/1970 0:00" in unix format

I know the code in vb

rounddown( ((value +7200)/86400) + "01/01/1970"),0)

somebody can help me to do this with formula in crystale report

thansk for your cooperationhere after you will find the solution to convert a unix(UTC) time in to a normal date
DateAdd('s',{call_req.open_date},CDATETIME(1970,01,01,0,0,0))

How can i use embbed sql(e.g. SQC) program to access MSSQL from linux or unix?

hello all!
Help!
I've a lot of programs written in sqlc to mssql on the windows platform.Now the boss wants to use linux server and I've to tune all my programs in sqlc to linux.But how to do it?Does anyone help me?Don't have any experience in linux, thought this link (http://www.linux.org/apps/AppId_8044.html) may give you required information.

HTH|||Thanks, but this link was on MySQL, not MSSQL. I also have some information on this through using freeTDS or DBI, but on embedded sql, I found nothing!:(|||Then may be you need to do other way round, how about this link? (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=921&lngWId=8)