automated procedure to import data | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
automated procedure to import dataHi all,
I have to create a automated package. Firstly i have to import 2 specific columns from a excel file to create table1 in a database. then i have table2 with 20 columns out which i need only 3 columns. so its goes like this , i want to merge table1( 2 columns) with table 2 ( 3 specific columns) to create a new 3rd table with 5 columns. I want all these to automated.Here below is what my manager ask me to do for more clarification.The plan should be: Automated Import of Excel file to a table.Automated code as stored procedure which will compare another table to this imported tableOutput results of the table are 5 columns.
Eventually the code and automated import process will be implemented in a database.
Please i would appreciate if anyone can guide me to make this package .Thank u allYukon DBA
I am working on sql server 2000….
Locking this thread as originator has created same thread under right category in below link.
Please continue the discussion here