|
|
|
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 Zip Code File into SQL Table Posted by Colette at 10/13/2006 12:05:03 PM I need to derive address information from the zip code. I have a zip code
file that I need to put into a SQL table. What's the best way to do this?...more >>
Error Importing DTS Package - Invalid access to memory location Posted by John at 10/13/2006 10:44:02 AM I have been importing DTS packages for several weeks just fine, but all of
the sudden I get an error when trying to import a DTS package.
TITLE: Import Package
------------------------------
Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
(Microsoft.SqlServer.Managed...more >>
Microsoft SQL Server 2000 DTS Designer Components Posted by Thomas LaRock at 10/13/2006 10:41:01 AM Hello,
I have downloaded the Microsoft SQL Server 2000 DTS Designer Components so
that i can view SQL 2000 DTS packages through SSMS.
I then created a sql login on the SQL 2000 box, made a connection to that
box through SSMS, and when i try to browse the list of DTS packages I am
present...more >>
SQL Agent Job Posted by ArchieM at 10/13/2006 12:13:47 AM Is there anything like time out for a SQL Agent JOB. How long a SQL
Agent Job can run ?
...more >>
SSIS remove duplicate rows Posted by Ken McClaren at 10/12/2006 3:31:57 PM I'm trying to put together an SSIS package to remove duplicate rows from a
flat file.
Source: Flat file (EDI)
Target: Flat file (EDI)
The aggregate transformation seems to work, however, the output lines are in
a random order. I need retain the line order and just remove the duplicate
row...more >>
Changing DestinationObjectName and SourceObjectName from Parent Package Posted by jennifer_kostuch NO[at]SPAM yahoo.com at 10/12/2006 3:24:06 PM Purpose: Parent package that can be easily created for each of our
clients data.
- sets global variables here and pass to child
- sets create table
- sets connection 1, usually text file
Child package designed to loop through any o...more >>
Exec Sql Task Parameter to ## stored proc Posted by Marty at 10/12/2006 9:34:25 AM I have an SSIS package using an exec sql task being past a variable.
The variable is mapped to a parameter that is then passed to a ##
stored procedure within the sql task, and I am getting the following
error.
Unable to derive parameter information for a temporary stored
procedure.
The r...more >>
restore .bak file Posted by WCM at 10/11/2006 6:38:02 PM
A third party is posting a .bak file to their ftp site for us to pick up and
import into our own sql server. Since we did not backup the original
database from our local sql server, how do we restore this new .bak file to
our own sql server? Or is there some other way to do the import- eith...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Transfer Text to Table Posted by Ray at 10/11/2006 6:23:18 PM I am relatively new to DTS jobs, and for the most part, have just used
the Import and Export wizards to get data in and out of things. I do
OK writing SQL - but by no means am an expert...
Here's my problem.
I have a log file I need to import every day. The problem is I need to
change the na...more >>
DTS Newbie: How to run the DTS package in production Posted by Jerry J at 10/11/2006 3:13:01 PM I created a working DTS package. It imports data from an Access mdb to a SQL
Server database. The package runs perfectly in the developer studio. What I
would like to know is how I use it in a production environment? Do I call it
from a .net application perhaps? I can't seem to find any info...more >>
SSIS - OLE DB Command - how to retrieve query results ??? Posted by frostbb at 10/11/2006 12:27:29 PM How does one retrieve the COUNT(*) value from the following SSIS Ole Db
Command query ??
SELECT COUNT(*) FROM wr_xfer_application WHERE xfer_char = ? AND xfer_nbr =
?
In the current case I need to determine if a record exists for xfer_char /
xfer_nbr ...
if it doesn't exist I need to ...more >>
DTS Dynamic Question Posted by vze1r2ht NO[at]SPAM verizon.net at 10/10/2006 2:56:58 PM I have a ton of IIS log files that I want to import into a table in
SQL.
IIS uses a "space" limiter to seperate into columns.
I want to import each log file into the table. I written a DTS package
to do this BUT everytime the package completes, I have to go in and
switch the source file to ...more >>
How to Debug SSIS Script Component Posted by Chase at 10/10/2006 9:25:02 AM Just a general question.
I'm just getting started designing some Integration Services Packages and am
wondering what's the best way to debug a Script Component in the Data Flow.
Currently I'm just saving all my changes to the script and running the
Package. When I did something wrong in t...more >>
ODBC Imports of entire Database Posted by Don at 10/10/2006 9:13:01 AM I would like to find a way of automating a Database copy and update from an
existing server. I am only able to connect via ODBC to old server to read
and cannot modify anything on the old server.
Is there a way with SSIS to copy that database?
I have as yet been unable to use SQL Management...more >>
DTS Package executes manually, errors when scheduled Posted by Noeuphoria at 10/9/2006 5:29:02 PM I have a very simple DTS package that takes the results of a query and
exports them to a .csv file (on the same computer that is running SQL
server). I can manually execute this package easily, and it works each time.
However, if I schedule it, it always fails on the 1st step (there is only ...more >>
Edit SQL 2000 DTS package from SQL 2005 Posted by lgalusha at 10/9/2006 5:02:46 PM I would like to be able to edit SQL 2000 DTS packages from the SQL 2005
Server Management Studio however I get the message "SQL Server 2000 DTS
Designer components are required to edit DTS packages. Install the special
web download 'SQL Server 2000 DTS Designer Components' to use this feature...more >>
How to change offlineMode Posted by M at 10/9/2006 3:43:04 PM How to change Package's OffLineMode Back to False in Bussiness Intelligence
Develpment Studio Design Mode
Thansk
...more >>
Transactions in Transform Data Task of DTS Posted by rameshsaive NO[at]SPAM gmail.com at 10/9/2006 12:09:46 AM Hey friendz,
I've developed a DTS package from importing data from excel files to
SQL Server and its working according to the requirement except that I
want the transform task to be in a transaction & it should rollback if
any error occurs or else commit the transaction. I've tried using the
...more >>
Advice sought on use of DTS [Long] Posted by Erik Funkenbusch at 10/9/2006 12:00:00 AM I've used DTS for simple tasks for years, largely importing and translating
data from one database to another. However, I've never really scratched
the surface of what DTS can do.
Now I have some need to do a bit more, and I'm looking for a little advice
on where to start looking, and what me...more >>
How to Stop DTS Package Execution Using Procedure Posted by Manoj Kumar at 10/8/2006 5:30:04 AM Hi i wanted to stop the execution of package, scenario is that there is some
flag variable which i have to check within package and within transformation
to stop or to continue the package execution like in data transform task i
want to check the flag value after every batch so it can stop the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |