Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: S1002
  • Content: Threads
  • Order by date
  1. S1002

    Merging files dynamically

    Here is the Code we were using to merge multiple csv files with same format in to one Csv file How can I make use of this code in ssis or how can I rewrite it to perform the same function. Thanks for the help in advance. Dim sFilename As String Dim PathName As String Dim...
  2. S1002

    Sql to Excel detination

    Hi, I created a SSIS package to export data from SQL query to Excel I had to do data conversion to get rid of the converion errors str to unicode datatypes. I used OLDB detination with extended property as 8.0 because my excel destination is MicroSoft Excel 97-2000 Can anyone please help me...
  3. S1002

    SQl server 2000 scheduling jobs

    Can a user with fixed database role given sql authentication to connect to the sql server schedule jobs by any means. Thank you
  4. S1002

    SQL Server 2000 DTS Package Active X Help

    I have a Package which can process any number of files and after processing each file it Archives the Processed file in the Archive Folder. I cannot reprocess/Import the same file again(in case by mistake) to avoid this i need to put a check before each run to check the archive folder with the...
  5. S1002

    Help with Active X Script in DTS Package

    Please help me I have a DTS package with ActiveXScript that can process any number of files(CSV files) but the logic in the SQLcode inside the package needs the files to be processd in an order by the name of the file,example say i have 3 files-- (left 8 digits in the file name is the actual...

Part and Inventory Search

Back
Top