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...

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...

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...

...

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...

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...

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...

SET @bcpCommand = @bcpCommand + @FileAndPath + '" -b 1000000 -w -T '

EXEC master..xp_cmdshell @bcpCommand

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...

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...

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...

Hi Crispin,

I found it when you use the & SQL uses this one for integer and the && is the logival and.

Thanx

Sjaak

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.

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

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...