Viewing 15 posts - 3,121 through 3,135 (of 11,678 total)
What is the source? What is the destination?
May 12, 2014 at 4:27 am
It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.
Normally SSIS does this for you, so I...
May 12, 2014 at 4:11 am
thomashohner (5/11/2014)
I am a member of the local SQL PASS, however I haven't gone to a meeting yet because I was nervous about being to ignorant.
Don't be nervous. Just...
May 12, 2014 at 2:32 am
For the test data you provided, the last line is not necessary. I added it as an extra check.
Say for example project 1425 has a third line with demo_code DE2,...
May 9, 2014 at 4:33 am
That would be a left input join. (similar to a left outer join in TSQL)
You'll have to check for NULL values and use a conditional split.
May 7, 2014 at 7:24 am
Did you use the Verbose logging level in the SSIS catalog?
What if you set DelayValidation to true in the package?
May 7, 2014 at 6:42 am
skaggs.andrew (5/7/2014)
Thanks for the information. I will test these options. Just out of curiosity, why do you say not to use the SORT transformation in SSIS?
It is a...
May 7, 2014 at 6:38 am
SELECT *
FROM MyTable WHERE prj_code IN
(
SELECT prj_code
FROM MyTable
WHERE demo_code = 'DE1' and demo_vchar_data = 'U'
INTERSECT
SELECT prj_code
FROM MyTable
WHERE demo_code = 'RAP' and demo_vchar_data = 'YES'
)
AND demo_code IN ('DE1','RAP') AND demo_vchar_data IN...
May 7, 2014 at 6:18 am
Ashif Shaikh (5/7/2014)
does the SQL developer edition supports clustering??
It supports every feature of enterprise edition. (with the very minimal exception of only 1 client for the distributed replay controller)
May 7, 2014 at 5:23 am
Since it is a test server, can't you use developer edition? Then you can keep your system databases.
May 7, 2014 at 4:39 am
Try using the Oracle OLE DB provider. The Microsoft OLE DB provider for Oracle is 32-bit only and is deprecated.
May 7, 2014 at 1:34 am
Eirikur Eiriksson (5/7/2014)
You are missing the increment of the counter, the code never hits it, improved code below😎
BEGIN and END, your best friends in TSQL 🙂
May 7, 2014 at 1:04 am
Viewing 15 posts - 3,121 through 3,135 (of 11,678 total)