I have created the following;
OLEDB Connection to the database
variable --> user::GetName (string type)
Exec SQL Task --> Select Top 1...
I am trying to execute DTS through SQL Server 2005 Job which fails.
The following is the error:
Step Error Source: Microsoft Data...
You can profile it to see duration, Reads, writes and CPU. Also when you run query plans, check each components rowcounts and cost. You can decide...
Separate names with a comma.