hi friends,
i created the one package for import the data from excel to server 2005
in intellegence services i add the package after deploy
if we run the package (by giving the connection working fine)
BUT I WANT TO RUN THE PACKAGE BY DAILY AUTOMATICALLY(just like a scheduler)
is it possible if possible please give me the coding for auto run a packages
regards
koti
Hi ya,
You would need to deploy it first to file system or Ms Sql Server and then place it as a job in sql server agent. Schedule that job to run daily.
Hope that helps
Cheers
Rizwan
No comments:
Post a Comment