Viewing 14 posts - 9,706 through 9,720 (of 9,720 total)
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
Ron,
I have a silly question, so forgive me if it sounds strange, but have you tried to use the OLEDB for SQL Server instead? It should work for SQL 2000...
October 18, 2006 at 5:57 am
The best way to accomplish your task is to use Dynamic SQL. You'll have to create a variable to store your SQL Statement and your variable in and then execute...
October 18, 2006 at 5:53 am
The only way I know of to get the name of the SQL Server hosting Sharepoint is to find the Sharepoint administrator and ask him/her for the SQL Server name,...
October 18, 2006 at 5:46 am
October 11, 2006 at 6:42 am
Litespeed has been most effective for my team. Recently, however, we used Beyond Compare 2 when upgrading our server hardware. It came in handy to make sure all our new...
October 6, 2006 at 1:07 pm
Am I correct in reading that you're checking for a file name which is always consistent?
I'm beginning to think my issue has to do with the wildcard character. It doesn't...
August 14, 2006 at 7:28 am
That was the first thing I checked. I have \\MyServerName\Sharename\path\ in my gsFilePath variable. That's why I put in the MsgBox stuff, so I could verify the path &...
August 14, 2006 at 5:17 am
Viewing 14 posts - 9,706 through 9,720 (of 9,720 total)