Page 1 of 1
How to load spreadsheets data into SQL Server thru Datastage
Posted: Wed Jan 09, 2008 2:20 pm
by aschand
Hi,
Can any one please explain me the procedure of loading a spread sheet data into a SQL Server with the table created already in the SQL Server using Datastage where SQL Server is the source.
Thanks for your Help
aschand
Posted: Wed Jan 09, 2008 3:36 pm
by ds2000
If source is spread sheet then just use the SEQUENTIAL FILE stage and link to database stage. do your transformation in any appropriate stage or use transformer in between.
Posted: Wed Jan 09, 2008 4:46 pm
by aschand
Thanks for your reply....
But here the source is SQL Server... So how do I load spreadsheet data into SQL Server using Datastage Parallel job?
ds2000 wrote:If source is spread sheet then just use the SEQUENTIAL FILE stage and link to database stage. do your transformation in any appropriate stage or use transformer in between.
Posted: Wed Jan 09, 2008 5:17 pm
by ray.wurlod
Source is SQL Server. Target is SQL Server. Where does "spreadsheet" come into the picture?
Which is it: SQL or Excell?
Posted: Wed Jan 09, 2008 5:19 pm
by rjhcc
You are asking how to load an Excell file into SQL Server and you have been shown how.
I'm not sure I know how your data can be an Excell file and a SQL Server table at the same time.
Please clarify.....be specific...