Viewing 15 posts - 9,586 through 9,600 (of 11,678 total)
chetanb3 (4/15/2011)
I am executing the child packages in the Master. for datbase...
April 15, 2011 at 2:16 am
Here in Belgium we still have about 2,5 months for our taxes. Which are insanely high (about 45% of our wages go to taxes).
But I'm building a house, so I'll...
April 14, 2011 at 11:51 pm
I think you're supposed to enter only one double quote: "
April 14, 2011 at 11:35 am
Just do an insert of the flat file in a staging table. There won't be too many records I guess, so that will go fast.
Make sure you have a up-to-date...
April 14, 2011 at 11:25 am
MyDoggieJessie (4/14/2011)
Dump the contents of each file into a staging table, put an index on the column I want to look...
April 14, 2011 at 7:39 am
Tom.Thomson (4/14/2011)
English and Italian (c'รจ ,ci sono) are the only two I know where they are different.
Add Dutch to the list:
Er is <--> Er zijn
April 14, 2011 at 5:56 am
Jeff Moden (4/14/2011)
Koen Verbeeck (4/14/2011)
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Oink? You stop reading a...
April 14, 2011 at 2:49 am
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
April 14, 2011 at 2:42 am
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Oink? You stop reading a technical article about some...
April 14, 2011 at 2:37 am
Nice question, thanks.
The hint (select 2) makes the last answer "None of the above" a bit superfluous ๐
April 14, 2011 at 12:49 am
Small sidenote:
the property Run64BitRuntime is only for running packages in BIDS. This has no effect on packages deployed to another machine.
So either download a 64-bit Oracle driver (here) or follow...
April 14, 2011 at 12:24 am
Another option is to use a real delimiter, instead of the comma, as the comma is too widely used to be efficient as a delimiter.
You could use the pipe |...
April 14, 2011 at 12:16 am
Why are you creating the temp table #EFUNDSFI, as you don't use it afterwards?
Why are you using the temp table #test? You are inserting all those records into a temp...
April 14, 2011 at 12:12 am
MyDoggieJessie (4/13/2011)
So forigiving my ignorance here...how would I implement it?
I've got a File data flow source connected directly to my SQL Server Data Flow...
April 13, 2011 at 11:39 pm
CirquedeSQLeil (4/13/2011)
Craig Farrell (4/13/2011)
Steve Jones - SSC Editor (4/13/2011)
April 13, 2011 at 11:35 pm
Viewing 15 posts - 9,586 through 9,600 (of 11,678 total)