Viewing 15 posts - 1 through 15 (of 15 total)
I found the problem allready. The problem is that a parameter inside visual studio = ''
i am checking in my stored procedure for this value.
The thing is that it's a...
:hehe:
March 2, 2010 at 1:22 am
hi andrewd.smith well finally it is working yes. I understand that the nodes are not neaded. Only the element names in the nodes and that the path to the element...
:hehe:
February 19, 2009 at 11:09 pm
i would say that you schred or do a decomposition wich means you put them both in a database or in a database variable. Update whatever you wanna update and...
:hehe:
February 19, 2009 at 3:34 pm
I found the answer:
DECLARE @XMLString XML
declare @strName as varchar(50)
declare @tiete as varchar(50)
SET @XMLString = (select xmldata from dbo.Stg_XmlFile where id = 43)
set @strName = (select tab.col.value('name[1]','VARCHAR(20)')AS name from @XMLString.nodes('//learning_method') tab(col))
print...
:hehe:
February 8, 2009 at 6:44 am
Well thanx anyway folks i fixed it myself again. Using the elementenumerator. set the outerxpath query on the deepest level. The innerpath query on the current level. In script you...
:hehe:
January 10, 2009 at 1:01 am
Thanx everybody i made up the soluton myself. It's quite simple actually. The packages are in xml format. So i made a for ech nodelist enumarator and go trhru all...
:hehe:
November 5, 2008 at 12:46 am
SET @bcpCommand = @bcpCommand + @FileAndPath + '" -b 1000000 -w -T '
EXEC master..xp_cmdshell @bcpCommand
:hehe:
September 18, 2008 at 7:10 am
The osql utility is not something Microsoft is going to keep in later versions. So try to use the bcp utility. Further more when using the bcp you have to...
:hehe:
September 18, 2008 at 7:06 am
You are not sure what the end goal is. Well i tell you
Actually it is very simple. I am building a fact table from several dimensions. Say about 10...
:hehe:
September 5, 2008 at 2:57 am
You mean building the complete SQL statement in a variable and then use this as the source?
It is a big sql statement how long is the string type that is...
:hehe:
September 5, 2008 at 1:38 am
Hi Crispin,
I found it when you use the & SQL uses this one for integer and the && is the logival and.
Thanx
Sjaak
:hehe:
August 19, 2008 at 4:50 am
Hi there,
I am using SQL2005. The customer wants it to be in T-SQL. So the SSIS was not an option. Thanx for the reply.
:hehe:
August 18, 2008 at 3:30 am
It's amazing. I tried adding the two '' it and it is not giving me the error message again. Thanx very much. You are th best.
Thanx
Sjaak
:hehe:
June 22, 2008 at 12:46 am
Mayby you have to check the security checking of your SSIS package. Put it on don'tsavesensisitive. But don't forget to put all the connections to databases on what was that...
:hehe:
June 21, 2008 at 1:24 am
Viewing 15 posts - 1 through 15 (of 15 total)