BI Developer Network Community

Who is online?  0 guests and 0 members

Featured Articles

  • Accessing Sharepoint List Data From SSIS
    12/10/2010 - A method of accessing data within Sharepoint lists from an SSIS Script component

  • Informatica Online Training
    16 days ago - Slake Software Solutions is one of the leading top Training and Consulting Company in Online, with a good placement track record. Slake Software Solutions have certified trainers. We will provide Online Training, Fast Track online training, with job assistance.

  • Scheduling your deployed package to run
    8 hours ago - A step by step instruction on using SQL Server Agent to schedule your Integration Services packages to run automatically.

  • Deploying your package from BIDS
    16 days ago - A basic tutorial on deploying a basic ETL package through Microsoft BIDS.

  • Instead Of the OLE DB Command Transform
    15 days ago - SSIS Alternative to OLEDB Command Transform

  • Pivoting Diagnoses, Procedures and POA using a Stored Procedure called from SSIS
    8/3/2011 - In this article, I describe the way in which I used a stored procedure to pivot data into columns as well as the use of SSIS in automating the process of extracting data from SQL Server, transmitting to my customer and notifying us in an automated fashion.

  • Handling Complex Text Files in SSIS
    12/7/2011 - One of the challenges when working with flat files in SSIS comes when record types are mixed in a single file. This is a common scenario in health care where often times header and detail records and mixed and are only tied together by the fact that they occur sequentially in the flat file. Unfortunately SSIS has no built in process to help a developer overcome this hurdle. Luckily with a little bit of code and the script transformation we can parse and process these types of file with ease.

More Featured Articles

Recent Activity RSS Feed

What's New

Welcome and Intro to BIDN.com

New Members

  • dana803 has joined the community
  • Rager has joined the community
  • orlovvad has joined the community
  • EACounts has joined the community
  • miroprocessor has joined the community
  • Jahid has joined the community
  • JHoward has joined the community
  • user610781 has joined the community
  • prashanthg has joined the community
  • Sharath048 has joined the community
Business Intelligence Developer Network (BIDN.com) on Facebook