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 2005 Forums
 SSIS and Import/Export (2005)
 To use SSIS package,,,,,

Author  Topic 

aksana
Starting Member

13 Posts

Posted - 2008-07-22 : 22:06:23
hi,
Ive been asking about importing excel data to DB through SSIS.
After making a package which is importing excel data to DB,
how do I excecute it??

I found this link and it says "Packages can be run in Business Intelligence Development Studio".
http://msdn.microsoft.com/en-us/library/ms141708.aspx

does this mean I have to have Business Intelligence Development Studio??
so far I have Visual Studio 2005.
I thought packages which are made by SSIS are excecutable from VB.NET . Im confuing,,,,

Could someone please help me???

thank you.
aksana

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-22 : 22:57:33
You can run it as sql job, or run it in dos with dtexec.exe.
Go to Top of Page

aksana
Starting Member

13 Posts

Posted - 2008-07-22 : 23:52:37
is it possible to use a package in vb.net web application project??
Go to Top of Page
   

- Advertisement -