without usage of sql agent we can scheduke the package?????????????

whats the diff b/w aggregate transformation and aggregate function in sql server? and wich one is better and why?

not sql server Is there any other tool for scheduling the ssis package?

Schedule the ssis package through user domain name is it possible? how it possible?

what the function of scope in the variable???????

you can write an application in .NET for run the package, and use Timer in the application to schedule it as you want.http://www.rad.pasfu.com

Krishna This is not the way to post in a forum. One thread should have one query not multiple questions in the same thread. How would some one answer your one query. You can schedule ur package by using Windows scheduler instead of SQL server but to execute the pacakge you need to have SSIS services on the server. Plus on windows scheduler you will not have the advantage of logging facility and details of the history of the job execution. Schedule the ssis package through user domain name is it possible? how it possible? Make use of proxy account to schedule your package. what the function of scope in the variable??????? It has the same use as compared to defining the scope of a variable in anoy other programming language, like you donot wish to change the value of the variable apart from a few places you set the scope of the variable accordingly. Check google to foe variable scope. Tweet me..

Thank u Sudeep raj ur answers more useful to me

whats the diff b/w aggregate transformation and aggregate function in sql server? and wich one is better and why? Aggregate transformation is an asynchronous component and it will effect the package performance because of its blocking nature. It is always good to aggregate the data in the source query itself (if possible).Nitesh Rai- Please mark the post as answered if it answers your question

whats the diff b/w aggregate transformation and aggregate function in sql server? and wich one is better and why?

whats the diff b/w aggregate transformation and aggregate function in sql server? and wich one is better and why? Krishna, Please stop asking different questions on the same thread. Start a new thread for a new query. Tweet me..

SSIS After deployment of package After the deployment of ssis package in filesystem or in sql server.........how the clients can extract the package?

After the deployment of ssis package in filesystem or in sql server.........how the clients can extract the package? Connect to the Integration Services from SSMS on the server where the package is deployed and rt click the package to select the "Export Package" option.Nitesh Rai- Please mark the post as answered if it answers your question

how to delete the duplicates after the scheduled the package?

How to delete the duplicates from the tables in the ssis?