|
|
|
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 Copying SQL Server Object Tasks Posted by Vaughn Haybittle at 1/14/2007 9:57:06 PM Hi,
I am having trouble copying one database from a one SQL Server to and MSDE
instance.
My environment is set up as follows:
Machine 1: Windows XP Pro with SQL Server 2000 client components
Machine 2: Windows 2003 Server with MSDE 2000.
The two machines are networked but are not part ...more >>
Incrementally loading with SSIS Posted by Kristi at 1/14/2007 5:31:01 PM Hello,
I am very new to SSIS so please be patient if I don't have the proper
SSIS correctly. I am attempting to incrementally populate our AS cube
schemas(datamarts) using SSIS. My source warehouse tables have a last date
modified timestamp column(LoadTS) for each record. Deletes are log...more >>
Execute SQL Task Posted by Paddy at 1/13/2007 11:31:47 AM I want to execute multiple Stored Procedures from a single Execute SQL
Task, all of them being parameterized..
EXEC usp_MySProc2 ?, ?, ?
EXEC usp_MySProc2 ?, ?
If i try this in the Properties pane of the Execute SQL task, SQL
Server is reporting Invalid Parameter Number.. Is there...more >>
Too much persisted security Posted by JXStern at 1/12/2007 8:20:53 AM I've been using DTS for years and, is it possible this has been going
on the whole time?
The default settings for both OLEDB and ODBC connections (for ODBC
connection to SQLServer) are for "persist security" to be set True.
You can click the Advanced button on each and set it to 0 (False), but...more >>
how to set the Variables to a value in a asp script? Posted by Mint at 1/12/2007 7:15:38 AM how can i set the Variables to a value in a asp script?
i have created a dts packedge which include a goble Variable.
the sql task just like 'select * from table where id>?'
and the goble Variable is named myid.
how can i set the Variable 'myid' to a value in a asp script?
can anyone help?
tha...more >>
why my asp script failes to process DTS with access database connection? Posted by Mint at 1/12/2007 7:13:51 AM i want to run an asp script to run DTS packedge.
i have created the packedge in the sql server. only include a
connection to access database
and a only a sql task (select * from acctbl).
i can run the dts successfully in the sql server.
but i can't run it in the Asp script.
when i change the c...more >>
SQL DTS 2005 to 2000 Posted by xiaomei at 1/11/2007 11:15:03 PM Hi, There,
Because the SQL does not support down grade, so I was trying to get my
database from 2005 to 2000 by using DTS, however, after I finish the
transfer, I find only data was transfered, all index and stored process not
coming, is there any other way to save my situation?
Thanks and...more >>
Subqueries in SQL Server Posted by sangu_rao NO[at]SPAM yahoo.co.in at 1/11/2007 9:03:27 PM Hi,
Is there any similar statement in SQL Server for the below Oracle query
SELECT ENAME FROM (SELECT ENAME FROM EMP WHERE DEPTNO = 10)
WHERE SUBSTR(ENAME,1,4) = 'SAHU';
The above one is a Oracle query, i want to know is there any equivalent
query in SQL server.
I don't want to write the q...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Why no row delimiter in fixed text output? Posted by gc at 1/11/2007 4:46:56 PM The row delimiter is not highlighted as an option and sure enough, the
exported data just wraps in a text reader.
Any suggestions?
Thanks...more >>
Impossible to deploy on MSDB Posted by MIB at 1/9/2007 4:05:00 PM Hi,
I'm not be able to deploy my package on MSDB (on package store it works
fine). Each time i'm trying to access to MSDB directory i have an error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
------------------------------
ADDITIONAL INFORMATION:
The ...more >>
Dynamic DTS from Access to Sql2000 and viceversa VB6 Posted by Arejan at 1/9/2007 1:55:30 PM how to create a Dynamic DTS pack to export all tables of a SQL2k
database(including system dbs if required)
into .mdb file
when a new table is created an existing dts packeage will not export
the new table.
so LoadFromSQLServer can be used only if a previous package created
??
how to...more >>
troubleshooting and debuging SSIS script tasks ? Posted by jobs at 1/9/2007 12:23:51 PM I have some vb.net code in an SSIS script task that uses ado to call an
oracle function that schedules a job and returns the job number . I've
tested the code seperately under an asp.net website and it works fine.
However under the ssis script task, an exception kicks out an exception
at the lin...more >>
Calling a SQL Server 2005 SSIS Package Using xp_cmdshell and DTSRUN Posted by jimdefruscio NO[at]SPAM yahoo.com at 1/9/2007 12:00:46 PM Is there a way to use xp_cmdshell (or any other method) to execute an
SSIS package residing on a SQL Server 2005 from a stored procedure on a
SQL Server 2000 database?
I used to have a procedure that used a COPY SQL Server Objects tasks to
copy data from tables from a source (SQL Server 2000) ...more >>
Global Variables in Logging tab Posted by rajalapati NO[at]SPAM gmail.com at 1/9/2007 3:48:08 AM Hi all,
I have an requirement to include Global variables in logging tab for
Error file.
for Creating a new connection and the file name i gave global
variable.
Some thing like this
i have
Set oConnection= oPKG.Connections("EVSVER")
oConnection.Datasource=DTSGlobalVariab...more >>
Can't run my DTS 2005 in a Job Posted by marcoadf at 1/9/2007 3:03:47 AM Hi all.
I've developed a DTS 2005 with 5 blocos wich the sequence is:
1. Execute sql task - where Ihave sql statement TRUNCATE TABLEs "xptos"
2. Execute DTS 2000 Package Task - where I import information
3, 4,5-Execute sql task - where I write these imported info to my
tables.
Now, I've ru...more >>
DTS Packages and SQL Jobs are not executing Posted by sriram at 1/9/2007 3:02:29 AM Hi,
I am not able to execute SQL Jobs and SQL DTS packages.(I am using
SQL2000)....I have checked sql server agent and also i restarted the
sql servies ....but for no respite.
Could anybody please let me know if there could be any other issue.
Thanks,
Sriram
...more >>
help with activex script plz Posted by TG at 1/8/2007 7:50:37 AM hi!
I have a DTS package in which I am running validations on claims. If
they pass they get inserted into xstaging table, if they don't they get
placed into a hold table.
If the validation passes I want to check if there threshold >= 3% and
if so I want do not want to insert the records tha...more >>
Dynamic Properties Task Posted by arijitchatterjee123 NO[at]SPAM yahoo.co.in at 1/8/2007 2:08:42 AM Hi,
I am a new comer in SQL Server DTS area. Can you please explain me what
the fuctionality of "Dynamic Properties Task" with some real life
example? I have gone through the BOL but still now it is not clear to
me.
Thanks in advance...
Regards
Arijit Chatterjee
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |