Yeah when I talked to my supervisor, he said that the views use other tables from other servers so that is what was going on...I didnt know that (new to...

Thank you Ninja...You did spread a lil light on it for me...However I still dont have my head around it yet...I will just have to do some more studying up...

I apologize I am still confused...So the Space Available is based on the Data and Log Files correct? And you are saying I need to change what I currently have?...

Thanks Ninja...So can you change that after you have already created the database? This is all done on a development server and yes there is going to be a whole...

Just some other tidbit information concerning this database...I have the Data file set to Autogrowth By 1 MB , unrestricted growth and Log file set to Autogrowth By 10 percent,...

I got it...Thanks however instead of LTRIM I just used TRIM...

Here is what I have as my package:

In Data Flow:

Step 1 - Flat File Source (text file - all column types are string) Also checked the box to retain null...

opc.three (5/27/2011)

---

Here's where I would start:

1) Import it as a string from the text file.

2) Use the Derived Column transformation to change columns with blanks to NULL.

3) Use the Data...

Thank you...

Will try that when I return to work...

Phil Parkin (5/26/2011)

---

It...

I see what you are saying but right now I dont have Redgate on my PC and plus Im not worried about the schema...The schema's are pretty much the same...

I have done that however, he doesnt want to copy over the sp's and other objects, he just wants the data...also our backups are only on tape...

Thank you for the quick response...

It it like 9 flat files that will get loaded into their respective table...But the thing is these files are supposedly huge like over a...

Thanks for all the replies guys...

And to the guy who said it is scary if a dba asks this - i am just trying to get different opinions as to...

Ok we got past that problem...We ran into this problem...We created publication and was setting up a push subscription...After going thru the wizard, we got the following message...

Subscriptions were created...