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?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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