Viewing 15 posts - 31 through 45 (of 66 total)
Each row is the same?
Try the DISTINCT statement with the GROUP BY clause. Also change the WHERE clause into a HAVING clause:
SELECT DISTINCT u2.EMPLOYID, u1.TRXBEGDT, u1.TRXENDDT
FROM ...
February 16, 2006 at 2:17 pm
Change your source query to:
select * from schema.table where id_column > ?;
Now click on the Parameters button. Wait for the Parameter Mapping dialog. Make sure you are on the...
February 16, 2006 at 1:32 pm
You can log errors to a text file if you set up the Logging tab on the transform task. Don't forget to bump up the maximum errors.
February 16, 2006 at 6:56 am
Steve is right. Using URL access, you can only change the datasource credentials. Use the web service at http://localhost/reportserver/reportservice.asmx
Check out the RS BOL for the topic:
Walkthrough –...
February 16, 2006 at 6:50 am
Great! I'm glad that you worked it out.
February 15, 2006 at 12:53 pm
I know what it is...
Change this line:
If (DTSGlobalVariables("foundANSIFiles").Value = True) Then
To this line:
If (DTSGlobalVariables("foundANSIFiles").Value = -1) Then
February 15, 2006 at 12:31 pm
I can't see this happening in SQL. I assume you don't want a bunch of unwanted tables in SQL.
If I had to deal with this same issue, I would...
February 15, 2006 at 11:32 am
I think step #1 for you should be to create a destination table with the same column names minus the primary keys, nulls allowed, and no other constraints.
Then...
February 15, 2006 at 11:25 am
Try the following:
DROP table [JC12$]
GO
CREATE TABLE [JC12$]
(
'VendorNum' VarChar (25)
'Ins' VarChar (25)
'Type' VarChar (25)
'Date' VarChar (25)
)
GO
February 14, 2006 at 2:24 pm
I like to think of it being the OOP way of doing DTS. Where the objects are the disabled tasks and you are using the main ActiveX task to...
February 14, 2006 at 8:44 am
Here's what you might want to do:
Right-Click on Task1(ActiveX). Select Workflow->Workflow Properties. When that pops up, Select the Options tab. Check the "Use ActiveX script option". ...
February 14, 2006 at 8:40 am
Correct. When you have two workflows going to the same task, Both workflows have to process before the connected task is performed. It is a logical AND operation.
February 14, 2006 at 8:30 am
You are welcome. Try using \\[servername]\[foldersharename]\[filename].xls for your output file.
February 14, 2006 at 8:27 am
I've used an ActiveX task to handle the entire workflow before. I would set up a DTS in normal workflow fashion, then disable the workflow steps after the ActiveX...
February 14, 2006 at 8:16 am
Viewing 15 posts - 31 through 45 (of 66 total)