Viewing 15 posts - 691 through 705 (of 887 total)
jeberhard-623651 (12/22/2011)
Why can't SSIS export data from a SQL stored procedure to an Excel file, overwriting the excel file each time it runs? AM I missing something?
I guess it's...
December 23, 2011 at 10:03 am
srik.kotte (12/22/2011)
December 22, 2011 at 8:33 am
The data was truncated because it could either not fit into the destination column, or your metadata is not correct.
Check the input/output columns in the data flow, and also make...
December 22, 2011 at 8:13 am
srik.kotte (12/16/2011)
Not from BIDS. I want something like that in sql agent.
SQL Agent is a scheduling tool only...not a development platform. You cannot create components for user interaction (like inputboxes)...
December 16, 2011 at 12:55 pm
srik.kotte (12/16/2011)
I have a requirement like this.When someone executes my ssis package, I want the user to be prompted to fill in a few parameters. How do i do...
December 16, 2011 at 9:19 am
Please do not double post...
Replied here: http://www.sqlservercentral.com/Forums/Topic1221537-364-1.aspx
December 14, 2011 at 8:02 am
rasikawtc (12/8/2011)
Thanks Martin...but can someone please give some more information on how to do it in SSIS as I am not familiar with it .
Books Online is your friend in...
December 8, 2011 at 10:53 am
rasikawtc (12/8/2011)
Is there a way to split a huge excel file into smaller files while exporting
for example if there are 10,0000 rows in the report when exported into excel...
December 8, 2011 at 10:36 am
I think the issue could be how SSIS passes that parameter...
Use the expression builder in the Execute SQL Task properties to set the "SqlStatementSource" propery of the task.
The expression should...
December 2, 2011 at 10:48 am
onebite2 (12/2/2011)
1. I have some excel files in a folder(each file has different columns).
2. Files are not the same all the time.
3. I need to import files...
December 2, 2011 at 10:35 am
onebite2 (12/2/2011)
Set @sqlStr='select * into ' + @FileName + ' FROMOPENROWSET (''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=C:\ExcelFiles\' + @FileName + ''', [Sheet1$])'
exec(@sqlStr)
A couple things to mention here:
1. Have you attempted to execute...
December 2, 2011 at 10:23 am
imani_technology (11/30/2011)
November 30, 2011 at 9:42 am
Fred, you will have to supply a little more information.
It isn't clear from your example whether the groups across are static or dynamic, and the same goes for the rows....
November 29, 2011 at 9:50 am
Sorry...need to rephrase.
Check the query in management studio first. Does it work there? If it does, are you pointing to the right database in your task? It seems to have...
November 23, 2011 at 11:11 am
Viewing 15 posts - 691 through 705 (of 887 total)