I think we should go with SB because SQL jobs to schedule tasks is the resource consumption due to the inefficienct SQL cache utilization of SQL Server Agent and SB...

if you put OR in place of AND (Col1 <> 'X' or Col2<> '-99'), you will get same result from both the Sql

create table #temp (id int,col1 varchar(30),col2 varchar(30))

insert into...

Can you try this..

DECLARE @Xml TABLE ( XmlData XML );

INSERT INTO @Xml

( XmlData

)

...

I don't think you can add primary key on the column which has duplicates values already

Good question and awesome answer by experts.. we should not use between operator in string comparision.. if we then should know the limitation that it will not consider last...

I don't think without modifying the package you could run it successfully.

Source connection: - Which you are passing from config that you supplied at run time.. it is working fine

Destination...

i would suggest to use date dimension as a confirmed dimension with 2 fact tables. Create a dateid key in inventory fact table and use date dimension as confirmed dimension(shared...

For enhancing the cube processing performance you should think these points

1.Did you create partition in your cube

2.Did your dimension optimize? like identifying attribute relationship,using user hierarchy effectively

3.Did your aggregations optimize

So it's clear.. it has not problem with your config because source connection is working fine.

Open the package and just do the test connection on destination connection manager with your...

1.You can use sql task where you use minus operator and extract new records in table..

Export this new table data into xls and send email as an attachment.

2.if you want...

Refer below article if it could help

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62678/

There are multiple ways to implement this

1.First is record count check ?

2.We can implement some bechmarking check between target and staging table like record count %difference between target and stagging...

or if any other process is running which doing operation on same objects which data you are trying to move to different server

It could because of database object discrepancies like table schema is different.

If the column is varchar and it has all numeric values than it can be converted to Integer by using data conversion but if it has single non numeric value...