Ken Lee-263418 (5/26/2010)

---

Ken Lee says You can easily ferret using "EXEC sp_depends 'tablename'" or see more detail about the first queries with

"select name, case when loc<51 then substring(text,1,150) else ...

Ken Lee-263418 (5/25/2010)

---

First, I hope your "DateTime range" is in the form of two bigint variables. (Don't get me started on the people who put functions that produce constants in...

I have a table in a database with hundreds of millions of rows. The records are quite small (30 bytes) with a clustered index on TagID (Int) and SampleDateTime (BigInt)....

Thanks Jamie,

I will check this out next week (it is well amd truely Fiday night here in  Oz).

Dick Campbell

Thanks,

The afore-mentioned redist.txt basically stated that the DTS files could be freely distibuted (I think in association with an original SQL Server License). I am yet to find smilar information...

Thanks Jamie,

With DTS we were given a list of files and told which ones to register(in Redist.txt) . It sounds like this has been tidied up a lot. Are there any...

Thanks,

I will try it tomorrow (it is Wednesday night here).

Dick campbell

Thanks Jamie,

I will put in the request.

Dick Campbell

http://www.citect.com

Thanks,

Programmers have been looking into it today. They were initially skeptical but are beginning to think that it will work. Apparently you can't do it on SQL Express, it be...

It had occured to me that the expression builder should be available for this property and I did think of building it somewhere else as you suggest.

It would be REALLY...

Thanks Grant,

I got to something similar late last night.

"C:\\My Folder\\MyFile" + (DT_STR,50,1252)GetDate() + ".xls" worked although  it doesn't produce a legal file name. I finally figured that "\\" was the...

To partly answer my own question Help seems to suggest that Cast is more C# like than TSQL.

"MyFile_" + (DT_STR)GetDate()

I couldn't get it to work though.

I had already tried the...

Thanks Jamie,

This is a dimension of SSIS that I haven't explored yet and I am certainly influenced by DTS baggage. All that I really want is to be able to...

Thanks Jamie,

Does turning "Evaluate Expression" on mean that other variables can be evaluated within the variable that contains the SQL text? If that is the case I would be happy to...

Thanks Paul,

I have concluded that I should use the scripting approach. I won't need to drop Replication on the new server but I think that you are saying that I...