Viewing 15 posts - 4,111 through 4,125 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 13, 2017 at 9:18 am
As per this article.
.NET Framework 3.5 SP1: Beginning with .NET Framework 3.5 Service Pack 1 (SP1) the .NET Framework is defined as a component instead of an...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 13, 2017 at 8:00 am
You can use SSIS to connect to SQL Express, however, you can't run packages on it. If your intention is not for SQL Server to run the package (running it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 13, 2017 at 7:26 am
Is Reporting Services running on the server? Also, seems you're deploying to the wrong folder it should be http://yourservername/ReportServer, if you're using the default URLs.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 13, 2017 at 3:53 am
Out of interest? why ARE you using the TEXT data type? It's deprecated, and has been since SQL server 2008, and if you're using 2016 you really should be using...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 12, 2017 at 4:07 am
What have you tried so far, what part are you stuck on?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 11, 2017 at 2:36 am
Is there any reason why you would need a Script package to do this? You could change your evaluation operation to the next task in your Control Flow to Expression...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 9:34 am
The problem is that SSIS can't define the row, so it can't output error that row either.
Can I assume that your data can/does contain commas (,) within...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 8:54 am
The problem is that you're saying the value of your cell is ""SHEATH SLENDER .021"" 35MM"". (Note I am assuming you have " set as your text qualifier)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 8:16 am
The problem is, it doesn't have a column to redirect the error on. It's technically erroring at the end of the column's quoted string, where it's expecting a comma. Are...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 8:03 am
I'm hazarding a slight guess here, but I think the problem is the quotations. SSIS is seeing the second quotation as the end of the string, which then is not...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 7:55 am
I'm not sure what you're expecting, but you're declared a table variable, not inserting any data and then selecting from it. Thus you won't receive any results.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 6:07 am
It all depends on what your page breaking on. If it's specific places, undefined by data, then just need to enter a value. This can be an expression, for example,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 5:52 am
On your tablix, set the Page Name Property, in the Properties Pane, to the Value/Expression you want.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 3:53 am
Don't use an expression to change the format of a field on SSRS, change the the format property of the cell. Using FORMAT converts the field to a string. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2017 at 3:02 am
Viewing 15 posts - 4,111 through 4,125 (of 5,109 total)