I am creating a Excel file dynamically using a script, excute sql and then the dataflow.
I am not able to cretae a excel sheet name without an underscore
exisitng file: "team data" even though am giving the table name in excute sql task(which is excel sheet name) as "team data" it is creating the name as "team_data" because of which the package is failing?
I am able to achieve this with an underscore, as it is a client requirement to generate wihtout an underscore am posting this question.
Is this an issue with Sql server 2005?
View Complete Post