Viewing 15 posts - 796 through 810 (of 1,241 total)
EXEC SP_HELPTEXT 'schema.viewName';
This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.
January 23, 2015 at 11:33 am
phil.doensen (1/15/2015)
January 15, 2015 at 7:34 pm
I have not seen a mention of the Data Flow task. That is SSIS's bread and butter item for moving data around. Since you mention about 4000 rows per batch...
January 15, 2015 at 5:06 pm
I think the business intelligence products (SSIS , SSAS , SSRS ) are a huge plus if you are looking at the warehousing side of things and not...
January 15, 2015 at 4:14 pm
I think the OP may just want a general illustration , may not be solving anything in particular. Here is another method :
declare @t table
(
ID int
...
January 15, 2015 at 3:53 pm
The screen shot shows your initial size for the first file at 155GB, not 100GB.
If this picture is incorrect I can suggest tinkering with the data management views to detect...
January 15, 2015 at 3:36 pm
You could go the way of variable expressions here with a data flow within the for loop container. Unless I am missing something you could:
variable,
type,
expression
-----------------------------------
StaticFolderNum,
int32,
no expression...
January 7, 2015 at 6:04 pm
For the plan that still does not work, did you try changing the "Local Server Connection" in the maintenance plan to a custom one with the account used being Windows...
January 7, 2015 at 11:56 am
Glad you worked this out, as I suspected from reading the thread that it was some strange conversion taking place. I have found that converting to string in these situations...
January 6, 2015 at 1:53 pm
You could include both of the timestamp datetime fields in your table design. Call one like DateTimeModified, the other like DateTimeLoaded. In your (I assume) daily ETL you could select...
January 1, 2015 at 5:07 pm
Is this a one time event? If so I can offer a quick and dirty method :
1. In SSMS go to Tools > Options > Query Results>SQL Server> Results to...
January 1, 2015 at 4:57 pm
bantrim (12/31/2014)
MMartin1 (12/31/2014)
January 1, 2015 at 4:32 pm
DonlSimpson (12/31/2014)
MMartin1 (12/31/2014)
DonlSimpson (12/30/2014)
Or build a calendar table and use it in a dataset.
How would this be different? Would you have fields in the table to denote first Tuesday of...
December 31, 2014 at 4:30 pm
One of the tweaks I do is alter the max rows per batch and or commit size when transferring millions or rows with SSIS's, dataflow's ole db destination. This optimises...
December 31, 2014 at 4:21 pm
I have to wonder why you need to use a batch file. Do you need to schedule the package with Windows Task Scheduler? I myself prefer the SQL Server Agent...
December 31, 2014 at 2:31 pm
Viewing 15 posts - 796 through 810 (of 1,241 total)