To add to the list, simply contact one of the moderators around here, or post a reply to this thread.
Microsoft Reference Material
SQL Server Integration Services Portal on MSDN - videos, whitepapers, product overviews, blogs
SQL Server Books Online for Integration Services - complete reference material
* Designing and Implementing Packages Tutorials
* Performance Tuning Techniques
* Microsoft SSIS Connectivity Whitepaper
Technet SSIS Wiki (lots of connectivity info here)
Using the System.IO Namespace in your Script Task
View Complete Post
I created an few scripts that calls cmdlets that gets information from our clusters. The idea is to run the process once and get the information from our clusters into one single place. This is important after outage/patch weekends so we can check the state
of our clusters in one single place.
I have never worked with PowerShell scripts before, and I'm doing this after getting inspired by some really clever folks I had the pleasure of seeing at SQL PASS.
I wanted to leverage SSIS so I can take advantage of the the ForEachLoop container and perform the same checks across my 13 clusters.
Have you guys done this before?
Am I on the right path?
Should I use WMI instead or PowerShell?
Any suggestions on how to execute PowerShell scripts from SSIS?
Any other suggestions?
Hi All -
I have packages that contain other packages. I run my packages using dtexec. Currently I am doing my logging from the batch that calls dtexec. This does not seem to capture any information on the child packages, other than their call from the parent. Can
someone suggest a good general resource on logging that includes advice on how to capture logging on nested packages?
TIA - G
Some questions about sessions:
I know sessions information is stored in the form of cookie and you can use qurystring for that if you set cookieless session in web.config. But I don't exactly understand the scope of a session.
What I believe is when you login to a website, a session cookie is created and the scope of that session is within that page only. If you close the browser that session gets killed and when you open the browser again and go to that site then a new session is created ie a new session is created on every request. Is this correct?
But I have seen in many websites, even if you close the browser and open it again the session is not killed, how does that happen?
Can anyone clear out and explain the scope/lifetime of sessions
Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.
Below is the information on the server before/after the upgrade.
Solaris 8 Solaris 10
IDS 9.40 IDS 11.50
The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.
As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.
The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.
I have gone through many articles and it suggest me to set the environement variable in the server : DB_LOCALE=en_us.819.
I haven't try this solution but i think that this might not be the best solution.
Is it possible to to to have this settin
First I will say I googled (Binged to make Bill happy) for this but could not find anything, perhaps I am not stating what I need correctly;
I have a website that a customer creates orders (for a printing company) and after the order, I would like to email the customer a link to view the status of their order;
I need to send the CustomerID in the link so on the returning page if a CustomerID is detected in the querystring, I "auto login" the client and open the "Dashboard" for the order page for that customer.
Can anyone point me in the right direction as to how to send the link and how to parse the querystring to get the values from the link;
Thank you if you can point me in the right direction.
i have installed visual studio 2008.it works fine
now i want to try ironpython. :)
so please give me details of step for installation and which sources require to start ironpython in visual studio 2008.
I am going to write vs2005 program with ASP.NET and C++.
As you know that C++ will involve a lot of memory error handling.
Do you know is there any tools for checking memory error in Code Behind C++??
This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.
MSDN Magazine December 2009
This article provides a first look at tools in Visual Studio 2010 designed to support development and deployment of SharePoint 2010 solutions. The article provides an example of designing and deploying a visual Web part.
MSDN Magazine October 2009
Having the capability to draw pictures usually isn't enough for a good information visualization platform. The key to building a visualization platform is capabilities such as interactivity, generating metadata, and overlaying related data. You need a level of flexibility that lets you render any data in any way at any time.
MSDN Magazine August 2009