Yes. That worked. Now my questions are

1) Seems like it has problem with the Key word FROM. As soon as I put in FROM, it fails. This will create...

In the derived column? I am getting syntax error.

But I need the leading zero.

07302 becomes 7302 in csv file But I need 07302 in csv file. Am I...

For e.g, this is the example of zip code 07302. When going to csv, it becomes 7302.

Zip code is standard 5 digit. Leading zero must present to make the...

Thanks a lot guys...Adding parentheses worked

Any suggestions or advise I can use?

Ok...Connection is made...Mapping done between SSIS and AS400...package runs sucessfully..In the debug mode, it shows there were about 17 records inserted...But I am getting a warning

"[OLE DB Destination [16]]...

Thanks. I have implemented the solution as you described.

Thanks again!

Yes That is correct. Trigger file doesn't contain data. It is just an indication that datawarehoue load is complete. This file will be there next day no mater what.

No, they don't remove the tirgger file. Its get overwritten every night after the datawarehouse completes.

Good suggestion but trigger file exists in the server that is maintained by our parent company so I am not allowed to touch this file.

BTW, this job needs to run...

The file we are taking about here is just the trigger file. This file will not be moved or renamed or deleted. Basically this file will tell me datawarehouse load...

But I wanted to run this job only once if file exists. If I schedule it hourly, then the job will run every hour (as long as file is there).

Great!! Thanks for your replies guys...Now I have better understanding of what I need to do.

Lets say I want to keep 2 weeks of full backup only. Do you...

Now what is wrong with the following syntax? RowID is declared as Integer...I am getting Row using Row_Number function.

Its giving me Incorrect Syntax near ''

WHILE @@FETCH_STATUS >= 0

BEGIN

SET @CMD =...