+ Reply to Thread
Results 1 to 4 of 4

CSV is coming in sorted order in SQL table through SSIS Package(SQL server)

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    India
    MS-Off Ver
    Excel 2003/Excel 2007
    Posts
    4

    CSV is coming in sorted order in SQL table through SSIS Package(SQL server)

    Hi,

    I have created a SSIS package that extracts data from CSV file and dumps into a SQL table.

    The data is coming in sorted order in SQL table , which I do not want, I want it to come as it is(as per CSV).

    Please suggest a work around for the same.

    Note: I am using SQL Server 2008

    Thanks in advance!

    Regards,
    Tushar!

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: CSV is coming in sorted order in SQL table through SSIS Package(SQL server)

    What's this got to do with Excel?

  3. #3
    Registered User
    Join Date
    03-22-2011
    Location
    India
    MS-Off Ver
    Excel 2003/Excel 2007
    Posts
    4

    Re: CSV is coming in sorted order in SQL table through SSIS Package(SQL server)

    I am in turn calling/importing this SQL table in Excel..

    If any one has a solution to it please help!

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: CSV is coming in sorted order in SQL table through SSIS Package(SQL server)

    You'd be better of asking this on a SQL server forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1