| Author |
Topic |
|
Yalini2212
Starting Member
12 Posts |
 Posted - 2010-11-19 : 10:14:53
|
| Hi, I have developed SSIS package using visual studio integration services. Now i have package.dtsx file,which i can execute manually. but i need to execute from asp.net(web page)- when user clicks a button. But i dont have sql server agent installed on my machine. i want to execute it without deploying it to sql server. How can i do it through program? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 10:17:14
|
| You can run it via dtexec.exe.But I think that needs a sql server licence to install for some reason.Why did MS not make SSIS a separate product?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Yalini2212
Starting Member
12 Posts |
Posted - 2010-11-19 : 10:26:03
|
| Thanks....i know Sql. the problem is i don have sql server agent or ssis server in my machine. its urgent.so, i want to run it through program.when i used dtexec from dos, it showed "unable to connect SSIS".. Is there any other way? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 10:32:19
|
| Nope.Do you mean you want the package to run on a web client? If so no hope.If on the IIS server then you will need to either install SSIS (and licence it) so that you can call dtexec on that server or send the request to a sql server and access the path to the package and to any other connections it needs.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Yalini2212
Starting Member
12 Posts |
Posted - 2010-11-19 : 10:59:26
|
| I have both SSIS and SQL server 2005 on my machine. But i dont have sql server agent. what is Dtexec.exe? i know only dtsexec command. where can i get it.SSIS is very easy to develop. Problem comes when we deploy it. actually now can i manually execute it.. automating that is a problem |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 11:03:00
|
| dtexec.exe is the ssis run time.When you schedule an ssis package to run you are actually creating a scheduled job which will execute a dtexec command.Have a look in bol.You can schedule it to run from the windows scheduler if you have ssis installed on your machine.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Yalini2212
Starting Member
12 Posts |
Posted - 2010-11-20 : 03:13:51
|
| Thank you. I think this will work |
|
|
|
Yalini2212
Starting Member
12 Posts |
Posted - 2010-11-22 : 03:00:31
|
| When i execute my package(Package.dtsx) using DTEXEC i am getting this error."SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "DataFlowTask1".I am not getting this error when i execute in Debug mode in SSIS.I am using standard edition only. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-22 : 05:54:02
|
| Which server version did you install.When you look at the services on your m/c do you have an ssis service (and is it started?)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
SSIS deployment