yes, please let me know. Are you using the ACE 12.0 provider? or the ACE 14.0?

If it's ACE 14.0, can you still load 2007 files? ...

Thank you for your reply. I actually am running it in 32 bit mode -- I had that issue a short while ago when we moved to a 64-bit...

LOVE IT!!! THANKS, THAT S0LVED MY SSIS ISSUE!!!

hey, that worked, thanks! it's better than the way I had solved the issue, which was by selecting the results of the dynamic sql into a permanent table, and...

AAAAHHHHHH, I figured it out -- the solution turned out to be somewhat simple. I just changed the data in the table from "WHERE ' + @FieldName + '...

Thank you for reformatting -- I didn't know how to do that!

Yes, that is what i need. We are using ssis to load the data, but I don't necessarily...

I'll clarify: the gist of what I need is this:

I'm building the sql string from text, variables, and variables and text retrieved in a field in a...

thank you!!!

glad I could help!

You might not be able to drop the filegroup because something still remains on it. Here are a couple of queries copied from other locations on the internet that...

what is the error you are getting?

OK, figured out where the Primary filegroup belongs on a Range Right partitioning function, and why...

here is the new code, for anyone trying to do this:

CREATE PARTITION FUNCTION dispense_date_pfn(date)

AS

RANGE...

wait a minute -- having similar issue on the other side of the range. Maybe Primary needed to be in the first partition... checking that out now...

FYI, for anyone interested, I did get it to work. I had to deviate from the way that Kimberly Tripp had said to do it, but at least it...

thanks for your interest. See my notes down below where it blows up...

ALTER DATABASE edw ADD FILEGROUP [201001]

ALTER DATABASE edw ADD FILEGROUP [201002]

ALTER DATABASE edw ADD FILEGROUP [201003]

ALTER DATABASE...