I know the title isn't very original... sorry
I have detail I am importing from an XLS -the Content of some cells is more than 255 char. I saved the XLS to CSV and got the same error importing. so I took the contents of the 5 cells that had more than 255 char... deleted them from the XLS and made 5 varcha varables for the content in question. after importing the XLS into the Table (less the content of hte 5 cells with more than 255 char) I now want to update those recs with the content of the variables. using an Execute SQL Task I mapped the 5 variables in the Parameter Mapping number them 0 to 4
I got as for as the following
declare @DomAcctExpr22 as varchar(1000);
declare @DomAcctExpr23 as varchar(1000);
declare @DomAcctExpr24 as varchar(1000);
declare @DomAcctExpr25 as varchar(1000);
declare @DomAcctExpr26 as varchar(1000);
-- no problem
when I enter
Select @DomAcctExpr22 = ?
Select @DomAcctExpr23 = ?
Select @DomAcctExpr24 = ?
Select @DomAcctExpr25 = ?
Select @DomAcctExpr26 = ?
-- it errors out. can someone help me
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…