.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS in PolyServe environment

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server


Good Morning All,

We are migrating to HP - Poly Serve environment specific for SQL Server.

In the existing system,  we have SQL Server 2005 instance running in a stand alone Windows server box. There our SSIS ETL packages does importing  data from input files in local drive, processing and generating reports in Excel in local drive for analysis.

In the new Poly Serve environment (am new to this environment), I understand that storage and application server are loosely coupled by having Application servers and storage area network. I would like to know is any body have migrated their ETL packages to this new environment. I have been said the Storage drives part of Poly serve environment are strictly to store database files.

My concern is how I will be picking my input files for processing and store my result report files. Any suggestions please



View Complete Post

More Related Resource Links

SSIS Deployment Reads local Environment Variable and not Server

Hi All, I have an SSIS package that uses an Environment variable to hold the connection string for the local SSISConfiguration table.  This works properly on my local machine.  However, when I import the package to Integration Services(through SSMS) it reads the environment variable from the local machine and not the server it is deployed to.  If I log on to the server remotely and do the same process it uses the the correct environment varible... (SQL Server 2005) Is there a way to deploy the package to the server and get it to use the correct Env variable without having to log-in to the server and import it?  Let me know if anyone is looking for additional information.   Thanks!

SSIS Environment Issue


SSIS package loads all the rows in DB when I execute it directly from package. But when I execute it through Job or using command prompt it loads some rows and skips some rows in between and finishes with success. I've never experienced such issue before. This has started happening all of a sudden. 2 months back this package was running fine.

Can someone please help me?

SSIS 2008 changes in dev environment


hi we have a project developed in ssis 2005 now the similar project is going to be implimented for a different market using sql 2008. there are  huge flat files  used as sources and other oraacle DB.

we will be using a unicode DB as our dest.In SSIS 2008 is there any design considerations which i need to take care. or can i do the development in same lines of sql 2005

Please share on any info of the pros and con's of 2005 and 2008



How to deploy ssis Packages to production Environment


Hi All,

I have a few questions regarding ssis package deployment to production environment.

In order to deploy already developed packages ...These are the things I am following...Please confirm whether I am following the correct approach...or not.. If not please let me know the exact process..

First of all I am generating the scripts for databases...corresponding tables,views and stored procedures..

Once the scripts are ready... I am executing those scripts in production environment.

After that I am adding all of my developed packages to production environment BIDS Platform. Then I am running these packages in production environment (All connection strings are updated in the configuration file)...by changing the Configuration file..

Then I am scheduling all of these packages through SQL SERVER JOB AGENT.....

Is this the right approach ...? Please let me know ASAP...







SSIS Environment Variable Standard Edtion Vs Enterprise Edition



We current use SQL 2005 Enterprise Edition and we have our SSIS package working great where the server names are picked from Environment Variables file stored on the server. We are now planning to use SQL 2008 R2 STANDARD edition and for some reason the SSIS package which works great on SQL 2005 using variables is not working on SQL 2008 R2. It complains about not able to find the location/environment variables.

Question: Is the Environment variables thing supported in SQL 2008 R2 STANDARD Edition?


Thanks !


Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

.NET Delegates: Making Asynchronous Method Calls in the .NET Environment


One of the many great features of the .NET Framework is that it has asynchronous infrastructure built in. In .NET you can call any method asynchronously by defining a delegate for the method and calling the delegate's asynchronous methods. This is beneficial to your application because when a synchronous call is made, the calling thread is blocked until the method completes whereas an asynchronous call is made on a different thread, and this allows the original thread to continue its work while the asynchronous call is in progress.This article explains delegates in .NET and how to use them to perform asynchronous calls, eliminating age-old threading problems.

Richard Grimes

MSDN Magazine August 2001

Windows CE: eMbedded Visual Tools 3.0 Provide a Flexible and Robust Development Environment


This article provides an overview of writing applications for Windows CE 3.0. Unicode support in Windows CE, the kernel, memory management, the object store, and COM and DCOM are discussed. The article also covers the user interface, graphics, the Internet, and how Windows CE compares to the desktop in each of these areas. eMbedded Visual Tools 3.0 is discussed in depth. To help the reader decide which tools to use, development with Visual Basic, Win32, MFC, and ATL are explained. Text editor samples with this article have been developed with Visual Basic and Win32 so their implementations can be compared.

Paul Yao

MSDN Magazine January 2001

Problems moving an InfoPath form from a DEV system to QA environment


We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

Applying SQL 2008 SP1 CU 2 in MOSS environment


Hi all,

I have a dedicated SQL 2008 x64 std edtion with SP1  for MOSS 2007 SP2, I would like to apply the CU2 for activating the lock memory page feature, I would like to know if there any incidence on the sharepoint farm after applying this CU on my SQL server?

Thank you for your feedback about that.




Migrate DB + files outside DB into SharePoint using SSIS and scripts


Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....

So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.  

Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...

Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!



.net 3.5 - Compiling solely for 64 bit environment

I needed my .net project to be workable in 32 bit, 64 bit separately..core idea is 64 bit compiled exe shouldn't work on 32 bit, I am not using any unmanaged codes, its a simple application, If I set the target for compiling 64 bit machine, will this work out? if not can anybody give a solution for it?   Thanks in advance 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend