Hi... Can anyone help please? 🙂

With regards to SSAS and MDX

SELECT convert(varchar,(cast(dateadd(d,-1,GETDATE())AS date)),112)

Do you have a SSIS log?

Do you have an SQL queries to substantiate that your keys are unique(rows are not duplicated)?

Could you try the SQL that is used during cube processing?

Hi,

If you are using for-each then sequential process is unavoidable.

I have 2 solutions for you,

1. If you have several types of files(*.xls,*.txt, *csv) then you may have that much number...

in the area where you give SQL query say,

"delete from tableA where createdate= ? "

and in parameters tab in the source editor, please add an input parameter. user::Mydate is the...

Hi,

Could you be a little more elaborative?

Assuming that you have difficulty passing the date,

1. I'd suggest : Use an sQL query to get the first day of the current...

No direct way of doing this.

You could follow the previous comment and back track your triggers.

or

SELECT 'select '+sys.syscolumns.name +' FROM '+ sys.sysobjects.name +' where '

+sys.syscolumns.name +' = 136 'FROM sys.syscolumns

INNER...

1. Use the OLEDB source component. In the source editor, choose the 'Data Access Mode' as SQL Command.

2. In SQL Command Text, provide the procedure to be executed. Eg :...

Hey Erik,

I created a table #temp with one field. I inserted four rows in it. Then tried the replace statement as you did.

CREATE TABLE #temp ( word VARCHAR(100))

SELECT * FROM...