Search Results: Server

• 
  Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool

  This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using a Script Task component

  Author:  mafiswana     Date: 3/25/2012     Section: Article

  tags : C#, create package, C-Sharp, Data Flow Task, dynamic, Flat File, OLE DB, OLE DB Destination, package, programmatic, script task, SQL Server, SQL Server 2008, SQL Server Intergration Services, SSIS, SSIS package, Text File
• 
  Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.

  Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don?t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVE

  Author:  JoseChinchilla_SQLJoe     Date: 10/11/2011     Section: Blog

  tags : build, cumulative, edition, editions, service pack, SQL Server, update
• 
  BULK INSERT

  « 1| 2 | 3 » Recently, there was a post where the user found himself in a problem when loading data utilizing BULK INSERT This post is the first from a series, wich I want to explain how to use BULK INSERT in multiple possible ways. BULK INSER

  Author:  marcoadf     Date: 1/13/2012     Section: Blog

  tags : bulk, bulk insert, column, csv, fieldterminator, file, firstrow, flat, fmt, format, identity, identity column, insert, lastrow, rowterminator, Server, skip, txt, view
• 
  SSIS 2012: Programmatically Create Catalog

  This article uses a Script Task in SQL Server Data Tools to demonstrate creating a catalog and catalog folder.

  Author:  mafiswana     Date: 7/18/2012     Section: Article

  tags : C#, C# programming language, Catalog, CatalogFolder, IntegrationServices, Managed Object Model, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, script task, SMO, SMO Server, SQL Server 2012, SQL Server Integration Services, SSIS, SSIS 2012, Visual Studio 2010
• 
  SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”

  Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed " Denali ". Its purpose is to provide a single development environment for all database-related project types by br

  Author:  jamserra     Date: 7/6/2011     Section: Blog

  tags : Juneau, SQL Server, SQLServerPedia Syndication, SSDT, Visual Studio 2010, Denali
• 
  Dump MDX OLAP Query output to a relational table from SSMS

  I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.

  Author:  artuladhar     Date: 5/16/2012     Section: Blog

  tags : dump, file, MDX data, OLAP, output, query, Table
