use File.Exists(curFile) ? which returns a boolean

http://msdn.microsoft.com/en-us/library/system.io.file.exists.aspx

try brackets [Year]. Also never do SELECT * never ever ever. either use a view that lists all of the fields but never use *. I bet you spent a...

http://social.msdn.microsoft.com/Forums/en/netfxbcl/thread/e99a7cea-43d3-49b1-82bc-5669e0b9d052

are you in a networked environment? try it on a file share with unc path \\servername\folder~1\ etc. I do not know if SSIS has issues with folders longer than 8...

are you in a networked environment? try it on a file share with unc path \\servername\folder~1\ etc. I do not know if SSIS has issues with folders longer than 8...

does the SQL task have an inline SELECT statement? If so is it calling a view or straight a table? If it is calling a view has something changed in...

how are you deploying your SSIS packages?

1. Deploying to a dtsx file on a file server

2. Deploying on SQL server under MSDB

...

got it ! it was very simple

SaveFile(Dts.Variables("varSSRS_URL").Value.ToString() + Dts.Variables("varSSRS_Report").Value.ToString() + "&awardid=" + Dts.Variables("strAwardID").Value.ToString(), Dts.Variables("varSSRS_ExcelReportPath").Value.ToString() + "ExpirationReport.xls")

well after I create that css file. I compile it csc /target:library translate.css which creates me a dll.

Then I

CREATE ASSEMBLY translate from 'C:\translate.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS

CREATE...

well as one famous sleepy cat once said "The more I learn, the more I know what I do not know"

here is the code

using System;

using System.Net;

using System.Text;

using System.Text.RegularExpressions;

...

ok got it done with no SQL project, straight C# using Visual Express C#. It works nice, send out the text in English, translates and brings back an html string...

ok it loosk I can also use the new Microsoft translator. anyways I have created an assembly, but how do I create a function or sproc based on this CLR

CREATE...

sweet! thank you very much

wow, pretty nice stuff there!

Thanks

thanks Gregg! You have directed me in the right path.