Shahab , Just a Thought............

Why don't use a export and import wizards to do it and also save it as a dtsx package and see how it works. Later once...

First of all , I don't know what you are returning from foreachloop conatiner-- fullpathfile, or name and extention, or just name. If i were you i would go...

sonia its clearly says that the path format is not supported. I am doing all my renaming copy and archive all the time like this , it works. may be...

Hey Mukti Got it Finally Thanks Again..............

Thanks Mukti again, But can u plz replace the value into my expression, the way you want . i have tried but fail

thanks

Yeha Jack u r RIght for ADONET @parameter works fine, and when you write your sql statement it becomes like exec dbo.myprocedure @parameter , .... and so on

amy be...

I found the issue , But how to solve it. I know the problem is that when i am inserting into table teh values are encode within ' ' and...

Jack I know. But I tried putting ? , it gives me parse error, it says all kinds of errors lik e---parameters not map corrrectly.

But When i put 0 it...

There Might be several issues As many of them have already pointed out .

May be ur lookup is not working.

Have you configured your lookup for Error rows. what happens...

To be honest with you i DOn't know. I created this job with ssis packages in my local machine, it failed. Then I mapped the server folder to my local...

There is several ways you can do that. Use another OLEDB source and use sql command as data access mode like--

SELECT 'N' as col1, getdate() as col2........

and do the join

Also,...

Mukti... Once again thanks, U have been a graet help all this time.

The problem is I am very poor at coding and I don't know how to do it with...

ERIN i would recommed you to use variables and expressions to do it.

First create 6 variables--

1.filename - abc (what ever u want, we will pull the value from ForeachLoop

2.SourcePath...

Thanks Mukti... I believe We can do that. Other way i was thinking to add OLEDB source and use SQL COMMAND as query like

SELECT 'GM', getdate(), user

and then do...

The very first reason, I don't have SMTp server name, nor they will provide one fo rme here. You don't know how micro things are here in case of security....