I was talking about SSAS DB Backups, did you mean another thing when you were saying datawarehouse db?

You have to put Sheet1$ like this [Sheet1$], if I remember from the old days. Maybe next time you should change the table name when you use data import/export wizard.

Maybe you can use excel in the middle, since it extracts data from html tables.

Excel 2007: Ribbon Data, From Web.

You want to change the entire server default language, one logins or one sessions language.

When changing language, the sql server messages will change, the datefirst may be different, the datenames...

The login name in sql can be different from the user name on the db, can you check it? It probably has nothing to do with AD.

read this link about ssas backups Managing Analysis Services Deployment - Part 3[/url].

You can also use AMO in C#, vb, poweshell, .... Or XMLA.

Powershell backup

SSIS XMLA Backup

Backup scripts

When you take...

Maybe because your login name on the server is different from the user in the database?

Hi.

The statement "With table(...) is a replacement for your table. You don't have to put it on your sql. just the rest. In my posts I use another cte, so...

some links:

Running Parameterized SQL Commands Using the Execute SQL Task – I[/url]

Running Parameterized SQL Commands using the Execute SQL Task – II[/url]

How to use OUTPUT parameters with SSIS Execute SQL...

Hi.

Inside the For Each configuration you need to map each recordset column you need into a variable. Then you need to assign those variables to parameters of the sql task...

Even another way (after reading Divya Agrawal POST)

;WITH Table1 (Col1,Col2,Col3)AS(

SELECT 1, 'A', 'A1'

UNION ALL

SELECT 2, 'B', 'A2'

...

Another way

;WITH Table1 (Col1,Col2,Col3)AS(

SELECT 1, 'A', 'A1'

UNION ALL

SELECT 2, 'B', 'A2'

UNION ALL

...

Hi

You can read about it in http://www.mssqltips.com/tip.asp?tip=1405. I just googled it as "SSIS configuration". If it's just connections or simple variables you can also doit other way: U can set...

Matt Miller (12/12/2008)

What article????? Wow it really must be Friday - I'm feeling my...

It will error exactly because of the deletes, as I said in the article.

This kinds of things are requires because it's one of the rules of the quality of service...