Viewing 15 posts - 931 through 945 (of 3,666 total)
venkat113 (8/31/2014)
Hi Alvin,I have one requirement for process 835 files and loaded into database, Can you share your experience.
Thanks,
It's doable in SSIS, but it's a lot of work and I...
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 16, 2014 at 3:37 pm
Is this person named Paul, by any chance? 😀
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 16, 2014 at 2:58 pm
Koen Verbeeck (10/16/2014)
Only allow the execution of stored procedures?Even if there is a way to enforce a WHERE clause, you can still always write WHERE 1 = 1.
... OR ......
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 16, 2014 at 8:38 am
Of course it is possible and very simple for anyone that knows anything about SQL queries.
You can extract the data by execution a SELECT statement against each table with...
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 13, 2014 at 3:11 pm
Ooops. Looks like you were faster than me Phil. 😀
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 13, 2014 at 11:38 am
Sounds like the tab name in each file are is the same. Is that correct?
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 13, 2014 at 11:36 am
I guess it depends on what kind of formatting you are talking about.
All data should be pulled from SQL using a query. If the formatting can easily be done...
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 13, 2014 at 9:40 am
susmitha117 (7/15/2014)
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 10, 2014 at 1:16 pm
sqldriver (10/10/2014)
Koen Verbeeck (10/10/2014)
sqldriver (10/10/2014)
And yes, they refuse to implement a default constraint of 0 to make their lives easier. Because less code is... bad? Something?
Constraints are evil! Because of...
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 10, 2014 at 8:07 am
Jeff Moden (9/29/2014)
Koen Verbeeck (9/29/2014)
Hire an overpriced consultant. Chances are they'll listen to him/her...BWAAAA-HAAA!!! BECOME and overpriced consultant! 😉
Careful not to become an unemployed overprice consultant! :w00t:
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]
September 29, 2014 at 3:02 pm
I Googled "ssis using parameters for connection manager" and got several good results.
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]
September 29, 2014 at 2:34 pm
I would not try to migrate/upgrade DTS packages.
SSIS offers new ways to do things, so I would rebuild each package from scratch. With each package, I would look for...
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]
September 29, 2014 at 1:48 pm
Have you tried Google?
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]
September 29, 2014 at 12:40 pm
Luis Cazares (9/29/2014)
Revoke create and alter permissions and create policies to apply changes to the database. People will start to do things right when they're enforced.
That only works in management...
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]
September 29, 2014 at 11:58 am
SQLRNNR (9/29/2014)
Koen Verbeeck (9/29/2014)
SQLRNNR (9/26/2014)
Koen Verbeeck (9/26/2014)
Apparently PASS passwords (sorry for the alliteration) were compromised[/url].Change your passwords if you haven't already...
ARRRGGGGHHH
Hopefully you didn't change them right away, because there was...
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]
September 29, 2014 at 8:08 am
Viewing 15 posts - 931 through 945 (of 3,666 total)