thanks for your suggestion is it sql server service pack or windows xp service pack.can you clear my doubt?

Thanks,

Ramu

Thanks Renuka.I will do that.

Hi,

Thanks for the response.I am using SSIS.I don't know how to set completion workflow

How does it taks query result as file and attach it to send mail task.Can you explain if you have any idea with example.

Thanks,

Ramu

It seems that the flg link may be help you out.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1073865&SiteID=1

check the issourcepathvariable true.IsDestinationPathVariable True and OverwriteDestination True .It might helps.

You need to give correct path in the variable and that variable can be use in the connection as expression.I think it helps

Thanks for your help.It exactly correct.I got the vlaues.

status column is just "y/n" column.

it differ the format like name.date.those files only allow .rest doesn't allow

Thanks,

Thanks for your reply.What i mean is we told to client that .It's the best tool(proclarity) for retrieval of cube data.But we don't know which version we want to use...

It is local system.While executing the package in visual studio.i am getting the error.

can you tell me how to set the path for c:\ramu\ramu.20080917.txt and somany files in the same...

These were coming in progress.Nothing was done in data flow

[Flat File Source [1]] Warning: The system cannot find the path specified.

[Flat File Source [1]] Error: Cannot open the datafile...

I tried this code but not able to get the result correctly .can you correct this code

Dim fileToFind As String

Dim path As...

I tried but i didn't get the expected result means i have files in a folder.Folder path is c:\server\servername.date how to set this path in script task.I tried but not...