Viewing 14 posts - 1 through 14 (of 14 total)
Glad it was useful for you!
March 12, 2009 at 5:27 pm
Anyone having problems reading the graphics please note your contact address/email here and I will send you a copy of the article. (if you don't mind)
At this time I am...
September 10, 2008 at 6:15 pm
Good question! I have not tried it with changing numbers of columns/tab or file. Any ideas anyone?
Hmmm, are we saying that the TABLE itself has multiple...
January 31, 2008 at 8:33 am
Yeah, I totally agree. I think I had hoped everyone could download the article so that way could expand the screenprints to any size they wanted. If you...
January 10, 2008 at 6:15 pm
Listing Variables in the article:
ExcelTab
ExcelFileName
SubDataSet
obj_ListofGrouping
Grouping
SubGrouping
This is a situation of variables within variables. Grouping is used to define the ExcelFileName which is used in the Excel Connection Manager
Subgrouping...
January 10, 2008 at 5:00 pm
When creating the solution did you have an excel workbook with at least one spreadsheet in it containing the appropriate headings?
I believe we all ran into the same thing and...
January 10, 2008 at 12:23 pm
Sorry, wrong button!
To continue:
By setting the pre-defined variable 'Listof Groups' equal to INDEX 0 you then have all the values you populated in the 'List of Countries' object from the...
January 10, 2008 at 11:27 am
Someone asked for all the variables so we go:
ExcelTab - which populates the excel tab/spreadsheet. This value actually comes from the query in the first Execute Sql Task (Called Create...
January 10, 2008 at 11:05 am
Hmmm, something must be lost in the translation... 🙂 This solution indeed will create multiple files and each can have multiple tabs/spreadsheets with their own specific data.
The key...
January 10, 2008 at 8:11 am
Forum Newbie: Is the last question aimed at this article? The article does not use:xp_cmshell
But I can say that if you populate the tab cursor from the SQL...
January 9, 2008 at 1:57 pm
to create the file on the sharepoint site I would try to treat it just as a file address. That means in your variable (see the article for specifics) I...
January 9, 2008 at 12:31 pm
SQL Server Version = 2005
Not sure about pushing to a sharepoint doc. Can you give me some more details? You want to push to a specific type of...
January 9, 2008 at 11:50 am
Radovan:
Were you able to pull down an actual version of the article? If so, you should be able to expand the screen prints. As well, I have posted...
January 9, 2008 at 11:07 am
Hopefully here are some answers to the questions:
1. The filename actually is a variable. The variable was populated in the first Execute SQL task BEFORE the Foreach Loop. ...
January 9, 2008 at 10:42 am
Viewing 14 posts - 1 through 14 (of 14 total)