in

Browse by Tags

  • Problem: Import data into SQL from Flat File

    I have a CSV with three columns that I want to import into an SQL table. Upon importing, I need to add an ID column to my flat file data set that increments the next ID number that already exists in a "GroupNum" column in the table I am importing to. This is not an identity column that automatically...
    Posted to DTS (Forum) by microsoft on 05-31-2009
  • Problem: SQL Agent Authentication Issue

    I have a master SSIS Package that executes several packages via Execute Package Controls. The packages that use Connection Managers of type ADO.NET for none MS SQL database connections and OLE DB for MS SQL database connections run fine, without any errors. The problem exhibits itself when a package...
    Posted to DTS (Forum) by microsoft on 05-29-2009
Page 1 of 1 (2 items)