Viewing 15 posts - 9,691 through 9,705 (of 9,720 total)
Individual database collations can be "changed" when they are created, but the System DBs get their settings from the server itself. So, if you want to change TempDB, you'll have...
October 27, 2006 at 6:17 am
Simpler way to do this? No. SSIS is capable of doing so much more than DTS that the this task has become a bit more complicated rather than being streamlined.
However,...
October 25, 2006 at 1:04 pm
Glad I could help. @=) And my apologies for the initial mis-direction.
October 25, 2006 at 12:08 pm
You are correct. I mis-spoke.
Try this: Pull over a Data Flow Task. Double-click it or Click the Data Flow Tab and arrow down to the Data Flow Task if it's...
October 25, 2006 at 10:58 am
Are you just doing a data transfer? No triggers, etc. If so, maybe what you need to do is resort to an Execute SQL Task and stick a SELECT statement...
October 25, 2006 at 10:37 am
Is this field truly a plain vanilla Identity column? Does the destination table have two different columns, one pulling the Ident from the source and the other its own Ident...
October 25, 2006 at 9:01 am
Look up the keywords "exporting packages" in Books Online for all the various methods of moving SSIS packages. The wizard can be found by Right-clicking the package in question. It's...
October 25, 2006 at 8:37 am
You need Identity Insert set to ON.
The best way to do this is to insert two Execute SQL Tasks, one before the import and one after the import. The first...
October 25, 2006 at 8:29 am
If you look under Tools -> Options in SSMS, you'll see an item called Source Control. If you set it to Visual SourceSafe, you can create (inside SSMS) projects that...
October 25, 2006 at 7:25 am
Thanks for the info, Casper. I'm still learning this stuff myself, so every bit of info is incredibly helpful.
Glad you got yours working.
October 19, 2006 at 4:15 am
Okay, I see your point. I just tested it in 2k5 and got the same result when using a real Create Table / Update Table statement. Which doesn't make sense...
October 18, 2006 at 12:34 pm
You have to have a solution open before you can find it. Then look in Solution Explorer, you'll see the project name and 3 folders underneath it. Data Sources, Data...
October 18, 2006 at 8:28 am
You're welcome and I'm glad you could get it to work.
October 18, 2006 at 7:40 am
Well, at least you got it fixed. @=)
October 18, 2006 at 6:40 am
The way I've gotten around being able to set the root folder is this.
I create a Global Package variable and set a default value of whichever folder I want. Then...
October 18, 2006 at 6:39 am
Viewing 15 posts - 9,691 through 9,705 (of 9,720 total)