not sure about the protection level, but the following error

"Description: Failed to decrypt protected XML node "DTS:Password"

occurs when you have use SQL autentication on any server and the password...

not sure about the protection level, but the following error

"Description: Failed to decrypt protected XML node "DTS:Password"

occurs when you have use SQL autentication on any server and

i have tested the package with Oracle Provider.

It runs for about 20 minutes and fails at the Source. no data transfer occurs

When i ran it with Microsoft provider, it runs...

Thanks for the code Phil.

this is what i was exactly looking for

Hi Phil

thanks for the reply mate.

I have tried to do this with a variable. I have added that variable to Config file.

I used a query Select getdate() and assigned the...

forget the above one

i guess i can test it meself txtPost_CommentEmoticon(':-)');

Hi All

If i have saved the package in a different folder ( by using save as), the BI Studio points to the package in my personal folder and any changes...

ramu,

If you are using multiple data flows in the same task, then clearly one of the data flows has failed which has caused the others to fail.

you need to test...

are u trying to use multiple queries in the different dataflows under the same task?

i would advise you to use ExcelFilePath instead of ConnectionString in your expressions.

Are you getting this error when you tried to use it in a data flow task?

I have done what you have said and it did work 🙂

thank u very much. you rock

Can you post more info.?

Do all tabs have same type of data and do they have to be loaded to the same table?

Excel sheets will be treated as databases...

I am not sure if you can use a Full row set variable in sendmail task.

Use a for each loop with a script task in it to append all the...

Thanks for the replies

@russel

I have tried using variables but it dint work out for me .

In data flow task i use ? in place of the variable, but...