June 15, 2009 at 3:19 am
HI,
I am working on creating a SSIS package to export data from sql server to excel. I created on excel connection manager and used it in excel destination. I want to create dynamic tables in excel . so i used new table option in excel destination. I used data conversion task to string data type . Unfortunately i am not able get dynamic tables at run time. if i change the create table query in excel destination its working fine. But i am not able to configure how to dynamic tables with out changing the sql script every time i run the package. Please advise me
Surya
June 15, 2009 at 8:16 pm
Check out this article: http://www.sqlservercentral.com/articles/Integration+Services/61542/
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 15, 2009 at 8:34 pm
Thanks for your reply. I will go through the article
Surya
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply