Viewing 15 posts - 11,011 through 11,025 (of 11,678 total)
DhruvShah (10/19/2010)
I would have thought that Ans is true because we can specify color in connection properties
Well, if you read the editor's comments at the question and this thread, you'll...
October 19, 2010 at 1:25 am
Hi.
You can do this in SSIS by using 3 OLE DB Source components and then merge them together with a UNION ALL component. The address type can be determined with...
October 18, 2010 at 8:11 am
Very nice question, definately learned something today.
Got it wrong, because the BOL page about CREATE SCHEMA didn't mention anything about batches.
Ah well...
October 18, 2010 at 2:20 am
The question itself is good, it poins to a not so well known feature in SSMS.
But the answers, boy, does that suck. Pure trickery...
It is like: "Hahaha, you knew you...
October 15, 2010 at 5:56 am
Good question, but I've seen more difficult ones for two points.
October 15, 2010 at 5:37 am
Phil Parkin (10/15/2010)
da-zero (10/15/2010)
--Beware that you are limiting the table to have only 1000 records.
10,000, I think you'll find sir 🙂
:doze: I blame Friday. And the people who placed two...
October 15, 2010 at 5:26 am
I think the best practice here is to create an ID column which is a real IDENTITY column to serve as a primary key with no meaning. Then add your...
October 15, 2010 at 4:44 am
Just a long shot, but you didn't accidentely map one of your input columns with the [PK_LiveItemInstanceID] column?
October 15, 2010 at 1:31 am
krishna.msbi2008 (10/14/2010)
without usage of sql agent we can scheduke the package?????????????
Something tells me you are not really willing to coorporate.
(or you can't read English)
Steve Jones already provided you with a...
October 15, 2010 at 12:05 am
You cannot disable transformations in the data flow.
You can however disable tasks in the control flow.
October 14, 2010 at 5:48 am
1. I already answered your question: use a derived column with the expression I gave you. Of course, adapt the expression to your situation.
2. Also use a derived column for...
October 14, 2010 at 1:21 am
saurabh.deshpande (10/12/2010)
Path="\Package.Connections[EDW_STAGING].Properties[ConnectionString]"ValueType="String"><ConfiguredValue>Data Source=TESTDB1;User ID=TEST;Initial Catalog=STAGING;Provider=SQLNCLI.1;Auto
Translate=False;</ConfiguredValue></Configuration><Configuration ConfiguredType="Property"
Is this string I need to change? (Provider from SQLCLI.1 to SQLCLI.10)
I believe so. Try it out and let us know how...
October 12, 2010 at 10:52 am
SamaReddy (10/12/2010)
i have a package in ssis
that is how to change system.int32 datatype to system.int64
which transformation i need apply
now i am using oledb source,dataconversion,derived column,slowly changing dimension in my...
October 12, 2010 at 8:10 am
I think a simple SELECT COUNT(1) FROM [Source Table] will be faster than a whole data flow that reads everything into memory to just count the rows. But it is...
October 12, 2010 at 8:02 am
Viewing 15 posts - 11,011 through 11,025 (of 11,678 total)