Viewing 15 posts - 4,141 through 4,155 (of 11,678 total)
This article sums it up rather nicely:
November 26, 2013 at 3:31 am
You could use named ranges in the Excel destination to write to different parts of the Excel sheet, but you'd need to know the number of rows of each extract...
November 26, 2013 at 3:26 am
IgorMi (11/26/2013)
These settings I've done on a client machine with RAM of 128 GB were following:
max server memory set to 112 GB
min server memory set to 64 GB
My suggestion...
November 26, 2013 at 3:21 am
If all of the tables have the same format you can append the results together using UNION ALL (either in the source query itself or in the SSIS data flow).
If...
November 26, 2013 at 3:17 am
What if you run pkgA directly on the server, without pkgB starting it?
November 26, 2013 at 2:13 am
AShehzad (11/26/2013)
November 26, 2013 at 1:52 am
SSIS doesn't really support this natively, but you can use BIML to read the metadata from the Excel file and create the data sources for you.
November 26, 2013 at 1:15 am
You can use DDL triggers for example:
or you can use policy based management:
Administer Servers by Using Policy-Based Management
PBM has its disadvantages though. If you create a rule for your...
November 26, 2013 at 1:10 am
ISuleymanovH (11/26/2013)
WOW!!!Many Many thanks for your answers
No problem, glad to help.
November 26, 2013 at 12:47 am
I'm not 100% following regarding the set-up of your package.
but the next step starts about 5 seconds
What is the "next step"? Another transformation in the data flow? Another package called...
November 26, 2013 at 12:46 am
That question is hard to answer without more information.
This article gives you some pointers:
November 26, 2013 at 12:31 am
I don't think this is the expected behaviour.
Are you sure the user doesn't have other permissions?
November 26, 2013 at 12:28 am
You never ever execute the code inside @qry.
You just store some string in it (which happens to be a SQL statement, but that doesn't matter).
Then you check if @qry is...
November 26, 2013 at 12:17 am
What if you try the following?
\\computername\d$\SSRS\Images\Help.pdf
November 26, 2013 at 12:12 am
Viewing 15 posts - 4,141 through 4,155 (of 11,678 total)