Thanks for quick response...

I have worked with SSIS too... and I have read Flat/CSV files and have done many transformation.. (but in this case we have definate fix columns.....in short...

Never Mind ... 🙂

Many thanks for ur Help!!!:D

Thanks Ya!!!

Will deveop the same login and get back if faces any issue!!

Again Appriciate for quike Help!!:)

This May Stop the Jobs base on the logic i build.

But again how do i restart it again??

Thanks a lott..

Thanks TOmmy!!!

I tried this but I get error when i Set the Profile Name. I dont know wht to Set over there. And it say Profile name not set globaly...

Now I am abl to create/update/execute the JOb thru above MyUser. But even if the Job executes successfully it dosnt do the task(defined in SSIS Pack) in my DB.

I mean...

You'r right!!

after doing some googling i got to know

When Mapping the MyUser to MSDB Database there we need to check following things

>db_ddladmin

>db_dtsadmin

>db_dtsoperator

and all SQLAgent roles.

Then this user will have rights...

EdVassie,

Appriciates your Help!!!

You'r right!!

after doing some googling i got to know

When Mapping the MyUser to MSDB Database there we need to check following things

>db_ddladmin

>db_dtsadmin

>db_dtsoperator

and all SQLAgent roles.

Then this user will have rights...

Thanks for the info.But I will not be allowed to install any third party tool in PROD Environment.

I Did the same. But once adding that Proxy as "Run as" Tab. and then saving the Job give me error-> Only member of sysadmin role or owner of...

I did that but. once running the Job its blew up with following error:

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The...

Yes!! I Now have requirment where in I want to own as well as execute the Jobs thru "MyUser" which is now Non-Sysadmin.

karl,

Thanks for quick response!!!

My Prime Query is Currently in DEV Environment I have a User called "MyUser" which has Sysadmin Rights thus I have Created all the Jobs and its...