Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yukon_dba
Starting Member
10 Posts |
 Posted - 2007-12-08 : 10:40:29
|
| Hi 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 of 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 asked 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 table. Output results of the table are 5 columns. Eventually the code and automated import process will be implemented in a database.(Note: this sql server 2000 environment)Please i would appreciate if anyone can guide me to make this package .Thank u allYukon DBA |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-08 : 11:24:23
|
Hmmm.Might need to provide a little bit more info. Most of us are fresh out of randomly specific DTS package creation script.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-08 : 17:50:27
|
| You can create a job with two steps, first one loading data from excel and second one creating merged table with sql code. |
|
|
|
|
|
|
automated package to import and merge tables