Post reply

Using .Net programming , create SSIS package that will import Textfile data into SQLServer

  • November 4, 2006 at 3:17 am

    #114915

    Iam recently working in SQLServer 2005 Integration services. I need to create a SSIS package.This package has to import a Text file data into SQLserver database. All these should be done through .Net program , not through Import/Export wizards.

    Could anyone help me in this issue? Pls reply me soon. 

     Thank you

    Nirmala

  • November 4, 2006 at 5:20 am

    #669963

    Hi Nirmala,

    I'm sorry but I don't know what you mean by Import/Export wizards when you talk about SSIS.  The Control Flow tasks and Data Flow components in SSIS are not wizards, so using them to perform your import and the population of your destination table would not violate your requirement.  In fact, think of BIDS as a specialized .Net program (fyi, BIDS is built on the .Net framework) that is simply a wrapper around the .Net code that you wanted to generate.

    Using these objects is by far the easiest and best way to accomplish your task.   It sounds like you have a fairly straightforward task (import from flat file into database table), so if you need help getting started with how to use these objects, then I highly recommend using the SSIS Tutorial in SQL Server 2005 Help. It’s very good at explaining the basics.

    I hope this helps.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply