The exception file logging does not recognise the duplicate keys or referential integrity errors , so it does not create the .source and .dest exception files in this case

Here...

this might help you

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=172020#bm172233

Regards

Meghana

The following URL gives u an example on how to do this

http://www.sqldts.com/default.aspx?214

Thanks

Meghana

Please put an alias to your tables and then it should work fine.

Something like this

Declare @Table_1 Table (Member varchar(20), Age int)

Declare @Table_2 Table (Member varchar(20), Score int)

Insert into...

Can you give more info on when you are getting this error.

also please check your DTC if it is running.

Regards

Meghana  

I am not sure if we can update the timestamp field in a table. Since the timestamp field itself keeps track of changes (whether inserts or updates) made on the...

Try setting ConnectionTimeOut = 0 for the database connection

You can do this using the disconnected edit .

1.Expand  Connections

2. You can see the DB connections your package has

3. on...

I have another way to solve this.

select CustomerID, Orderdate

from orders A where A.Orderdate in

(select Top 2 B.orderdate from orders B where A.customerId = B.customerId)

order by CustomerID, OrderDate desc

Which...

If it is a shared dimension then you can process the dimension  and browse data . where as if it is a private dimension , it gets processed when your...

If you do not have time to go thru BOL . this is how you can do it

create view streetfile

AS

select cast(street.streetcode as varchar(2)) + '|' + streetname + '|' +...

Hi

you can try setting the nocheck constraint on the tables and then load the data.  The following statement would ignore the RI Constraints and  check constraints. 

For Eg:

ALTER TABLE...

A initialization file can be used where the server names can be specified , production server or Dev server.

A .ini file is very helpful while moving the packages across...