Viewing 15 posts - 2,896 through 2,910 (of 5,111 total)
Use a Derived Column transformation in your Data Flow before your Destination Node.
P.s. Your sentence is a a bit conflicting; "prefix MO at end of the Data". A...
October 11, 2017 at 9:57 am
jcourtjr 29296 - Wednesday, October 11, 2017 9:20 AMI know, but the users are lets say, technologically challenged...
Then your "best" option is...
October 11, 2017 at 9:36 am
October 11, 2017 at 9:07 am
October 11, 2017 at 8:56 am
October 11, 2017 at 5:52 am
October 11, 2017 at 5:14 am
There should be a Pivot. For example, have a look at the following:USE Sandbox;
GO
CREATE TABLE #Sample (Title varchar(50), ContactType varchar(50), LogDate int);
GO
INSERT INTO...
October 11, 2017 at 4:56 am
sram24_mca - Wednesday, October 11, 2017 3:25 AMBoth the systems are in WORKGOUP domain..!
Are you using a domain called WORKGROUP, or do...
October 11, 2017 at 3:56 am
What about if a name has Order A, B And C. Are you expecting 3 columns, or are the only options A and B? Could it go all the way...
October 11, 2017 at 3:11 am
The error message is giving you the answer here, access is not authorised.
As tThe Computer is outside of the domain and it more than likely does not have...
October 11, 2017 at 3:08 am
October 11, 2017 at 1:42 am
Because there is no column logdate. You are Pivoting on the column logdate (i.e. transforming it from a column to values in a single row). You can't pivot on a...
October 10, 2017 at 4:57 pm
October 10, 2017 at 11:45 am
October 10, 2017 at 10:14 am
Viewing 15 posts - 2,896 through 2,910 (of 5,111 total)