Here is your step:

step 1. will get files in a folder c:\import

then name of files will be ff10162008.ks , ss10162008.ca

step 2. rename the file

ff10162008.ks to ks.txt

ss10162008.ca to...

Looks like the issue is Proxcy Account.

I had the same issue for sql agent. My DBA was able to figure out the problem. Though they belong to adminstrator group, there...

I am still confused. Why you trying to rename first? i would import and rename it.

but anyway......write in more clear in detail for each step...and i will try to post...

Hey can you post the exact error that you receive while executing the job.

I used to have the same kind of issue .......it used to say ...teh file cannot be...

Hey Bang.

If u have multiple files in the same folder, then I would...

I don't think it should double quote the header part. I am not sure what exactly you doing. Are you adding Header information to flat file or you just adding...

I would rather use a task in SSIS. Transfer Job Task in SSIS allows you to transfer jobs easily and even gives options to overwrite if present in destination, and...

SO , U r right it is not th ebest way of doing things. But if everything gets loaded with this option then u good. I think the problem here...

mark, now i am confused and back to zero. please describe the steps in your ssis and thinsg you trying to do. it might be a issue of datatypes and...

just bring the derived column and use the build in trim function in expression............

everyoen is right here. Mukti it is only for "OnError" event handelers we have ErrorCode and ErrorDescription sys variables ( i know you knew it, it is just for starter,...

Mark, I might misunderstood here.....But u say u r using dataflow, where u r loading from flat file to sql table. U have the same function of triming in teh...

I have a little thought on this. I know "Mukti" way is fine, It works. But, instead of hardcoding all the file name in the script task, I would rather...

According to my DBA, now they wants to import ssis packages to msdb (initially it was in file system). Also, they want to do table config rather than dtsconfig file...

and...

THNAKS Michael.....I know teh message si claer enough....but How can I convience my DBA who has never seen S of SSIS ( i am not in a mood to insult...