Viewing 15 posts - 4,111 through 4,125 (of 5,111 total)
I made an indepth post about this a while ago, I'll see if I can find it.
In the interim, use a parameter to return a dataset of values,...
March 13, 2017 at 9:56 am
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...
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...
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.
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...
March 12, 2017 at 4:07 am
What have you tried so far, what part are you stuck on?
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...
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...
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)...
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...
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...
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.
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,...
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.
March 10, 2017 at 3:53 am
Viewing 15 posts - 4,111 through 4,125 (of 5,111 total)