I think you may have an issue with your environment wherever you are creating the packages. There is no particular size limitation on packages. I regularly have developed packages around...

It's not best practice to have null values in any data mart/data warehouse.

You should provide a default time value during the ETL process in place of the null e.g. for...

The SSIS Datatype Conversion functions DT_DATE, DT_DBDATE, DT_DBTIMESTAMP don't do what people expect them to do and there is a lot of confusion in this area (no thanks in part...

Hi Andy,

In the article it states "The Full result set option returns an ADO.Net dataset object.....".

According to BOL :

"If the task uses a native connection manager, including the ADO, OLE...

Another option is to use the raw data file.

This acts just like a staging area as with the first suggestion but has the advantage of not requiring creation of a...

I did actually think of using a variable to check if the task ran but I thought it would be a neater solution to just check to see if the...

What data source type is your ODBC connection being made too , Oracle, DB2 ?

Are you using 32-bit or 64-bit servers ?

There is a white paper written called 'SSISConnectivity.doc' which...

Yes, sometimes access to too much info can be dangerous, I've made the same mistake myself. I discovered the caching issue by chance doing some testing. Just to let you...

Brandie,

I'm afraid BOL is wrong 😉

Check this out:

http://blogs.conchango.com/jamiethomson/archive/2008/02/12/SSIS_3A00_-Case_2D00_sensitivity-in-Lookup-component.aspx

If you're finding that 11 million records are taking to long to full cache, why don't you try partial caching.

You may find it actually works quicker depending upon the amount...

As normal I picked this up from a variety of sources : BOL, Internet (Database journal, sqlis.com, SSIS MSDN Forums etc. they are all a good source of info). The...

Why don't you use SQL Server as the config repository with a separate db for each env, each db sitting on each instance.

I agree.

I read the article too after following this post and it states that you CANNOT recover to a point - in - time after doing FULL or DIFFERENTIAL...

When disabling replication it unfortunately does leave some "crud" behind in the system tables.

The info below is from an article I read some time ago and have copied to my...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_replperf_tran4.asp

This should help. I found it very useful. There are a number of configs you can analyse and change depending upon the setup of your system.

I tweaked it with...