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...
October 16, 2014 at 3:37 pm
Is this person named Paul, by any chance? 😀
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 ......
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...
October 13, 2014 at 3:11 pm
Ooops. Looks like you were faster than me Phil. 😀
October 13, 2014 at 11:38 am
Sounds like the tab name in each file are is the same. Is that correct?
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...
October 13, 2014 at 9:40 am
susmitha117 (7/15/2014)
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...
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:
September 29, 2014 at 3:02 pm
I Googled "ssis using parameters for connection manager" and got several good results.
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...
September 29, 2014 at 1:48 pm
Have you tried Google?
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...
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...
September 29, 2014 at 8:08 am
Viewing 15 posts - 931 through 945 (of 3,666 total)