you can create a windows service for the same and make it run repeatedly to check for the existence of the file and if its there then call the SSIS...

even with the package u r facing the problem u can execute the same with the option 'rely on server storage and roles for access control' selected. if possible run...

try using some database intelligence with the user u r running the package with, so that only 1 connection for the user can exist in the SQL Server else denied...

try, if this helps...

make a GLOBAL/SYSTEM DSN on the server and then use the same process as u are doing above.

let me know if it helps....

hi!

u must be having the .dtsx file located either on the file system or on the SQL Server where the package is currently deployed. Then by using the VISUAL Studio...

hi!

u must be having the .dtsx file located either on the file system or on the SQL Server where the package is currently deployed. Then by using the VISUAL Studio...

the above method sounds trueif and only if the developer knows what is the exact row value in the 10 rows that he wish to convert as columns....

what if there...

Yes u r right....But the thing is that sp_sendmail from db requires windows authentication on the db server...which we dont have on the production...

Yes u r right....But the thing is that sp_sendmail from db requires windows authentication on the db server...which we dont have on the production...

U got it pretty right buddy,

I have alread tried my hands on wat u have suggested me...But the problem is i m...

Buddy, Thanx for ur suggestion

But the roadblock that i have in the course of success is, I have made use of the same procedure...

i m not able to work it out man....the package is up n running on the prod. but i needed to change the connection strings within the activeX script for...