Viewing 15 posts - 76 through 90 (of 106 total)
Peter,
This can be handled with a data transformation that includes a dervied column task.
Create a flat file connection manager and set it to skip the first ten rows and set...
November 20, 2007 at 1:17 pm
I have tried changing the value of the Disable property on the task dynamically, but that didn't work.
I did place the task to be skipped in a For Loop Container...
November 12, 2007 at 1:35 pm
Stupid smilies. Those should be a colon : followed by a D
November 5, 2007 at 1:08 pm
I have used a script task to look for specific files on an ftp site. The next task would be an FTP task to actually get the file which is...
November 5, 2007 at 1:06 pm
Steve,
I am not experiencing any issues with my code, it can connect to (local) and (local)\G3. The only difference between your code and mine is the object declaration.
Yours: SQLServer2Class...
September 16, 2006 at 5:31 pm
Steve,
The right click schedule is great start to initially get the package scheduled. But to take advantage of all of DTSRUN's command options, say passing a global variable on the...
September 15, 2006 at 10:03 am
Hi Steve,
Well, EM can deal with this and it uses DMO. Strange. Anyway...
I think your code looks good.
Did you try .\\G3 or theActualServerName\\G3?
How about using the Client Network Utility to create an...
September 15, 2006 at 10:02 am
That it is not available to users or the application.
October 29, 2005 at 6:46 pm
Hmmm. Sorry, I'm stumped.
October 26, 2005 at 8:05 am
Chandrika,
Your connection string should look like this...
strConnect = "Provider=sqloledb;Data Source=MyServerName;"Initial Catalog=MyDatabaseName;Integrated Security=SSPI;"
When using windows authentication. SQL Server does not require a user name and password.
Norman
October 25, 2005 at 2:05 pm
What shows up in the databases Users view in EM?
Name filled in, but Login Name blank?
If so the sid in sysusers does not match the sid in master..sysxlogins.
Fix this by...
October 25, 2005 at 1:56 pm
The answer to your question is probably yes.
Oh boy 6.5, talk about taxing the memory cells.
I think what you have is a custom written stored procedure that loops through all...
October 25, 2005 at 1:49 pm
You have the same situation, but I forgot to mention one thing. It makes the set up very easy if the local database can be taken off-line while the backup...
October 24, 2005 at 2:58 pm
Correct. Active/Passive apply SP once.
October 24, 2005 at 8:25 am
Viewing 15 posts - 76 through 90 (of 106 total)