|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 MEDIA PLAYER Posted by KANDICE at 7/30/2004 12:16:18 PM every time i try to play windows media player a notice
comes up stating that GetIUMS CANNOT BE FOUND IN
MSDART.DLL.of the dynamic link library.also whenever i
try to download media player 9 series it always times
out.i'm frustrated!!!!...more >>
permissions to run DTS Posted by kevin at 7/30/2004 9:11:46 AM I am a new comer. I will ask a stupid question.
How can I set the IIS server account, normally
ISUER_MACHINENAME to have access to load
and execute the package?
Thanks...more >>
Catastrophic failure opening pkg in Designer Posted by SocSecTrainWreck NO[at]SPAM earthlink.net at 7/30/2004 8:14:58 AM Another #*%@ DTS bug and a couple of hours of development time down
the toilet:
1. Made significant changes to pkg. Ran successfully for test.
2. Saved package.
3. Tried to open package to run it but got "catastrophic failure"
message before the package was even displayed, and "the select...more >>
Stored procedures in "Execute SQL Task" Posted by Ian Tanner at 7/30/2004 3:35:05 AM Hello,
is there any advantage or disadvantage about using a
stored procedure within an "Execute SQL Task"?
Advantage, could be speed?
Disadvantage,
could be possible that stored procedure will fail and the
task will report a success?
Thank you!!...more >>
Time problem Posted by anonymous NO[at]SPAM discussions.microsoft.com at 7/30/2004 12:24:04 AM How do I get only the time out of getdate()?
/Maria...more >>
Scheduled DTSpackets Posted by Anett at 7/29/2004 11:52:18 PM I have som DTSpackets that are scheduled, and they work
fine. But I discover that I have to be logged on to the
computer for them to execute. I guess that it has someting
to to with that the SQL Server Agent using my windows
account as Service Startup account.
Can I come around that?
/An...more >>
import/export wont include identity/primary key Posted by Reth at 7/29/2004 11:02:59 PM Each time when i import the tables from 1 SQL server to an
other, it wont include the Identity's and Primary key's.
how can i make it so it will?
thx in advance,
Reth...more >>
Running for each parameter Posted by ACFalcon at 7/29/2004 9:35:01 PM I am some what new to DTS and I was wondering if it is possible to have a SQL Task as the first step send various values to a second SQL Task then have a ActiveX object run last. Here is what I am trying to do.
I have a query that gets order numbers needed to be sent in the first SQL Query, it t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need help with DTS Package Maintenance Posted by Joseph Geretz at 7/29/2004 4:55:04 PM I'm using a DTS package to perform database upsizing migrations from
Interbase to SQL Server. The gist of it is I use ODBC to connect to the
source Interbase Database and I make a SQL Server connection to the target
SQL Server database. I then use a set of Transform Data tasks to pump the
data o...more >>
Text import using DTS? Posted by IT Dep at 7/29/2004 4:23:58 PM Hi
I am trying to import some text files into MS SQL 2000. I want to import
them into a table with the first column being the filename (excluding the
extension) and the second colunm being the contents of the textfile, I want
the entire textifle to fit into the one cell (ignoring any commas, ...more >>
Disconnect from Database Posted by Mike at 7/29/2004 1:51:45 PM I have a DTS job which does several transform tasks to bring data from one
database to another. Each of these steps establishes a connection to the
source database, and doesn't disconnect until the entire DTS job has
completed.
This is a problem because it uses licenses on the source database ...more >>
Losing data Posted by David O'Brien at 7/29/2004 10:41:30 AM I have created a simple DTS that copies Excel data into an Access table. It
works fine when I run it on my PC which is running Win2000 and is acting as
the SQL2000 server, while I evaluate it. I then loaded the SQL client
software onto another Win2000 PC and an XP PC. When I run the DTS from the
...more >>
Scheduling DTS packadge Posted by Daniel Berezniak at 7/29/2004 9:22:06 AM Hi,
I've created a DTS package which after opening a
connection uses a "Transform Data Task" to select data
from a table and then creates a .csv file using the "Text
File (Destination)" connection. On success I execute
a "SQL Task" which simply updates a FileIsCreated column
on a table...more >>
DTS, how to fork? Posted by Ian Tanner at 7/29/2004 8:08:41 AM Hello,
I have a DTS with one task, then two legs and after them,
another common task.
I would like to fork to one or other leg according to the
value retrieved in the first task.
Avoiding to use workflow with "success" and "error". And
also, last step need not to wait for both legs to fi...more >>
DTS Passing Null values using Oracle Posted by jase74 NO[at]SPAM hotmail.com at 7/29/2004 1:28:15 AM Hi,
I'm using DTS to transfer data from a flat file into an Oracle
database. The flow is something like this...
Flat file >> transformation >> Oracle Staging table >> transformation
>> Oracle application tables.
During this flow I flag which rows are new and which rows are an
updates. ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |