Viewing 15 posts - 16 through 30 (of 261 total)
Why do you want to use Cognos? Does your client already have it implemented?
April 21, 2009 at 12:23 pm
In my experience I've only had to restart the SSIS service, not the entire server. If you're developing locally and create a new environment variable to be used in a...
April 21, 2009 at 9:31 am
Check your 'Save Sensitive' package property. You'll want to read up on this. SSIS can be very difficult if you don't fully understand how it wants to utilize sensitive information...
April 20, 2009 at 11:30 am
You can also store information in an environment variable on the server so your packages become environment independent. I've done this before where we had a 'tenant' database environment in...
April 20, 2009 at 11:25 am
You have two options here:
1.) Enable remote errors on your SSRS server - here
2.) Remote into your SSRS server and run the report locally to see the detailed error.
HTH...
April 14, 2009 at 12:30 pm
Jack Corbett (9/24/2008)
I'm not sure what you mean. The code is in the custom component gives a readable error, granted "the data violates integrity constraints" won't mean much to...
October 17, 2008 at 10:02 am
Yeah, SSIS 2008 is built on Visual Studio Tools for Applications (VSTA) which supports C# where as SSIS 2005 is built on Visual Studio for Applications (VSA) which does not....
September 30, 2008 at 3:45 pm
Did you try a case statement?
September 30, 2008 at 3:40 pm
Yes, this is something often overlooked by many when working with SSRS. I've done similar things in the past where we had a report of 'errors' in some data that...
September 30, 2008 at 9:45 am
Has anyone here discussed or thought about a system for creating your own readable error messages. I'm at a point now where my team and I have developed a fairly...
September 24, 2008 at 6:35 pm
I would stongly suggest using SSRS...
May 28, 2008 at 5:22 pm
Are you asking how to dynamically set the connection string or how to loop through a directory of files?
May 28, 2008 at 4:38 pm
Why not create an SSRS report with a subscription? You may also try using your old ActiveX code inside the ActiveX Script Task in SSIS...
May 28, 2008 at 4:28 pm
I'm not sure exactly what you're asking but here is a link to a bunch of good Business Intelligence related tutorials from Channel9...
http://channel9.msdn.com/wiki/default.aspx/Channel9.SQLServer
May 25, 2008 at 11:52 am
jsheldon (5/23/2008)
RowNumber() can this SQL 2005 function be used on a database with 80 compatibility? (2005 SP2...
May 23, 2008 at 12:37 pm
Viewing 15 posts - 16 through 30 (of 261 total)