Archive

Posts Tagged ‘biztalk’

Useful links related to SSIS

October 12, 2011 1 comment

Here are some random topics related to SSIS, but might be useful sometimes.

The below link explains how to implement

batch processing in ssis

http://www.mssqltips.com/sqlservertip/1504/how-to-implement-batch-processing-in-sql-server-integration-services-ssis/

Scheduling the SSIS Package as a Job

http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/

OLE DB Connection in SSIS Package does not remember password

It might happen sometimes during password change.  Logging off or  Shutting down the machine might work.

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-dts/8961/OLE-DB-Connection-in-SSIS-Package-does-not-remember-password

“Object reference not set to an instance of an object”

Copying package from some other machine may raise these errors. Creating a new package from scratch might solve the issue.
As discussed in the link below, it is a per user problem.
http://blog-mstechnology.blogspot.com/2009/11/object-reference-not-set-to-instance-of.html

biztalk vs ssis

http://enggtech.wordpress.com/2010/04/21/biztalk-vs-ssis-options/
SSIS