Viewing 15 posts - 6,631 through 6,645 (of 11,678 total)
Ha, I selected the "correct" answer so I could easily get some points (5, woohoo :w00t:) and get some recognition on this forum!
Although I would debate that the "judging skills"...
July 27, 2012 at 5:28 am
222.rajkumar (7/26/2012)
error code: dts_e_cannotacquireconnectionfromconnectionmanagerI kept the "Protection Level" as EncryptSensitivewithUserKey", will it make any problem.
If so, can you tell me what is the level i have to change.
It would be...
July 27, 2012 at 12:17 am
Jeff Moden (7/24/2012)
Koen Verbeeck (7/24/2012)
Jeff Moden (7/23/2012)
July 24, 2012 at 2:55 pm
Not use SSIS?
SSIS and SQL Server in general can only run on Windows OS.
July 24, 2012 at 5:30 am
SSIS itself can only run on Windows, so you need to take that into account.
July 24, 2012 at 5:17 am
A good book to start with:
SQL Server 2012 Query Performance Tuning
Look around on the web. There are tons of articles, blogs and books written on SQL Server performance.
July 24, 2012 at 5:14 am
How about adding a WHERE somewhere?
July 24, 2012 at 4:41 am
Try this:
INSERT INTO [dbo].[tblContactInf]([spaceId],[contactId],[datas])
SELECT
SpaceId
,ContactId
,sq.datas
FROM
(
SELECT
s.SpaceId
,contacttype= 'phone' + CONVERT(CHAR(1),ds.IndexNumber)
,datas= ds.DataText
FROM
tblAdSpace s
INNER JOIN
[dbMemberdetail].[dbo].[tblMemberDatadetail] a
ON a.CreatedOn = s.CreatedOn
CROSS APPLY
dbo.Split1(a.PhoneNumbers,',') ds
) sq
INNER JOIN
dbo.ContactType ct
ON ct.datas = sq.contacttype;
July 24, 2012 at 3:13 am
This might be a little too complex for a conditional split.
However, you can create a script component as a conditional split and use regular expressions to find out if the...
July 24, 2012 at 1:51 am
Ah OK. To make your Excel Destination dynamic, you need to put an expression on the connectionstring property of the Excel connection manager.
Not 100% sure, but I think the Excel...
July 24, 2012 at 1:34 am
No, what I mean is: how do you know if a datafield is a telephone number and not an e-mail?
July 24, 2012 at 1:31 am
Jeff Moden (7/23/2012)
Thanks for the response, Jason. Do you have any good examples of where SSIS might outshine T-SQL? Please don't say "anything that needs xp_CmdShell". 😉
How would...
July 24, 2012 at 1:27 am
Viewing 15 posts - 6,631 through 6,645 (of 11,678 total)