SQL Svr 2005 Express Does NOT Support DTS

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • GeorgeM
    #1

    SQL Svr 2005 Express Does NOT Support DTS

    <I posted this message in comp.databases Group and then realized this
    is a more MS SQL Svr centric group . ... so re-posting it here.>

    Gentlemen, any workarounds for DTS in Expression version?

    My goal is to populate a new DB I created with CSV files ... after
    reading through dozens of posts it was apparent that DTS is the way to
    go and then only to find SS-05 Express doesnot support it.

    Thanks in advance.

    George

    Tags: None
    • John Bell
      #2
      Re: SQL Svr 2005 Express Does NOT Support DTS

      Hi George

      You could try using BULK INSERT or BCP with a format file.

      John

      "GeorgeM" <gm@personaltra der.biz> wrote in message
      news:1144511615 .708546.208750@ v46g2000cwv.goo glegroups.com.. .[color=blue]
      > <I posted this message in comp.databases Group and then realized this
      > is a more MS SQL Svr centric group . ... so re-posting it here.>
      >
      > Gentlemen, any workarounds for DTS in Expression version?
      >
      > My goal is to populate a new DB I created with CSV files ... after
      > reading through dozens of posts it was apparent that DTS is the way to
      > go and then only to find SS-05 Express doesnot support it.
      >
      > Thanks in advance.
      >
      > George
      >[/color]


        Comment

        • GeorgeM
          #3
          Re: SQL Svr 2005 Express Does NOT Support DTS

          Hi John,

          Tnx for the suggestion. But from what I have read in BOL on SS-05
          Express, it does not appear it supports BCP.

          George

            Comment

            • Erland Sommarskog
              #4
              Re: SQL Svr 2005 Express Does NOT Support DTS

              GeorgeM (gm@personaltra der.biz) writes:[color=blue]
              > Tnx for the suggestion. But from what I have read in BOL on SS-05
              > Express, it does not appear it supports BCP.[/color]

              Without looking, I say that SQL Express supports BCP. Either the command-
              line tool, or the BULK INSERT statement in T-SQL.


              --
              Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

              Books Online for SQL Server 2005 at
              http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

              Books Online for SQL Server 2000 at
              http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                Comment

                • Maury
                  #5
                  Re: SQL Svr 2005 Express Does NOT Support DTS

                  Erland Sommarskog ha scritto:[color=blue]
                  > Without looking, I say that SQL Express supports BCP. Either the command-
                  > line tool, or the BULK INSERT statement in T-SQL.[/color]

                  I use BULK INSERT statement with SQL Svr Express 2005
                  and it's a great feature ...

                    Comment

                    Previous template Next
                    Working...