December 15, 2008 at 10:53 pm
Hi all,
I need to do a SSIS package,which imports data from excel to sql server database,which shud be dynamic.
I'll be having tables in Excel sheet,whenever i run this package,it shud create tables in SQL server database and data shud get loaded.
Im new to this..
Can anyone help me on this?
Regards
December 18, 2008 at 1:04 am
Dude, where do we start! there many ways to do this.
Simplest would be,
Assuming the following:
- You will have the same tables during every import
- You have already worked out how you will get the everyday
1. Create the tables with the correct columns
2. Create an SSIS package which will be based on a 'Data Flow Task'
3. Use a Flat file (XLS File) ---> OLE DB DataFlow
4. Set up a job in SSM to run the package as and when
You need to provide a lot more detail in what you have done already and any ideas you have.
December 18, 2008 at 9:22 am
HI,
Even I have similar query...
We have an excel sheet template as table and we need to store structure in the database(SQL Server)
Reqt : I need to write a script so that "All tables primary keys we will log in a table.. (One time script).. Based on this table we need to write a script to identify whether particular column is primary key or not.."
Whenever this excel template is updated with more columns, I also need to write a script so that excel template is compared with SQL Server database, and if columns are added, I need to write a script so that an "Alter table" script is invoked to modify the structure in the database(SQL Server).
Please help me ASAP as per the approach. I am a new joinee and I need expert instructions on the approach
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply