Viewing 15 posts - 8,866 through 8,880 (of 11,678 total)
L' Eomot Inversé (11/7/2011)
Koen Verbeeck (11/6/2011)
TCP/IP needs a network adaptor. Isn't that hardware as well? 😛
It was last time I looked.
But how about local loopback connections (TCIP to 127.0.0.1:1443)? ...
November 7, 2011 at 11:55 pm
MuraliKrishnan1980 (11/7/2011)
Thanks Koen.. It worked exactly the way that i was looking for.. Thanks for your help.. I was trying my best without any help, but could not find the...
November 7, 2011 at 11:50 pm
I would keep the packages as small as possible. That way you won't have to wait 15 minutes to open a package and wait for the validation to finish.
82 different...
November 7, 2011 at 11:48 pm
My first guess:
get a dataflow inside a for (each) loop. Loop as many times as you need to generate output Excel files (so I guess hundreds?)
Inside the dataflow, read the...
November 7, 2011 at 11:44 pm
abhijeet.send2me (11/7/2011)
Thanks.... Got it.Could you please tell me how can we change this default measure, if we have to !!!
By changing the property DefaultMeasure on the cube? It...
November 7, 2011 at 11:39 pm
Stefan Krzywicki (11/7/2011)
But there isn't a 2008 SSIS forum!
No, but there is a general SSIS forum in the Data Warehouse section 🙂
(to be honest, that forum is not used frequently....
November 7, 2011 at 8:46 am
Jim Murphy (11/4/2011)
Jack Corbett (10/1/2011)
Hey guys I got some really cool news today. I was awarded MVP status!
Congratulations Jack! I am very happy to see your award. Just...
November 7, 2011 at 7:42 am
Stefan Krzywicki (11/3/2011)
I'm having a problem with the speed of my main SSIS load package and would love to find out what...
November 7, 2011 at 7:38 am
Excellent article, thanks!
November 7, 2011 at 7:03 am
I'm starting to learn MDX, and this article is a great start.
On to the rest of the articles of this stairway series!
November 7, 2011 at 6:32 am
abhijeet.send2me (11/2/2011)
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure Works]
where [Measures].[Reseller Sales Amount]
and
SELECT
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure...
November 7, 2011 at 6:31 am
It does. You have two options to store packages on the file system:
* in the SSIS package store: this is a specific secured folder in the SQL Server directory. In...
November 7, 2011 at 6:05 am
In the child report, how did you configure the parameters? These should be set as hidden or internal. That way users cannot modify parameters and thus there is no need...
November 7, 2011 at 5:59 am
Here's how:
1) You create a table with nothing in it. You drag Color and StandardCost to the two columns on the right, which leaves you with one empty column at...
November 7, 2011 at 5:56 am
Apparently, the account that SQL Server Agent uses to execute jobs on the production server doesn't have sufficient rights to access the folder where the package is located.
Either give that...
November 7, 2011 at 5:40 am
Viewing 15 posts - 8,866 through 8,880 (of 11,678 total)