I have already told you that we have a format file so no need of bothering about format.. and the file name will be in this format [deposit]yearmonthtime.

thanks

i don't know much about SMO and powershell... i lost my hopes ... if any one can gimme the complete script that would be more helpful to me

thanks

Sorry but some one told me the location where i have posted is not the right one.. so i just moved that to here.

the files that are coming are text file and we have a format file.. so no need of worrying about format. I just wanna accomplish that task even if we...

thanks for the reply

i would like to learn about variables in ssis ... could you please provide me some links

can i accomplish the same task by using xp_cmdshell and bulk insert... because we are using sql server 2000

thanks... trying to get ur answer

since xp_add is already there i have created one more xp_add1 with all your suggestions but still i am getting the same error

thanks for ur support

Thank u man

i have executed the command which u said and it shows that the file is existed.

I have no problem in creating an extended procedure and only problem...

I mean i have installed a developer edition in my computer and thats path is in C folder

i am learning sql i don't have any real time experience

this is where is stored my dll file

C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll

thanks for ur reply

its in my specified folder

Thanks dude it worked