Writing single excel file dynamically to sql server table using script task

Question

Writing single excel file dynamically to sql server table using script task

Shadab Shah

SSCarpal Tunnel

Points: 4759
More actions
December 3, 2013 at 6:34 am

#301042

I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question over here. 🙂
I am trying to write a dynamic excel file (in my case dynamic means the number of rows are not know ).
using Script task :doze: to a table in sql server database.
I tried googling but none of them work for me.
Could any body please recommend any good link from where i can read and do some trying and come up with a solution .
Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246686 More actions · Answer 1

Shadab Shah (12/3/2013)
I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question over here. 🙂
I am trying to write a dynamic excel file (in my case dynamic means the number of rows are not know ).
using Script task :doze: to a table in sql server database.
I tried googling but none of them work for me.
Could any body please recommend any good link from where i can read and do some trying and come up with a solution .
Thanks.

Number of rows is not really relevant when doing an import. Sounds like a straightforward import - what have you tried?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Shadab Shah SSCarpal Tunnel Points: 4759 More actions · Answer 2

Phil Parkin (12/3/2013)
Shadab Shah (12/3/2013)
I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question over here. 🙂
I am trying to write a dynamic excel file (in my case dynamic means the number of rows are not know ).
using Script task :doze: to a table in sql server database.
I tried googling but none of them work for me.
Could any body please recommend any good link from where i can read and do some trying and come up with a solution .
Thanks.
Number of rows is not really relevant when doing an import. Sounds like a straightforward import - what have you tried?

Ooops !!! typo sorry .... its actually the number of columns

Phil Parkin SSC Guru Points: 246686 More actions · Answer 3

Shadab Shah (12/3/2013)
Phil Parkin (12/3/2013)
Shadab Shah (12/3/2013)
I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question over here. 🙂
I am trying to write a dynamic excel file (in my case dynamic means the number of rows are not know ).
using Script task :doze: to a table in sql server database.
I tried googling but none of them work for me.
Could any body please recommend any good link from where i can read and do some trying and come up with a solution .
Thanks.
Number of rows is not really relevant when doing an import. Sounds like a straightforward import - what have you tried?
Ooops !!! typo sorry .... its actually the number of columns

Not supported out of the box in SSIS.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.