October 14, 2010 at 11:02 am
You can use any system that can run a Windows executable, like the Windows scheduled tasks.
If you schedule a job through SQL Agent, you'll see the command line in the job step that you can run through any job scheduler like RoboCopy, Windows Scheduled Tasks, etc.
October 14, 2010 at 9:23 pm
without usage of sql agent we can scheduke the package?????????????
October 15, 2010 at 12:05 am
krishna.msbi2008 (10/14/2010)
without usage of sql agent we can scheduke the package?????????????
Something tells me you are not really willing to coorporate.
(or you can't read English)
Steve Jones already provided you with a satisfactory answer. If it is not enough, use google with the keywords "Windows scheduled tasks."
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2010 at 10:45 am
hiiiiiiiii frds..........
October 17, 2010 at 10:47 am
plz rly to my queries frds................
plz rly to tis query......
whats the diff b/w aggregate transformation and aggregate function in sql server?
and wich one is better and why?
i am not get any answer in google for query plz provide answer plz......
October 17, 2010 at 11:22 am
krishna.msbi2008 (10/17/2010)
plz rly to my queries frds................plz rly to tis query......
whats the diff b/w aggregate transformation and aggregate function in sql server?
and wich one is better and why?
i am not get any answer in google for query plz provide answer plz......
I'll help you with all your answers even those that 'google didn't provide you', if you answer the following correctly...if not I shall personally ask all the members not to help a man who cannot help himself.
1. What is a data warehouse?
2. What is a surrogate key and state all types of SCD transformations?
3. What are the phases involved while designing a datawarehouse?
4. What is meant by data staging?
5. What is meant by SSIS in relation to data warehouse?
6. How many times do you actually try before posting your questions on the forum?
7. What methodology, if any, would you prefer while designing a DW? Is it a Kimball approach?
8. On a scale of 1 to 10 how much would you rate yourself on SQL concepts?
9. What are the different types of dimensions in a DW?
10. What are facts, fact table, factless fact table
There are many more question's i can ask you...Self help is the best a man can do.Remember, even if you are able to answer all of them, which i'm pretty sure you won't do not consider yourself as a DW wizard and state it in your fake experience profile.
Raunak J
October 22, 2010 at 11:32 am
hiiii frds..
After deploy the package in filesystem.
how the client can extract the package
October 22, 2010 at 11:41 am
krishna.msbi2008 (10/22/2010)
hiiii frds..After deploy the package in filesystem.
how the client can extract the package
What do you mean by: "extract the package"?
I can't help but wonder what the client that hired you is paying you for if we're answering all these questions for you?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 11:56 am
Alvin Ramard (10/22/2010)
krishna.msbi2008 (10/22/2010)
hiiii frds..After deploy the package in filesystem.
how the client can extract the package
What do you mean by: "extract the package"?
I can't help but wonder what the client that hired you is paying you for if we're answering all these questions for you?
We should ask for a consultant fee 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 22, 2010 at 12:02 pm
da-zero (10/22/2010)
Alvin Ramard (10/22/2010)
krishna.msbi2008 (10/22/2010)
hiiii frds..After deploy the package in filesystem.
how the client can extract the package
What do you mean by: "extract the package"?
I can't help but wonder what the client that hired you is paying you for if we're answering all these questions for you?
We should ask for a consultant fee 😀
My preference would be the client's email address. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 1:19 pm
we are extract the data from client servers and after clearness of data we are loading the data into warehouse.
how the client can access the data??
October 22, 2010 at 1:22 pm
krishna.msbi2008 (10/22/2010)
we are extract the data from client servers and after clearness of data we are loading the data into warehouse.how the client can access the data??
You obviously have no idea what you're doing. I'm not answering your questions unless you're prepared to pay for the answers.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2010 at 1:30 pm
If i have idea than i can answer the questions .......
i have no idea thats y i am asking the douts
October 22, 2010 at 3:31 pm
Can't... resist...
after the deployment of ssis package in filesystem.
we run the package in filesystem in ssms.
commonly run the package in dtexeutility.
after we are providing the roles to the client.
how the client can access the package and also how administrator also access the package.
The same way you run the package in filesystem already.
today i attend the interview i faced some questions in transaction?
Wow, I've never known an interviewer to rollback a question, but I guess it's possible. Possible DBCC Timewarp application?
can any one explain the real time experience in ssis
Start package. Wait for error or success. Stare at screen until completed.
Roles means "AS a Administrator we r provide the permissions to the client".
Yep, one of the things an administrator usually does, though that's a pretty big client to be allowed those roles. Dedicated server, perhaps?
A small query " A Bank Project is there, In that we have to maintain the customer details and financial services" through ssis kkkkkkk.
Yay, good for you! What bank? I want to pull my money out of it.
for this project my company made a team of 4 members.
can explain the work for that 4 members?
Well, Huey usually makes a mess, Louie usually tries to cover it up, and Duey goes out and gets the baseball team together in the meanwhile. Donald's at work at the time.
I have attend one interview i made 2+ fake experience in ssis....
In that interview, interviewer asked wats ur work in ur project?
But i am not areal time employee....then i am not answer for that question i was rejected.......
Well, good, at least one of you had ethics, since obviously you didn't.
I have no friends who are in real time ............
Photo albums for the win, I guess?
I need the wats going in ssis project?
Which one? I'm working on 9 at the moment. I don't know a single thing YET about yours from the above...
I estabilished a company as a free lancer in .net....
I worked for 2years as a free lancer......
Now i need a job
Dot Net... SSIS... Dot Net... SSIS... Nope, don't even sound close. What the heck does one have to do with the other? I'm sorry you need work, but you're in the wrong field trying to go directly from .Net to SSIS. You might want to apply under the 'Junior Developer who needs training from the ground up' positions.
free lancer experience is not consider for the company jobs then i wat i do?
Free Lancer just means you work for yourself. It's got nothing to do with what you can do for the company. They're paying you to make them money, not because they care.
I have many references .....
but i am interest to get a job through reference......
kkkkk
I have absolutely no idea what THAT means other then it sounds like an evil giggle at the end.
kkkkkkkkkkkkk
That's... the entire post. Um... you feeling alright?
In ssis package we are creating the variable in the scope of the package..... kkkkkkkkk
then
what the function of scope in the variable???????
First, buy a new keyboard. your k and ? keys are stuck.
First part, sure... second part... the variable doesn't have an internal scope. The variable is IN a scope. And there's no functions in either from what you described.
difference between Aggregate function in sqlserver and aggregate transformation in dataflow task?
which one is better? and why?
HOLY MOSES! A QUESTION! A lousy one, but an actual question! Well, first, do you know what the aggregate function in SQL Server does? Now, have you looked in BOL about the aggregate transformation? If so, have you looked at the results of putting the same data into both? You will then answer your own question.
not sql server
Is there any other tool for scheduling the ssis package?
Hey, another question! Only took 20 posts! Answer: Yes. Many many tools. Google is your friend.
Schedule the ssis package through user domain name is it possible? how it possible?
User domain names don't automate/schedule anything. They will let you login to things that do, though.
without usage of sql agent we can scheduke the package?????????????
Still with the peanut butter in the keyboard. and it's schedule. That sticky k's back too. Answer: Yes. See above.
hiiiiiiiii frds..........
Hiiiiii voweless man. Yet another pointless post.
plz rly to my queries frds................
plz rly to tis query......
whats the diff b/w aggregate transformation and aggregate function in sql server?
and wich one is better and why?
i am not get any answer in google for query plz provide answer plz......
rly... relay? Rely? I have no idea. But look above in this mess to see my answer. Google is not your only resource here. Try books online, and try actually doing the work and seeing the results. You will answer your own question.
hiiii frds..
After deploy the package in filesystem.
how the client can extract the package
Hopefully they can't, or they don't need you anymore and stop paying you. Or perhaps they just copy the file from the filesystem?
we are extract the data from client servers and after clearness of data we are loading the data into warehouse.
how the client can access the data??
You worked in .NET. You build an interface. It shows the client the data. By preference over the internet, printouts are painful in bulk.
If i have idea than i can answer the questions .......
i have no idea thats y i am asking the douts
See, the problem here is beyond that you have no idea. It's that you're trying to use educated professionals to answer EVERY interview question before you, instead of actually going out and learning it, and all the underlying concepts that build it, on your own. You're trying to fake two years of experience leveraging Alvin's, Phil's, and other's long term, heavily invested time in doing their jobs. For Free. With lies.
You fail. We already know you have no idea. They're telling you you're not getting any help until you go find one on your own, at least SOME basics. There's hundreds of free introduction to MS SQL courses on the web. Go do some. Then go do some SSIS ones. THEN come back here, with intelligent, specific questions that you can articulate the issue in regards to.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 22, 2010 at 10:06 pm
I have taken a course from some institute ...
in that institute they explain only the basic and asked some question they not answer to me..........
thats y i preferred the forums to get the answers........
anything thanks for ur valuable time made to me and for ur answers.......
Viewing 15 posts - 31 through 45 (of 47 total)
You must be logged in to reply to this topic. Login to reply