Thanks. I have to move on this fast because I inherited this package and I have other packages to develop/test. So I need to report up what the...

Well a. i'm a new employee and the file we get are text qualified with "" and comma delimited. so a row looks like this

"some text","some text2","some name "BookTitle" to...

Hello

i am running into a similar problem with the embedded double quotes.

I tried using the redirect row on error to just skip those rows with the double quotes.

I have not...

see i was hoping someone would tell me i don't even know what i'm talking about with the hashkey usage.

the field is varchar(100) and it exists on multiple tables.. and...

Can you explain further by what you meant by the way the temp tables were being used?

The application (we have no control on how the source code works) was creating...

Thanks for all the good feed back.

Here is an update. Talking to Tableau support, they use the #temp feature when the report is using some 'context' filter or some...

well, the first part was allowing the SSAS port to be on the exception list for windows firewall, which i had done. But it turned out that there was another...

my samsung epic is the truth.. i don't see how people like the iphone over the latest androids.. not sure about windows phone since it's new.. but the way the...

thanks for the advice.. i had already suggested those things to the client.. we are waiting for server upgrades... i was just wondering what they could do in the meantime.....

Thanks

That is the answer I was looking to confirm my thoughts.

Thanks for the advice too.

HI

I did not try your example per se, because it use string concatenation with the @table or @col outside of quotes.

This will lead to sql injection. What i was...

Thanks for the advice, but i'm not looking to do string concatenation...i need to have the parameters passed usin sp_executesql

oh ok. maybe there is something with the setup i have going on. but at this point it's probably not that important since the ADO.NET connection works for me.

thanks...

Hi,

Thanks for the response, but for some reason the OLE DB provider did not work.

However i tried the ADO.NET connection and it did work.

Have you tested this yourself? Or...

Lowell (8/20/2010)

---

VNC/Remote Desktop/ TeamViewer / PCAnywhere / GoToMyPC are desktop viewers,

you don't need that.

SQL Server Management Studio is the interface of choice and is backwards compatibile, and can connect to...