• 
  Monday Morning Mistakes: Remote Connectivity to SQL Server

  Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes folks make with SQL Server called Monday Morning Mistakes (or #sqlM3 for short, since we all love quick hashtags these days). These are meant a

  Author:  sqlchicken     Date: 1/23/2012     Section: Blog

  tags : Connection Error, Connectivity, Monday Morning Mistakes, SQL Server, tips, Tips and tricks, tips-n-tricks
• 
  Why not use an SSIS SQL Server Destination

  Once upon a time, in SQL Server 2005, the SQL Server team was working tightly with the SQL Server product team to reserve a special spot of shared memory for SQL Server for SSIS to dump into and then as SQL Server would write into the database seamlessly.

  Author:  BrianKnight     Date: 6/24/2010     Section: Blog

  tags : performance tuning, sql server destination, ssis
• 
  Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

  SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#.

  Author:  mafiswana     Date: 8/14/2012     Section: Article

  tags : CatalogFolder, Create SSIS Package, Managed Object Model, Microsoft Visual C# 2010, Microsoft.SqlServer.Dts.Runtime, Microsoft.SqlServer.Management.IntegrationServices, Microsoft.SqlServer.Management.Smo, SSDT, SSIS 2012, SSIS Catalog, Visual Studio 2010
• 
  Scheduling an SSIS Package with SQL Server Agent

  In this article, Dustin covers how to use SQL Server Agent to schedule an SSIS package's execution.

  Author:  DustinRyan     Date: 12/1/2009     Section: Article

  tags : Schedule a package, SSIS package, SQL
• 
  SSIS Data Flow task not running, but not failing

  I'm not sure what's left, personally, I'd probably take the following steps ( top to bottom ) to see if I could get anymore info before option 4 ( support call ). Have you checked the error log for SQL server as well as the event viewer ( maybe export / c

  Author:  KeithHyer     Date: 11/30/2011     Section: Forum

  tags : ADO.Net, data flow performance, ODBC, permissions, PI WADIS
• 
  Save Frequently Used Connections in SQL Server Management Studio

  If you're like me, you probably have a significant number of servers you access on a regular basis, which means every time you start up SQL Server Management Studio (SSMS) you have to log in to each server typing in user names and passwords and connecting

  Author:  DustinRyan     Date: 6/24/2010     Section: Blog

  tags : save database connections, Registered servers
• 
  An open letter to Microsoft - BI needs to be a single message across your products

  An open letter to Microsoft – BI challenges. To preface this letter, let me just say that I have drunk the kool-aid, just like the Merry Pranksters drank Ken Kesey’s koolaid ( http://en.wikipedia.org/wiki/The_Electric_Kool-Aid_Acid_Test ), and

  Author:  MarkGStacey     Date: 4/28/2012     Section: Blog

  tags : Office, PerformancePoint, PPS, Report Builder, Reporting Services, sharepoint2010, SQL Server, SQL2012, SSRS, Visio
• 
  Installing SQL Server 2005 along side SQL Server 2008

  I walked into a funny situation today in which I needed to install SQL Server 2005 after already installing SQL Server 2008 R2. When I ran the Setup for 2005, I got this wonderfully descriptive error message: An installation package for the product Micros

  Author:  Tyler     Date: 9/8/2011     Section: Blog

  tags : 2005, 2008, installing
• 
  Terminology Differences between Team Foundation Server and Subversion

  I've been knee deep in Team Foundation Server 2010 reading and found a useful table describing the Terminology differences between Apache Subversion and Team Foundation Server. Not all the credit is mine, I got the list of differences from Wrox Profession

  Author:  Tyler     Date: 9/12/2011     Section: Blog

  tags : 2010, foundation, Server, Subversion, Team
• 
  Execute a SSIS package

  Yeah sorry, I have so many problems lately and each time I think I found the solution, it doesn't work ^^' Thanks a lot to this website, I've been able to find how to do a lot of things. But nowm, after deploying my SSIS Package on my SQL Server 2005, I'm

  Author:  GuillaumeDrolet     Date: 10/14/2011     Section: Forum

  tags : DTS, error, JOB, Package, SQL Server Agent
• 
  SSRS Deployment Issues: Protocol Violation

  While I was trying to deploy some reports to my local machine, I ran into an error I had not seen before. Apparently, BIDS could not connect to the report server on my local machine because of a protocol violation. I first checked to make sure that my rep

  Author:  ShawnHarrison     Date: 6/8/2010     Section: Blog

  tags : Deployment, Port 80, Protocol Violations, Reports, SSRS
• 
  SQL Server 2008 R2 for the DBA Recording and PowerPoint

  I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session there were approximately 150 attendees and at the second there were approximately 400 attendees. The recording is available here and you can download

  Author:  PatrickLeBlanc     Date: 7/23/2010     Section: Blog

  tags : Patrick LeBlanc, Speaking, SQL Server, R2
• 
  Using Registered Servers in Managment Studio By Andy Warren

  Today's featured video on SQLshare / Jumpstart TV is Using Registered Servers in Managment Studio By Andy Warren . Until I saw this video I didnot know about the Registered servers view in sql server 2005 even though I have been using the Management studi

  Author:  indupriya     Date: 10/18/2010     Section: Blog

  tags : registered servers, SQL server Management studio
• 
  SQL Server™ Schemas and Data Warehouse Solution Organization

  Good organization helps us to develop efficiency and, even more importantly, increases our solutions understandability. Organizing the physical implementation of a business intelligence solution’s data tier within SQL Server™ is critical for organizing th

  Author:  JoeSalvatore     Date: 2/25/2011     Section: Blog

  tags : 2008, 2008 R2, Business Intelligence, Data Design, Schemas, SQL Server, SQL Server Versions, 2005
• 
  Upgrade 2005/2008 SSIS Packages to 2012 Like a Boss!

  With the release of SQL Server 2012 comes a whole host of improvements to Integration Services that makes development and administration of your SSIS packages much easier. And it also looks new and shiny, so you can't beat that. After you've upgraded to S

  Author:  DustinRyan     Date: 3/19/2012     Section: Blog

  tags : ssis package parameters, ssis project deployment model, Upgrade SQL Server 2012, Upgrade SSIS packages 2012
• 
  Memorized Reports

  While all suggestions are good ones, you could capture the results of the parameters and the users from the ReportServer database. There are executions of each report, who executed them, how long it took and a lot more. With that being said, you would jus

  Author:  briankmcdonald     Date: 9/10/2012     Section: Forum

  tags : Brian K. McDonald, parameters, Pro SQL Server 2012 Reporting Services, SQLBIGeek
• 
  SQL Server “Denali”: CTP3 now available!

  CTP3 of SQL Server Code Name "Denali" was made available for download this morning. You can download the 32-bit and 64-bit versions here . Official announcement from the SQL Server team blog and the announcement from the Analysis Services and PowerPivot T

  Author:  jamserra     Date: 7/12/2011     Section: Blog

  tags : Juneau, Project Crescent, SQL Server, Denali
• 
  SSIS Docuementation with BI Documenter

  BI Documenter is a fantastic tool for SQL Server documentation. It documents your servers, and the BI stack (AS cubes, IS packages, reports). However, there seems to be a lot of confusion when documenting SSIS packages. A common issue I see is that a user

  Author:  ShawnHarrison     Date: 9/7/2011     Section: Blog

  tags : BI Documenter, documentation, management objects, stuff you need
• 
  How can we know and free remote login session in Windows Server 2008 ?

  Through this post , I want to share about the problem we faced while working in Windows Server 2003/2008. In our day to day work , we might frequently need to connect to remote Windows Server machine and while we try to connect to the Windows Server which

  Author:  Anil     Date: 29 days ago     Section: Blog

  tags : Windows Server