Peter2012 (4/8/2014)

---

Hi Eirikur,

declare @TableSpace table

(

TableName sysname

, RowsK varchar(32)

, ReservedMB varchar(32)

, DataMB varchar(32)

...

Start by adding a data viewer in the Data Flow Task, between the Flat File Source and the destination.

Run the package in debug, if all the rows are shown in...

rho_pooka (4/7/2014)

---

Thanks a ton for the help! Can the answer look different if you wanted to use node navigation? I think that's what I was trying to do...

First thought, make certain your user has the proper rights on both sql and ssas as a windows user.:cool:

SQL Wayne (4/4/2014)

---

I apologize if this is a stupid question...

I have VS 2010 installed on a Windows 7 machine. We use this for TFS mainly. I am at a new...

Could you detail your setup, looks like there is a missing login for the SSAS on the Sql Server.

😎

call.copse (4/7/2014)

---

I'd go so far as to say that you need to (and to be able to) take pride in your team. It's definitely one of those circumstances where if...

inevercheckthis2002 (4/7/2014)

---

Insert values:

INSERT INTO visited

VALUES

(N'Home', N'Kim'),

(N'Contact', N'Kim'),

(N'Products', N'Kim'),

(N'Home', N'Joe'),

(N'Contact', N'Joe'),

(N'Home', N'Pam'),

(N'Home', N'Sam'),

(N'Contact', N'Sam'),

(N'Products', N'Sam'),

(N'Home', N'Ray'),

(N'Products', N'Ray),

(N'Home', N'Kim'),

(N'Home', N'Pam'),

(N'Home', N'Sam')

;

(Actually, this did not work, I had to insert each row...

The nodes() method of the xml datatype makes this straight forward.

😎

DECLARE @X XML

SET @X = '<root>

<production.Categories categoryid="1" categoryname="Beverages" description="Soft drinks, coffees, teas, beers, and ales" />

...

Jeff Moden (4/6/2014)

---

naresh0407 (4/5/2014)

---

Hi..Actually are asked to validate this task without scripttask.We should use inbuilt transformations to achieve this task.Could you please tell me how can we acheive this.Just let...

If you only have few tables to check, do not use sp_MSforeachtable, it executes the statement once for each table in the database, regardless of what ever filtering you use.

The...

Peter2012 (4/6/2014)

---

Hi Eirikur,

Thanks for your response.

I've checked the given URL and it's not what I'm looking for as it's checking for all tables.

What I want is to check for certain...

In Sql Server 2008 the support for multi document type / multi format document files is very limited and some workarounds are needed. Without using...

lmarkum (4/1/2014)

---

We have a SQL Server 2005 instance that hosts an OLTP environment for our finance system (Navision). We have CRM on a SQL Server 2008R2 instance on a...

What version of SQL Server / SSIS are you using?