Viewing 15 posts - 721 through 735 (of 887 total)
Unfortunately I don't have the environments available to test this further, but here are a few suggestions to eliminate the error. All of these would require some work on your...
November 18, 2011 at 7:14 am
Jeff Moden (11/17/2011)
kevin_nikolai (11/17/2011)
Hi Komal,Martins method: DWH.dbo.Split_Values(@Store_Code_List,',') should be used in stored proc's where clause (not in from clause).
Sorry, but no. Martin's method uses a WHILE loop and an...
November 18, 2011 at 6:47 am
That symbol looks like a carriage return to me...and it would make sense that SSIS inserts that at the end of the line.
November 18, 2011 at 6:42 am
David Data (11/17/2011)
Thanks Martin - but having looked there, I can't see any changes that affect how SSIS deals with the NUL device.
We'll need more information to help you then....
November 17, 2011 at 3:51 pm
quillis131 (11/17/2011)
Martin Schoombee (11/17/2011)
Do you know the ascii code for it?Not sure about the ascil code, Looking forward to get Rightward arrow (?)
If you find out what the ascii code...
November 17, 2011 at 11:56 am
Are you talking about the SCD component in SSIS? Why don't you give it a try...create a test package and see if it is possible to delete records. Or read...
November 17, 2011 at 10:57 am
Do you know the ascii code for it?
November 17, 2011 at 10:53 am
battery_acid_h (11/17/2011)
Anyone experienced this:, no data shows up on my report...
I created a query from an SSAS cube, the data displays in the query. I added the fields to my...
November 17, 2011 at 10:50 am
Just a quick observation:
The "GROUP BY" and "HAVING" clauses should only be used when you have aggregate functions in your query. Not too sure why you have both in query...
November 17, 2011 at 10:42 am
Not too sure, but for a list of bug fixes in SP3 you can have a look here: http://support.microsoft.com/kb/2546945
November 17, 2011 at 10:32 am
You could try something similar to the following:
create function [dbo].[Split_Values]
(
@String varchar(4000)
,@Delimiter varchar(1)
)
returns @Split_Values table(String_Value varchar(200))
as
begin
insert into @Split_Values
(
String_Value
)
(
selectsubstring
(
@Delimiter + @String + @Delimiter
,N + 1
,charindex(@Delimiter,@Delimiter + @String...
November 16, 2011 at 12:16 pm
Without more information about the package I am purely guessing here...but I suspect you are not setting the username and/or password for this connection properly.
Are you using a config file...
November 16, 2011 at 12:04 pm
Martin Schoombee (11/16/2011)
Have you tried to create a data-driven subscription? That will allow you to specify a query to...
November 16, 2011 at 10:02 am
Just one more thing as I'm reviewing your initial posts again.
Have you tried to create a data-driven subscription? That will allow you to specify a query to return the...
November 16, 2011 at 9:02 am
SQL_Nw (11/16/2011)
Do you mean I need to make changes in stored proc? I cant do that.How can I do it in ssrs only. Any leads please..
No. Create a new...
November 16, 2011 at 8:45 am
Viewing 15 posts - 721 through 735 (of 887 total)