Right, I've seen it. But the example takes the same column name for source (multiple data) and puts them into the unique destination column (as my case).
But I've source columns with different names (they're identified by an ID such as "P2002", "P2003", P2005" that is...
I need to import multiple data into a db, but I cannot do it without operating by multiple transformation tasks. I want to do it (if it is possible) with a single transformation. Here's the situation of the source data:
Year Code A B C
1995 100 1 2 3
1996 200...
Great!
It works on my local machine, so I've only to upload it to the server.
Thank you very much for the tip, I was going mad to solve this...
Thank you again,
Riccardo
Hello to everyone.
I've a Windows 2000 server with a SQL Server 2000 and IIS web server all in english.
I've stored some data in decimal format and I read them via ASP to visualize them on a web page.
The problem is that I want to see those numbers with the european notation for the separators...
You're right, but I've already tried formatNumber(variable,2,,,-2) and formatCurrency(varible,2,,,-2).
In both cases (with the regional settings setted up in the right manner, so with a point to separate digits and comma for the decimals) it didn't work in the right way.
In the first case I see...
Hello to everyone.
I've a Windows 2000 server with a SQL Server 2000 and IIS web server all in english.
I've stored some data in decimal format and I read them via ASP to visualize them on a web page.
The problem is that I want to see those numbers with the european notation for the separators...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.