Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ACCESSProgrammer123
Starting Member
2 Posts |
 Posted - 2011-05-09 : 13:36:46
|
| Hi guys, if I wanted to do some data manipulation in SQL Server, similar to working with data in EXCEL VBA, for example changing a text character in data, what would be the equivalent scripting language within SQL Server? Is there VBA in SQL Server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
ACCESSProgrammer123
Starting Member
2 Posts |
Posted - 2011-05-11 : 13:14:31
|
| Hi guys, could anyone provide me with an example import script in SSIS, just to get a sense of how the scripts work, flow control etc.? For example, say I wanted to import an Excel file and I wanted to assign column 1 to Field ABC in SQL server and change all letters "a" in that field to "x." |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2011-05-12 : 04:22:08
|
| You might find something at http://www.sqlis.com/ though you may be better off using the import wizard and looking at what that produces-----------If debugging is the process of removing software bugs, then programming must be the process of putting them in. |
|
|
|
|
|
|
VBA Equivalent in SQL Server