|
|
|
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 dts on different machines Posted by sham at 11/21/2006 5:52:02 PM Hi to all,
I am new to dts and sql server and wish to know if this is possible.
We want to know if sql server allows you to run dts's on different machines?
What I mean is some sort of architecture that allocates a dts to a client
machine that does the work and another dts is assigned to a...more >>
Package Deployment Posted by Aaron at 11/21/2006 2:46:02 PM I am trying to deploy an SSIS package that I created. Within the SSIS
package, there is an ADO.NET connection manager that contains my connection
information. This runs fine from Visual Studio on my machine. However,
after I deploy the package to the SQL Server 2005 machine using the manife...more >>
SMTP Mail Task Problem - can't connect locally Posted by Dustin at 11/21/2006 11:33:01 AM I am using SMTP Mail Task on a windows 2003 server and have the SMTP
Virtual Server portion of IIS running with anonymous access enabled. I
have a DTS package which consists of a single SMTPMail task that sends
an email to myself via the server I just mentioned.
When I run this task from an e...more >>
SSIS 2005 Execute SQL Task RAISERROR Posted by rcaruso NO[at]SPAM hotmail.com at 11/21/2006 11:22:58 AM I appreciate people's help in advance. Here is my issue:
I have created an Integration Services Package that contains an Execute
SQL task with the following code:
BEGIN
SELECT *
FROM dbo.TABLE
WHERE Period+Year IN (SELECT (Period+Year)SearchOn from TBL_OUTPUT
GROUP BY Period+Yea...more >>
DTS and Spreedsheets in excel file Posted by xy2003ca at 11/21/2006 10:58:02 AM Could I get the spreedsheet name and use it in DTS package using VBScript in
ActiveX task...more >>
SSIS Export/Import in Virtual Studio ALTERNATIVE Posted by Rune. at 11/21/2006 6:21:02 AM Hi.
Does anyone know an alternative to SSIS Export/Import in Virtual Studio?
I need this because i have customers who needs to copy or move their
databases to other SQL servers. So if you have an util or a program that have
these fetures please respond.
Regards Rune.
...more >>
Copy database wizard issues Posted by kak37 at 11/20/2006 10:11:02 PM I am a newbie DBA. That being said, here is what I am running into trying to
use the "Copy Database Wizard (CDW)". Yes, I have read that I can use backup
and restore, attach/detach but I would like to know why this approach didn't
work. Here is the scenario:
Source server: windows server 2...more >>
Passing database name as a parameter to execute SQL task Posted by Irene at 11/20/2006 5:21:52 PM Hi there,
I am using DTS script for the conversion. I would like to get a
database name as a parameter from the user (through a command line),
assign it to the package global variable, and then use Execute SQL task
to drop and recreate a database with such name. However, I have
troubles passing...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS Variable Posted by Marko Praprotnik at 11/20/2006 9:16:22 AM I'm new to SQL Server 2005 and I want to copy data from one db to
another db. For source data flow object i want to use OLE DB Source
Query bacause I want include variable in sql statement.
SELECT Name,Tag,DDate,
FROM ICRA_39_Dok
WHERE (DDAte = ?)
I have dat named package vari...more >>
SSIS gets wrong datatype from Store Procedure returned recordset. Posted by Benjamin at 11/20/2006 9:10:03 AM Hi, has anyone experience problems with retriving wrong metadata info from
store procedure?
I have a stored procedure (SP) that joins three tables, I used SSIS OLD DB
Source calling the SP, but the returned data type mapping is wrong and I
can't seem to overwrite them with the correct on, t...more >>
Data via TCP/IP Posted by Stefan at 11/20/2006 2:35:01 AM Hi,
we use SQL Server 2005.
Every 3 seconds we get a string via TCP/IP which data have to be stored in
our database.
Is it possible to read the data directly from the port to the database or do
we have to program a listener which gets the data and pushes them into our
table?
Sorry for ...more >>
DTS default Set Identity Insert on in SQL 2005 ? Posted by Ivan at 11/18/2006 12:00:00 AM Dear all,
Is that DTS default Set Identity Insert off in SQL 2005?
How can I start the DTS with default Set Identity Insert on?
Ivan
...more >>
Backing up tables that are not available at the dts run time Posted by Irene at 11/17/2006 4:49:17 PM Hi,
As a part of dts conversion, I need to convert tables between MS SQL
databases. The sourse database, however, is not available at the time
of running the script, so I have back it up in some way. At the moment,
I am using dts to trasform those tables into text files, and load them
at the ...more >>
Send Mail Task - MAPI Logon Failed Posted by rgn at 11/16/2006 1:02:01 PM Hello All,
I was trying to create a Send Mail task.The SQLServer service account runs
off of its own account. The SQLServer Agent also runs off of its own account.
I login with my network login id (Windows Authentication).
When I login to my workstation and create a DTS package with a send...more >>
Trapping a Sql2000 DTS error Posted by John at 11/16/2006 10:03:02 AM I inherited some code that executes a DTS package that pulls from a site in
Australia. Works great, unless someone in Oz decides to turn off our access,
in which case login fails.
When we run it from inside Enterprise Manager, we are dutifully informed
what happened. When we run it from a...more >>
DTS Package remotely in batch file Posted by tiv at 11/16/2006 9:51:26 AM Hello all,
I know others have posted for this topic (and i've read them all....),
but haven't read a surefire answer. So please bare with me....
I am trying to execute a DTS package in SQL 2000 on a server from a
remote client without SQL tools installed. I'm trying to get this to
run wit...more >>
Import a BAS module to MSDE? Posted by Craig Buchanan at 11/16/2006 8:54:05 AM I would like to import a DTS package that has been saved as a BAS module
into MSDE from within a VBA script. Is this possible?
Thanks for your time.
Craig Buchanan
...more >>
Q:Recomendation SSIS package location Posted by IanO at 11/16/2006 6:36:47 AM I am just about to put my first ssis package into production. Not only
is it my first, its the first one where I am working. SSIS gives us
choices about locations in which to store the packages. Would someone
care to discuss the pros and cons of each?
Any "war stories" of your experience are a...more >>
DTS Package and SQL Agent Job Posted by Chris W at 11/15/2006 1:40:02 PM Running SS2K here...I have a DTS package that is scheduled to run as a Job
under the SQL Server Agent. My job needs to pull data from a non-SQL server
database every day and once (only) each day. I have a pre-set time when I can
start to "poll" the source database to see if the data is ready t...more >>
Multiple record type/length file Posted by bigbrorpi NO[at]SPAM gmail.com at 11/15/2006 7:58:55 AM Hi -
I'm trying to import a file that has multiple record types in random
order into various tables.
For example:
Record Type A
Record Type B
Record Type A
Record Type C
Each type has different fields and is of a different length, and
obviously requires different logic to parse and inse...more >>
DTS stops execution of sql proc when encounter message 3604 Posted by LiLy at 11/15/2006 3:35:01 AM One of the steps in my sql proc creates unique index with ignore_dup_key
option. The proc works fine in SQL analyser, although it does display message
3604 - Duplicate key ignored. I use this method to eliminate duplicate rows
during insert.
When this proc is executed from DTS, it terminates ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |