I got rid of my count and conditional split in my data tasks and just used the execute sql task in the control flow to manage the conditional split where...

Am I missing something? How do you set expressions with precedence within a Data Flow Task?

This is part of a larger ETL process that has many Data Flow tasks....

"You'll probably find that SSIS won't start afterwards this is to do with the managed code trying to check certificates on the internet there are ways around this "

Can you...

You can also try this, which I posted in the scripts section back in 2003!

http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=804

Can you explian further?  If the star schema is in SQL Server tables you should have no problems.  If you are talking about trying to connect to a cube though,...

Hi David,

I don't know anything about Shadow Copy, but I would recommend you use a native SQL Server backup or something that is supported like SQL LiteSpeed. 

I've had people...

You need to be clear on what you're trying to achieve and then decide on the best way to achieve it.  I'm unsure if you're trying to perform load balancing...

It's hard to say without knowing more about your particular situation.  Is this for Disaster Recovery, Load Balancing, OLTP or OLAP systems, how many servers do you have available and...

Can you please explain further?  What do you want to know about your stored procedure?

Not sure if I completely understand what you want to do, but if you want to copy a portion of data from databaseA to databaseB then you could use DTS...

Hi Goce,

In this scenario it must been done at the database level because it is part of a larger processing requirement. The result set returned has to be further...

You can check auto close by running sp_helpdb from Query Analyser or by looking at the properties of the database from Enterprise Manager.

Are you sure there is nothing in the...

Have you thought about adding an index to the MonthYr column?

I can see a lot of table scans happening on [LoanDataMart] you definately need to address that.

Just posting...

Have you updated your statistics before you run this? I have seen bizarre execution plans when stats aren't up to date.

Have you updated your statistics before you run this? I have seen bizarre execution plans when stats aren't up to date.