aravula1 (10/7/2013)

---

Hi, I tried ReportAction in SSAS and tried to drillthrough to a ssrs report. But my question is how can users use cube in frontend? do we need to...

mister.magoo (10/14/2013)

---

In your version of SQL Server, you cannot use the form

DECLARE @myvar varchar(100) = 'Some Value';

You have to use two statements, one to DECLARE then a SET.

DECLARE @SQLQuery VARCHAR(100);

SET...

You can create an ETL solution using SSIS to truncate the test server and get the latest day from the production server.

600 tables will be quite some work, but you...

It seems the Report.exe fails, or at least returns a return code that is not expected.

Does the package what it is supposed to do? Are the results achieved?

Easy one! Thanks.

If you use DontSaveSensitive, you need to store the username and pasword in a configuration.

You need to change this in the flat file connection manager (in the advanced properties), not in the flat file source.

One bug that is still in the statement is that you have to cast @ID to string in the concatenation for @TaskOutFile.

Select @TaskOutFile = 'C:\SSIS' + CONVERT(VARCHAR(10),@ID) + '.html';

The errors...

sqlserver12345 (10/14/2013)

---

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @SQLQuery VARCHAR(100) = 'select * from Table where ID=@ID';

SET @SQLQuery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

EXEC sp_makewebtask @outputfile =@TaskOutFile ,...

+1000

It's not because...

What if you remove the quotes around @SQLQuery?

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @SQLQuery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

SET @SQLQuery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\' +@ID+...

Most likely.

A colleague of mine had to do a project at a more top secret client, and...

As a consultant I've seen many scenarios.

In some cases the card the card is only necessary to get in. In other cases you need the card as well to go...

sql-noob (10/14/2013)

---

Jack Corbett (8/26/2013)

---

Sean Lange (8/26/2013)

---

I would recommend breaking this into batches of 10k rows or so. A single insert with 13 million rows is going to kill...

p.avinash689 (10/13/2013)

---

i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into...