Viewing 15 posts - 11,371 through 11,385 (of 13,861 total)
Sean Lange (5/26/2011)
Phil Parkin (5/26/2011)
I use a binary search to do this...
Phil the pedant steps in 🙂
What you have described is a 'bisection method' - a binary search acts on...
May 27, 2011 at 1:45 am
asm1212 (5/26/2011)
I have done that however, he doesnt want to copy over the sp's and other objects, he just wants the data...also our backups are only on tape...
It would be...
May 26, 2011 at 1:29 pm
"This kind of data" does not really cut it as far as a spec is concerned. Also, this is not strictly duplicate data.
So far, my spec would be along the...
May 26, 2011 at 12:57 pm
Have you considered a straightforward backup/restore?
May 26, 2011 at 12:48 pm
Open the package in BIDS, then File/Save a Copy ...
Or just copy/paste the underlying .DTSX file.
Check afterwards that the package IDs for the two packages are not the same (if...
May 26, 2011 at 10:05 am
I use a binary search to do this...
Phil the pedant steps in 🙂
What you have described is a 'bisection method' - a binary search acts on a sorted array.
May 26, 2011 at 8:30 am
Please state expected results for
SELECT *
FROM Structure
WHERE product = 'Part A'
Would you want to see Part Y in the results?
May 25, 2011 at 4:54 am
An easy way round that is to use the same file name every time as the destination, but to have a FST afterwards to copy it wherever you want.
The template...
May 25, 2011 at 2:17 am
When you have the desired resultset in memory, use .NET to write to an Excel spreadsheet.
For the flexibility which you require, you may need to install Excel on your server...
May 24, 2011 at 2:42 pm
Not easy at all in SSIS.
Solution 1
Put the query in Excel and bypass SSIS completely.
Solution 2
Check out third-party components such as this one, which might give you the dynamic columns...
May 24, 2011 at 2:24 pm
vax09 (5/24/2011)
Please Provide me Step by Step Information because i am new in it.and it is interview screening question.
You must be joking. Not a chance.
May 24, 2011 at 12:53 pm
My suspicion at (1) above was right. Something else is failing the package and it's not being reported - the config warnings were only warnings as suggested - I'll investigate...
May 24, 2011 at 10:40 am
vax09 (5/24/2011)
Any one provide Step by Step information.that will be great help.
Please do some Internet searches to get this basic information and then come back here with any specific questions....
May 24, 2011 at 8:11 am
I'm tied up with something else for a while, so cannot try your suggestion Koen, but just responding to a couple of the points:
1) Even though those config file messages...
May 24, 2011 at 5:50 am
Thanks for the quick response - this is SSIS 2005.
Here is my command line, edited slightly to protect the innocent:
/FILE "T:\SSIS\Packages\abcde\bin\abcde - ERD.dtsx" /CONFIGFILE "T:\SSIS\ConfigFiles\Common\SMTP.dtsConfig" /CONFIGFILE "T:\SSIS\Packages\abcde\Config\Custom - ERD.dtsConfig"...
May 24, 2011 at 4:11 am
Viewing 15 posts - 11,371 through 11,385 (of 13,861 total)