Post reply

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

  • 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.

  • December 3, 2013 at 7:46 am

    #1670395

    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?

  • December 3, 2013 at 9:47 pm

    #1670582

    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

  • December 3, 2013 at 11:40 pm

    #1670599

    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.

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

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