if you have any budget for this, you could try the custom component from CozyRoc

http://www.cozyroc.com/ssis/sas-data-destination"> http://www.cozyroc.com/ssis/sas-data-destination

I havent used it but we did consider it briefly before going...

Dev @ +91 973 913 6683 (10/19/2011)

---

steveb. (10/19/2011)

---

Dev @ +91 973 913 6683 (10/19/2011)

---

SAS ... SAS... , not ssas ... Need to find out if direct export to...

Dev @ +91 973 913 6683 (10/19/2011)

---

Use ODBC DSN...

I dont think you will be able to do an export to a SAS dataset,

but you easily import from SAS by using SAS/Access or by using the SAS odbc driver/

sorry, i thought you were asking how to use the varaible that you had populated in a .net script... I must have mis-read.

http://www.sqlservercentral.com/Forums/Topic1191894-147-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1191894-147-1.aspx

set a resultset type in the properties and then define the varaible in the resulset tab of editor.

its all in here

http://msdn.microsoft.com/en-us/library/ms135941.aspx

you just the DTS object to refernce the varaible.

like

Dts.Variables["yourVariable"].value

its not restricted I have used the UK bing map layer many times.

Not too sure about where to post screenshots, maybe attach them to your post.

Doing this in SSIS would be fairly straight-foward and you could use an expression to extract only...

are you still planning to run this in ssis?

If so you could pass the results of the procedure to an object, and then loop through this object until you...

just to check., are you writing this code as an expression or are you entering it into SQLstatement in the editor?

to get the return code change the resultset to...

Ray K (10/17/2011)

---

steveb. (10/16/2011)

---

Wales though i feel were robbed, I don't want to be someone that blames the ref..... but there was no way that was a red...

was going to post the same link..

serious answer; is that every interview i have had or conducted about SSAS involved talking about projects i have worked on and challenges that...

priya.pk20 (10/17/2011)

---

hi, i got my csv files from source n am preparing datamart. here am facing a prblm.

i have prepared all the tables of mart, when am trying to execute...