jpSQLDude (5/19/2011)

---

Ninja's_RGR'us (5/19/2011)

---

That shows a basic lack a comprehension in logs. Wether you take 100 log backups in 24 hours or only 1 the total size will be exactly...

Setting up dynamic columns in SSIS (or any ETL tool) is not really that easy as it's not what SSIS was designed for.

It can be done but usually involves...

why don't you run the t-log backups 24 hours a day?

I'm glad you got this sorted, thanks for posting the solution

It really depends...

what you could do is write a query to extract the data from excel rather than connecting to the worksheet directly,

if you write a a select * ...

if you need a setup screen to show up then it would probably be easiest to create the deployment app in .net,

Otherwise you could have the username and password as...

I have also seen some very long validation times (up to 30mins) on Progress databases, especially if it has to go across the network.

did you get that information from the Advanced property tab?

Where is it set to DT_TEXT ?

In the data source, in all the transformations, in the data destination?

Have a look in the data flow to see where the truncation is occuring, its possible that you are using the DT_STR data type which can only handle 8000 chars,...

you should have a look at the script that was linked earlier, this will...

in the market right now - Qlikview is nice but expensive.

in the market very soon(?)... SQL Server Denali BI tools, project Cresent !!

jstariha (4/26/2011)

---

Ok, that seems right. I was just told that the reason our organization does not use reporting services is because exchange server, which we do not have, is a...

you will need smtp server to send the emails