Viewing 15 posts - 5,671 through 5,685 (of 59,068 total)
Does the path you listed ( "C:\Users\AS\source\repos\Airport\DataImport\Location.csv") live on your SSIS box or on a different machine?
February 4, 2021 at 11:40 pm
Although it's been deprecated, it's still available. Try sp_Lock.
February 4, 2021 at 11:27 pm
Good article and thank you for taking the time to write and publish it.
As a bit of a sidebar, though, I just go to "Source Control" and grab...
February 4, 2021 at 4:18 pm
Do it. Try it. Get used to it.
Now that's a keeper. You've just described the outcome of most software I've ever seen but it's missing a very important point......
February 4, 2021 at 1:48 pm
Thanks all for your help with this one. Reading through all your suggestions it looks like using a tally is what'll work for us. The dataset is only about...
February 4, 2021 at 12:10 am
Hopefully, some of the others on this site that are more into the arts and sciences of Data Analysis and Data Science and Business Intelligence will see this post and...
February 3, 2021 at 9:09 pm
HaHa, thanks Jeff for the great discussion. Now if I can figure out which groups to join... Dont know of any SQL Saturdays coming up... Where do I go...
February 3, 2021 at 9:06 pm
Jeff: Right on! You describe my situation well!
Ratbak brought up SSIS. Another beef. Wasnt the ultimate for SSIS that the business user could add their business rules in the...
February 3, 2021 at 8:52 pm
I do use MDX. I have to. They wont switch the SQL Server to listen to SQL!!
I have the books. It is _very_ difficult to write an MDX query...
February 3, 2021 at 8:33 pm
Yeah... totally agreed with that, as well, Patrick. Heh... I was trying to avoid a far bit of outrage on my part about applying such labels and so replied in...
February 3, 2021 at 6:54 pm
Assuming "dates" could only be a number between 1 and 31...
DECLARE @UnitMembership TABLE
(
...
February 3, 2021 at 5:44 pm
Gosh... I think I've gone brain dead a bit. I've tried a couple of things and can't just now remember how to do this with either an inline Tally cte...
February 3, 2021 at 5:18 pm
I would think this would be the most straightforward way, although it may not be the most efficient way. But it might work just fine for you...
February 3, 2021 at 4:10 pm
This will solve the data as you have provided it.
However, what happens when you have multiple overlapping units?
Man, you were really close and it was starting to look like...
February 3, 2021 at 4:11 am
I would think this would be the most straightforward way, although it may not be the most efficient way. But it might work just fine for you if your...
February 3, 2021 at 1:03 am
Viewing 15 posts - 5,671 through 5,685 (of 59,068 total)