Viewing 15 posts - 9,706 through 9,720 (of 9,728 total)
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
I have to be kind of vague because I haven't done this before. However, a coworker has and this is what I've been told.
Create your ForEach Container with all the...
October 18, 2006 at 6:35 am
You have to jump through hoops to grant non-sysadmin users access to launch SSIS on your SQL Servers, and it requires granting them access via the Windows OS and certain...
October 18, 2006 at 6:28 am
What changed between when you ran the package 20 minutes ago and when you got that error?
October 18, 2006 at 6:24 am
RunTime support for DTS packages must be installed on SQL 2k5 in order to use them. Here are a couple of links from Microsoft's site on the subject:
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
http://msdn2.microsoft.com/en-us/library/ms137907.aspx
Let...
October 18, 2006 at 6:23 am
I'm curious. When you say you found it rather hard in SQL Server 2000, what exactly were you doing?
The Replace() function exists in SQL Server 2000 as well as...
October 18, 2006 at 6:19 am
I think the first question to be asked is, why are you considering SSIS for this task? The second question is, what do you want to use the destination for?
If...
October 18, 2006 at 6:17 am
Here's a link to a post I made on Tek-Tips about this issue. It regards switching .ini files to the Global Variables in SSIS. I hope it helps. If not,...
October 18, 2006 at 6:01 am
Viewing 15 posts - 9,706 through 9,720 (of 9,728 total)