WhiteLotus (4/30/2015)

---

Hmm let me think about it 🙂

Btw do you know how to reduce data file ? I know how to reduce trans log file ( by doing Backup trans...

WhiteLotus (4/30/2015)

---

Thanks for the reply 🙂

Actually What I am worried is about someone created new database someday without my knowledge and he doesnt understand about recovery model ... Thats will...

WhiteLotus (4/29/2015)

---

2.Hmm Do you mean everytime I create a new database it will automatically set to SIMPLE Recovery ? IF so then I think better just backup trans log because...

And of course...

treyagrimes (4/29/2015)

---

Thanks to both replies.

I'm not sure what a CDC is?

The Oracle table does have a mod_date so that might be the column to key off of. Could you...

$10,000? That's a bargain 😀

Ah, I see.

You are currently checking if the string "select...

1. There is no need to shrink them. If your transaction logs are full, take transaction log backups.

(and how big can the transaction log for the model database be?)

To quote...

Can you give a bit more explanation on what exactly you want to accomplish?

Btw, you...

No idea. Are you sure there are no rows hidden somewhere or on another page?

Right now, how your code is structured, there won't be an email sent if (@mSql2 IS NULL ). So what else do you want to accomplish?

No idea about the corrupted rows.

Don't know if it's possible. Maybe you can check out bpc.

First result from google for sqlbulkcopy class:

SqlBulkCopy Class

This script task sets the value of the variable str_ArchiveFileName to something like \\servername\d$\ftp\Test\Archive\Journal - 2015-04-29.csv

What do you want to do exactly?

tfendt (4/28/2015)

---

I am running in to an issue with the Excel Source in SSIS.

I am using the new 2012 Integration Services Catalog with Project deployment. I can run the package...