I should be.

Microsoft Visual Studio version 10.0.40219.1 SP1Rel

I did the SQL 2012 install with SP1 and reinstalled SP1 per many blog posts.

Thanks for the kind words. If I can save someone else time by sharing it's worth it.

I wrote all the calendar tables and the tally table as stored procedures. Makes...

You need to see what's going on here. Add a data flow for On Error output to a harmless transformation (I always used Copy Column) and put data viewers...

Unless management "sees the light" and fully backs you in bringing order into chaos you're going to lose. It works and they haven't had problems they're willing to address.

Try...

I try to avoid absolutes in things (except cursors) so there may be somewhere, some time, a need for the OLE DB Command transformation. It's an available option and...

After reflection I'm going to change my answer to agree with EricEyster.

People aren't going to look in the previously expired record to see why it expired. The current record...

Data type of DATETIME2(3) will get you the 999 in the decimal portion if you need to get to that level of precision.

I'm by no means an expert of any kind on data warehousing so take this as my opinion.

I would put it in the expired record since the change is the...

I've all but given up on the OLE DB Command transformation. I've switched to stage tables and stored procedures. The data flows in the majority of my packages...

Please don't cross post.

Put replies in this post:

http://www.sqlservercentral.com/Forums/Topic1544683-392-1.aspx

I'm a big believer in process and processes. In this case I would highly recommend making a stored procedure to create these logins and do your best to require...

When I'm doing large data transfers I try to find a way to break them up into no more than 30mil per set. I'll have them all in one...

I just created a whole slew of calendar tables so this is something that's going in my briefcase here.

FYL - My calendar tables are wide but still fit on a...

I'm dealing with many years of various ways of bringing in data (there's still a SQL 2k server in use) and a couple of rather unfriendly third party systems that...

I like the change. Many is the time I've found a forum topic that covers the problem I'm having but there's nothing that notes there's a solution provided. ...