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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 dynamic text in a word file

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2014-12-02 : 04:42:43
hi,

i am looking example of update name in a word file in ssis
like in this link, you can see example of c# (but i do not know c#)
[url]http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8b47dd36-38dd-4b83-b99e-fec75c3f73ee/writing-to-word-doc-from-sql-server?forum=sqlintegrationservices[/url]
thanks

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-02 : 08:59:16
Confused. You have an example in your link. What are you looking for exactly? (Note that C# is not that hard to read and it is worth learning for your career in any case)
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2014-12-02 : 13:15:56
hi,

i try this link,

first i didn't sucess to load the refrence (even i follow by steps)
Microsoft.Office.Interop.Word

then i found solutiob by load the file from :
c:\Windows\assembly\GAC_MSIL\office\14.0.0.0__71e9bce111e9429c\OFFICE.DLL

but then i got error
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2014-12-02 : 14:16:05
when i try to add microsoft.office.core i get this error:
Warning 1 Task failed because "AxImp.exe" was not found, or the correct Microsoft Windows SDK is not installed. The task is looking for "AxImp.exe" in the "bin" subdirectory beneath the location specified in the InstallationFolder value of the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SDKs\Windows\v7.0A. You may be able to solve the problem by doing one of the following: 1) Install the Microsoft Windows SDK. 2) Install Visual Studio 2010. 3) Manually set the above registry key to the correct location. 4) Pass the correct location into the "ToolPath" parameter of the task. ST_6c79f8dce8624d659d9187aa723932ac
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-02 : 14:17:08
what error did you get? Note that it's easier to help out if you post everything about the problem from the get-go.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2014-12-02 : 14:59:13
when i add the reference i have the yellow sign on reference,
in the error window :

Warning 1 Task failed because "AxImp.exe" was not found, or the correct Microsoft Windows SDK is not installed. The task is looking for "AxImp.exe" in the "bin" subdirectory beneath the location specified in the InstallationFolder value of the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SDKs\Windows\v7.0A. You may be able to solve the problem by doing one of the following: 1) Install the Microsoft Windows SDK. 2) Install Visual Studio 2010. 3) Manually set the above registry key to the correct location. 4) Pass the correct location into the "ToolPath" parameter of the task. ST_6c79f8dce8624d659d9187aa723932ac
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-02 : 15:08:36
There's either something wrong with your references or you don't have the SDK installed.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2014-12-02 : 15:11:24
where i found the sdk?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-02 : 15:20:35
Google is your friend!

https://www.google.ca/search?q=microsoft+windows+sdk&oq=microsoft+windows+sdk&aqs=chrome..69i57j0l3.4259j0j1&sourceid=chrome&ie=UTF-8&safe=active&ssui=on

Really, you should do that before asking here.
Go to Top of Page
   

- Advertisement -