You can use the SSAS DMV's

Step 1: Create an Excel connection manager

Step 2: Use expression to configure your excel file path (C:\Test\ExcelFile_01012001.xls) where the date part is varying

Step 3: Use a Execute SQL Task and...

Why do you want to use the conditional split? How will this solve your issue?

XML file SQL Server table

(dd/mm/yyyy) (yyyy-mm-dd 00:00:00.000)

------------- ----------------------------

24/05/2006 2006-05-24...

As other repondants have evidently mentioned, you can have a column such which will store the value of the SQL function ORIGINAL_LOGIN() and later use the filter cluse to retrieve...

Check my blog on SFTP using Execute Process Task in SSIS here

I will take this up. Can I have a FTP site which I can use as a connection source?

I already have written a short note on a similar article(SFTP to be precise). This can be found here

Glad to know that the issue is solved. But some homework before posting doubts is highly recommended. 🙂

<<name of rar file>> = Name of the newly created .rar file(every file has a...

As Koen has already mentioned...

Add a Execute Process Task -->Configure the task

Example(Add this as arguments):

rar a <<name_of_rar_file>> <<Path to folder or file fully qualified>>

This lengthy c# code is simply...

Ok...let's do it once again

Comment the block-->Save the file in XML edit mode-->Make sure you have atleast one calculated measure defined in the tabular project(else the project will not open...

Correct...now save the .BIM file

Next close this file

Now open the solution explorer and double clink on Model.BIM file (or your .BIM) file

Build and deploy your project

Observe the change

OR

Click here

Jonas.SQL (12/12/2011)

---

I saw that it is fixed now in RC0. Great! :w00t:

https://connect.microsoft.com/SQLServer/feedback/details/712481/-count-of-model-in-tabular-model#tabs

Though my "old" models, created in CTP3 doesn't get "cured" just by being edited in SSDT CTP4 or by...

watch out for BI semantic model in SSAS 🙂