FTP Module & Proxy

Hi,

Is it possible to set the proxy settings with FTP component in SSIS?

-Anand

I would have expected any proxy settings to be part of the connection. Nothing there so looks like a no.

Frror: 4000 max string literal in Expression for datareader component

Hi, I have a datareader component of which i am dynamically setting its sqlcommand statement with expression (click the background of dataflow > properties > expressions). Now my sql select statement has about 600 fields so that makes my expression statment "select field1, field2, .....from table1 where field2 >=" + @.[User::dateforfield2] but when i evalute the expresssion (which is right), i get the error: A string literal in the expression exceeds the maximum allowed length of 4000 character and i think its because of the fields in my select statment causing my string literal to grow more than 4000 characters. Is there any way to increase the max string literal for expressions. Please help.

No there isn't unfortunately. This is a problem and will hopefully be fixed later.

Ask for it to be corrected here: http://lab.msdn.microsoft.com/productfeedback/default.aspx

Its more likely to happen if customers request it and there are good detailed scenarios why it is needed.

-Jamie