Viewing 15 posts - 406 through 420 (of 451 total)
I had a coworker at a previous job who used a command line utility (can't remember which one) and piped (he used Cygwin -- *nix like command line shell for...
August 21, 2012 at 9:08 pm
I would guess that this is a <CR><LF> vs. <LF> end of line delimiter issue. Windows typically uses <CR><LF> (ASCII(10) & ASCII(13)) while Unix typically uses just <LF>.
In your...
August 21, 2012 at 7:15 am
Yes, the CREATE VIEW statement is fully qualified. The BI Admins group does not have permissions to the dbo schema.
CREATE VIEW [Reporting].[vwSalesOrderDetail]
AS
...
August 20, 2012 at 9:15 am
Do you have separate Excel Destinations for each sheet or are you using variables and an expression for the separate sheets?
August 20, 2012 at 9:11 am
Yes; linked servers are supported in SSIS. Can you manually get the SELECT to work between the servers in SSMS? If so, then we can proceed from there....
August 11, 2012 at 9:13 pm
Are you able to manually do the select between servers with the fully qualified path?
But I agree with the above poster, why mess with linked servers, just create your source...
August 10, 2012 at 4:58 pm
If you just want to exclude the HistoryAction 'SC' records, you can do something like:
SELECT FlightNbr, DeptDateTime, Origin, Destination, FirstName, CustomerId, SeatRow, HistoryAction
WHERE HistoryAction <> 'SC'
ORDER BY FlightNbr
It sounds like...
August 8, 2012 at 1:43 pm
komal145 (8/3/2012)
CID :
150569-Missing
120567-HEALTH
R60318-Missing
5403-HEALTH
40475-HEALTH
003182173-health
need to get only the numeric value ( that is digits before '-')
example '150569-Missing' need only 150569
cannot...
August 3, 2012 at 10:59 am
For me 'Remote BLOB Storage' was the first thing that popped up when I Bing'd RBS and SQL Server. But that's the extent of my knowledge on Sharepoint administration.
August 3, 2012 at 8:22 am
You can add a data conversion task to change the data type from nvarchar to varchar. That is from WStr to Str (in SSIS data conversion task).
HTH,
Rob
July 27, 2012 at 2:40 pm
It looks like you're trying to put the NewVal varchar(max) variable into a nvarchar(10) field, hence the warning message. Just cast the results to be nvarchar(10).
Why is a SSN...
July 24, 2012 at 3:02 pm
Facts are usually numeric, additive and have a value. So on first blush, I'd say you have a FactApplication that has a count and ApplicationAmount and probably a FactLoan...
June 19, 2012 at 8:51 am
I don't know if you have a status table, but that's what I'm suggesting you check in your SSIS data flow. Are the log files .txt or .csv? ...
June 13, 2012 at 1:27 pm
hemanth T (6/13/2012)
its like 'abcd@' --original column data.'abcd' --------derived or required data
What are you trying to do? Remove all '@' symbols? Remove the last character? Remove...
June 13, 2012 at 1:19 pm
What do you need help on?
It looks like you need to lnik your Priority and Status tables to your Projects and Tasks tables, but what is your question?
June 13, 2012 at 1:09 pm
Viewing 15 posts - 406 through 420 (of 451 total)