Viewing 15 posts - 8,236 through 8,250 (of 11,678 total)
SQL Kiwi (1/31/2012)
SELECT
c.CategoryId,
c.NameCategory,
Top1.NameDetail
FROM dbo.Category AS c
CROSS APPLY
(
SELECT TOP (1) *
...
January 31, 2012 at 2:20 am
Mighty (1/31/2012)
You can indirectly make use of values from other tables, but in order to do so you have make a reference to a UDF.
That is a good way to...
January 31, 2012 at 2:19 am
johnitech.itech (1/31/2012)
To eliminate column title row that you see before the data, use NoHeader option:
http://msdn2.microsoft.com/en-us/library/ms155365.aspx
You can use it with URL access (add &rc:NoHeader=true to report url), or, for RS 2005,...
January 31, 2012 at 2:17 am
Go for package configurations, definately. Data sources are a Visual Studio thing and are not deployed to the server! (at least not in SSIS. It does work for SSAS and...
January 31, 2012 at 1:16 am
Implementing Logging in Packages
How to: Enable Logging in a Package
A log provider specifies the type of log (sql server table, flat file, windows event log, ...) and the connection manager...
January 31, 2012 at 1:12 am
Please do not crosspost. It wastes people's time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1243795-147-1.aspx
January 31, 2012 at 1:10 am
What happens if you change the SuccesValue property of the Execute Process Task to 2 instead of 0?
January 31, 2012 at 1:08 am
It's there, just not where you'd expect it 😀
You need to create an event handler on the task you want to monitor. In the event handler, there is a system...
January 31, 2012 at 1:06 am
You can take "Embedded in Task" quite literaly.
The DTS task is embedded in the task, in other words, it is embedded in the .dtsx file (which is just XML).
If you...
January 31, 2012 at 12:59 am
Regarding the time format: you'll have to add the zero's yourself in the expression. You can do this by converting the number to string and use the following formula:
RIGHT('00' +...
January 31, 2012 at 12:55 am
rajiv.kumarb (1/30/2012)
can u try using ScriptComponent Transformation
That is indeed the way to go.
Creating an Asynchronous Transformation with the Script Component
January 31, 2012 at 12:46 am
There is a problem with your expression. This is an expression for a connection manager, but you put it on the name property, which won't accept the \.
January 31, 2012 at 12:44 am
vardan.hakopian (1/30/2012)
I am trying to create a report and export to CSV file without column headers.When i run the query from SSMS and 'SAVE RESULTS AS..' CSV or text...
January 31, 2012 at 12:06 am
Viewing 15 posts - 8,236 through 8,250 (of 11,678 total)