Forum Replies Created

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

  • RE: Openrowset don't show all columns

    Thanks, i will test it today. I will let you know if it works

    Lowell (7/12/2010)

    i'm thinking something like this:

    bring everything is as one big field...i'm assuming varchar(8000) would hold it,...

    July 12, 2010 at 12:12 pm

    #1191630

  • RE: Openrowset don't show all columns

    leonardo.castillo (7/12/2010)

    Lowell (7/12/2010)

    WayneS (7/12/2010)

    Did changing to the SQL Native Client driver help out? As I demonstrated, it seems to work for me.

    Wayne i thought the OP was running into the...

    July 12, 2010 at 10:05 am

    #1191562

  • RE: Openrowset don't show all columns

    Lowell (7/12/2010)

    WayneS (7/12/2010)

    Did changing to the SQL Native Client driver help out? As I demonstrated, it seems to work for me.

    Wayne i thought the OP was running into the fact...

    July 12, 2010 at 10:04 am

    #1191561

  • RE: Openrowset don't show all columns

    Thanks for your reply. I don't request a standard text file because is generated by a closed application. It's depends of the results of polls (less o more answers). This...

    July 12, 2010 at 6:49 am

    #1191431

  • RE: Openrowset don't show all columns

    Thanks.

    Yes, SSIS is an option, but the txt files varies from load to load (less o more columns). For this reason is not posible use a SSIS.

    Any ideas?

    July 9, 2010 at 3:27 pm

    #1191045

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