Viewing 15 posts - 3,691 through 3,705 (of 11,678 total)
You should look for settings inside the package itself. Technically it didn't fail:
The package execution returned DTSER_SUCCESS
February 11, 2014 at 7:29 am
kapil_kk (2/11/2014)
Koen Verbeeck (2/11/2014)
kapil_kk (2/11/2014)
Koen Verbeeck (2/11/2014)
The primary key is already unique, so adding extra columns doesn't make it more...
February 11, 2014 at 6:53 am
GilaMonster (2/11/2014)
Koen Verbeeck (2/11/2014)
Adding extra columns to the clustered index has consequences. Maybe this affects other queries who don't use those columns.
And adding extra columns to the primary key can...
February 11, 2014 at 6:00 am
kapil_kk (2/11/2014)
Koen Verbeeck (2/11/2014)
The primary key is already unique, so adding extra columns doesn't make it more unique.
It seems you...
February 11, 2014 at 4:14 am
You are getting performance issues because the PK is an identity?
The primary key is already unique, so adding extra columns doesn't make it more unique.
It seems you are just missing...
February 11, 2014 at 3:42 am
kapil_kk (2/11/2014)
Koen Verbeeck (2/11/2014)
How can a single column be a composite key?
There is anthor columns also...
there is an Identity column which is currently defined as PK so I want to...
February 11, 2014 at 3:21 am
David.Poole (2/11/2014)
Koen Verbeeck (2/11/2014)
What exactly is wrong with the Excel Destination in SSIS?
Nothing. This article is demonstrating a proof of concept using a library without having to install Excel...
February 11, 2014 at 2:10 am
paul s-306273 (2/11/2014)
ashwani24 (2/10/2014)
February 11, 2014 at 1:39 am
Don't these statement work? Do you get an error or is the resulting data incorrect?
February 11, 2014 at 1:34 am
What do you have so far?
(your tables also seem to be Oracle tables, right?)
February 11, 2014 at 12:59 am
The code is easier than you might think:
I would store the result in an SSIS variable and populate a column in the data flow using a derived column and...
February 11, 2014 at 12:41 am
Yes. You can use sp_add_job, sp_add_jobstep and sp_start_job.
To get an idea of how to use this, right-click on an existing job and script the CREATE statement.
February 11, 2014 at 12:37 am
ashwani24 (2/10/2014)
February 11, 2014 at 12:34 am
Nice one question.
I was sincerely in doubt, but since it wasn't raining I chose the correct answer.
February 11, 2014 at 12:29 am
Viewing 15 posts - 3,691 through 3,705 (of 11,678 total)