|
|
|
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 How can We check the Relational check Posted by Krishna at 5/31/2005 11:44:01 PM I have imported the tables from excel to my database which does not have the
FK relationships, Now i need to check the relation check in the imported
database regarding this i have some queries, any help on this is
appreciatable.
1. How can We check the Relational check(Checking child recor...more >>
How do I call the another DTS Package's Task Lookup in a DTS Packa Posted by Krishna at 5/31/2005 10:14:02 PM I have one DTS Package say Package1 where i have most of the Lookups in one
Transform Data Task. I would like to call these Package1->Transform Data Task
->Lookups in another dts packages say Package2 in Activx Script instead of
writing lookups again.
Any help appreciatable.
...more >>
Appending to an existing text file destination Posted by karenmiddleol NO[at]SPAM yahoo.com at 5/31/2005 8:24:14 PM I want to keep appending to an existing text file destination output
file everytime I run a DTS Package.
Unfortunately DTS keeps ovwerwriting what is in the file.
How do I append into a text file destination.
Thanks
Karen
...more >>
Urgent help with DTS Posted by Chris at 5/31/2005 6:29:10 PM Hi,
I created a DTS package that creates an excel file and send via email. What
I notice was everytime I run the package, instead of overwriting the file, it
appand the new results to the file so I created an active x script task to
delete the file after it is being emaild but next time I run...more >>
retrieve info from sysdtspackagelog for the currently running pack Posted by LP at 5/31/2005 4:34:07 PM Hello All,
I'm auditing my ETL processes and I want to get the following info about the
currently running dts package from sysdtspackagelog.
select [name], [description], [id], [versionid], [lineagefull], [starttime]
from sysdtspackagelog
Anyone else need this info during execution?
...more >>
Copying database Posted by vibs at 5/31/2005 4:20:51 PM While copying database I am getting object not found errors. I looked up the
two tables that were cause of the error and they were missing from the
tables, so I deleted all references to them in the database diagram, views
and stored procedure. But still DTS continues to give the same error. A...more >>
Can a DTS Package receive mail and access Attached Files? Posted by Snake at 5/31/2005 4:09:14 PM I have a requirement for a DTS package to read mail from Exchange and process
any file attachments. We receive data files from various vendors this way
which today must be manually saved to a directory and their DTS load packages
manually started, which is slow and error-prone.
Any comment...more >>
2 Destinations, 1 source, through a loop Posted by Drew at 5/31/2005 11:36:18 AM I have added another Destination to my DTS package (it is a different table
in the same database). Now the DTS package isn't working as expected.
It now loops through the query, picks up the ExcelLink and executes the 1st
transform, then loops back, when the loop is finished, then it execute...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Stask Input Parameter Error Posted by Jinx1966 at 5/31/2005 3:07:11 AM I have an issue where I cannot use input parameters in an Execute SQL task. I
can write any query which will hold values or other variables eg @LogRecID =
23 or @LogRecID = @AnotherVariable, and when I hit the parse button the
syntax is fine. Indeed I can cut and paste it into query analyser a...more >>
How to change DestinationObjectName of DTSDatapump Task Posted by J-T at 5/30/2005 12:18:31 PM I'm using a Dynamic property to change my pump Task connection based on a
global variable.The global variable specifies which database I'd like to use
my DTS in.DestinationObjectName is something like
[DatabaseName].[dbo].[TableName]. I don;t know how to change this portion
only([DatabaseNam...more >>
Syntax error or access violation Posted by J-T at 5/30/2005 11:44:35 AM I have been given the Administrator Role (in our server).In our server there
are two databases.I'm in Public role for both databses .My DTS package works
in one database in other database it gives me this error :
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft OLE DB Pro...more >>
Restoring DTS on another server Posted by JLLDBA at 5/30/2005 7:50:10 AM After I restore a msdb database from a server to another, I like to modify my
DTS
with my user MYUSER :
- I can create a new DTS,
- I can open and save a DTS with another name,
But
- I can't open and save a DTS with his original name
I don't like to change my user rights and adding this...more >>
Build Query From Data Transformation Task: Update from a Join? Posted by David Grant at 5/29/2005 2:29:52 PM Hi to everybody!
On using the Build Query option from the Data Transformation task, I' ve
realized that the update query only allows updating a field with a scalar
value.
However I'm trying to use the Data Transformation Task for these kind of
queries:
UPDATE TableToUpdate
SET C_FI...more >>
copying Transform Data Task Posted by supertiti at 5/29/2005 11:19:13 AM I'm creating a package to import a set of
5 very large text tables, they all have the same
structure (515 fileds). I would like to
do it all in one single package running parallel
tasks.
However, I'm force to map, source and destination
fields, for each of them !!!
Does anybody knows of ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |