|
|
|
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 update one column in a table with data from an excel file or table Posted by data_day_and_nite at 10/21/2006 7:52:02 PM I need to update one column in a table that already has data in it.
I need to update one field in each record with the data from an Excel file
The file has the key and field data that need to be inserted
Can some one post an example of this type of update statement, I could import
the data to a...more >>
Passing variables to subpackages with ActiveX scripts in DTS Posted by rmcompute at 10/21/2006 9:11:01 AM I created a package which executes 15 other packages. Each of the inner
packages contains 3 variables which determine which files to load. Is there
a way to set these variables once on the main package and then have them
propagated to the sub packages programmatically? The main package cont...more >>
DTS or SQL Server programming question Posted by Blasting Cap at 10/20/2006 4:56:00 PM I'm not sure exactly where this question ought to reside.....
In our production environment, we have 2 sql servers that we alternate
between different days production totals. For instance, on Friday,
Server #1 (the primary one) will load the previous night's production
totals to it for rep...more >>
LDAP Query Posted by Ray at 10/20/2006 1:39:23 PM Ok - I guess I need some direction here...
I have been given the task of joining some data with data from our
web-based email system for email addresses. The LDAP server is
supposed to be enabled ... but I'm totally stupid...
Where do I need to go to get information on how to query an LDAP
...more >>
Error loading a dbf table to a SQLServer DB by DTS Posted by Ray at 10/20/2006 7:56:02 AM Hi,
I have an issue trying to load a dBase table in a SQLServer 2000 database by
DTS.Trying to open this table for copy it, DTS give next message:
Source error: Microsoft JET Database Engine
Description: Unexpected error from external database driver (10023)
It's funny, cause from Exce...more >>
Is this possible Posted by Wayne Van Rooyen at 10/20/2006 5:14:01 AM We have done a refactor of an access db to a sql db.
I need to somehow keep the data from access in sink with sql, however one of
the problems is that the tables in access are single fields ie.
category->shoes.
During our refactor we made these table have pk so the are now CategoryID->1
and ...more >>
EXECUTE permission denied on object 'sp_dts_getpackage', database 'msdb', schema 'dbo'. Posted by Martin Robins at 10/20/2006 12:00:00 AM I am in the process of finalising some new SSIS packages (based upon =
previous DTS packages, but re-created in SSIS from scratch). One of the =
packages that I am recreating needs to call another of the packages when =
it has completed, however whenever I try this, I get an error. Further =
mor...more >>
package keeps running forever Posted by k_s at 10/19/2006 11:31:02 PM hi
I have a DTS package which actually has only 2 execute package tasks. Both
tasks, if run individually runs very fast (20 second max), but when I run the
entire package it goes for a toss, keeps on running and doesn't stop even
after 30 minutes.
I am using sql 2000 ent edition with win ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
File System Task - Won't delete file Posted by Jeff Reese at 10/19/2006 9:30:02 PM I have a File System Task step in my DTS. It is supposed to delete an Excel
file from my C drive. When I run the DTS in BI Dev Studio it works fine.
However, when I try to run it using SQL Server Agent, the file isn't deleted.
Any ideas of what could cause this behavior?
Thanks.
--
J...more >>
SQL 2000 - Scheduled Job causes system errors Posted by Andrew at 10/19/2006 12:50:52 PM I have a scheduled job that is causing errors in the System Event Log, and I
don't know why.
The job is a DTS package that has two steps -- first step connects to our
AS400 and copies down data, the second step takes that data an formats it
for later use. Whether running the DTS manually, ...more >>
General access denied error when running DTSWizard.exe in SQL2005 Posted by Michael at 10/19/2006 10:16:02 AM Sorry, it's the DTSWizard.exe, not DTSMigrationWizard.exe in my last post.
----------------
When I run DTSWizard.exe in SQL2005, I get a "General access denied
error." I have both SQL2000 & SQL2005 installed on my WinXP professional.
Thanks,
...more >>
"General access denied error" with SQL2005 DTS Posted by Michael at 10/19/2006 10:12:01 AM When I run DTSMigrationWizard.exe in SQL2005, I get a "General access denied
error." I have both SQL2000 & SQL2005 installed on my WinXP professional.
Thanks,
...more >>
SSIS in sql 2005 Posted by mecn at 10/19/2006 9:36:33 AM Hi,
I migrated DTS packages into SSIS. Now how do I modify them in sql 2005
after migration.
Thanks
...more >>
Executing the query failed Posted by GSwan at 10/19/2006 7:55:02 AM Hi all,
I have been looking at deploying an SSIS package which is called by a web
service. I have had to reconfigure the package so that all connections use
windows authentication. This windows account will be the one used by the
application pool which calls the web service. On my developme...more >>
dts package wont delete Posted by checkmate989 NO[at]SPAM gmail.com at 10/19/2006 7:49:45 AM I created a dts package in sql server 7 enterprise manager designer. I
decided that I did not need the package and deleted it.
The package continues to run and I am getting an error ever Minute!!!!
Please help. How do I stop this
...more >>
Changing databases on DTS Transform Data Task Posted by rmcompute at 10/18/2006 5:26:01 PM I created a DTS package which loads data from Access to SQL Server. It will
be used in 15 different databases. The table names are exactly the same in
each database. As I rolled out the package to each database, I changed the
connection object to point to that database. I also had to go ...more >>
SQL2005 SSIS permission? Posted by mecn at 10/18/2006 4:14:44 PM Hi,
I migrated SQL2000 dts packages into sql2005. But I don't see them under
SQL2005 SSIS. I am sysadmin. Do I need specific permission for SSIS
packages? or When I did the migration. the packages were not in SSIS folder?
Where did they go?
Thnaks
...more >>
DTS package migrated from sql 2000 to sql 2005 Posted by mecn at 10/18/2006 2:25:45 PM Hi,
I've migrated dts packages from sql2k to sql2005 successfully, but i dont
see the package in sql2005/ legarcy folder?
Any ideas? or there is something that i was doing incorrectly.
Thanks
...more >>
Excel manipulation in SSIS Posted by Grasshopper at 10/18/2006 1:04:52 PM Hello,
I am new to SSIS, any help is greatly appreciated.
I need to convert a few DTS packages that manupulate excel files to
SSIS. In DTS, I used vbscript task to open excel, insert data from
database, format the data, and save the file. How can I do this in
SSIS? Is it possible? What'...more >>
Global Variable and email Posted by doug at 10/18/2006 11:39:02 AM I have set up a package that runs a query, returns a row count into a global
variable, and then based on that value determines if an email should be sent.
An Active X script in the workflow of the email step is where this
determination is done.
Is it possible to add additional global varia...more >>
Precedence Step Not Working Posted by A. Robinson at 10/18/2006 8:41:02 AM Encountering some odd behavior inside of a DTS package.
The package itself is very simple:
The first step copies data into a temp table. If that step fails, it sends
an e-mail to a list of recipients. If it succeeds, it goes to the next step,
which is to populate the "real" table. If that ...more >>
No any table column shows up during SSIS FussyLookup Posted by Peter at 10/18/2006 8:35:29 AM Hi folks,
I have one developing SSIS Visual Studio project as below:
for the following data flow tasks
step 1. for OLE DB source task, define the input table, and verify columns
selected
step 2. for fussyLookup task | in the reference window, define the
refernece table
step 3. f...more >>
Transferring tables between SQL2005 databases causes error Posted by Nick Gilbert at 10/17/2006 4:54:25 PM Hi,
I have three related questions.
1.
I am trying to import about 30 tables from one SQL 2005 database to another.
However, whenever I do so, I get one of two errors:
ERROR : errorCode=-1073548784 description=Executing the query "TRUNCATE
TABLE [knowledge_website].[dbo].[tblCateg...more >>
Dynamic File Connection Manager in SSIS Posted by papashaw NO[at]SPAM gmail.com at 10/17/2006 3:28:31 PM I would like to create a managed connection to a file that has a new
name each time the SSIS package processes. Is it possible to
dynamically control the name or create the managed connection based on
input parameters?
...more >>
DTS Package as a scheduled Job Posted by LWeiss at 10/17/2006 11:31:33 AM Hello,
I've SQL2000 Standard Edition running on Win2003 server.
I am working with a DTS that was created by a third party software
company. This DTS copys informtion from an iSeries application into a
SQL application. DTS runs fine when I
open in E.M. and execute it also works fine when I sav...more >>
Simple SSIS Primer - How to import a Simple Text File. Posted by robboll at 10/17/2006 8:40:39 AM If I have some simple text data like:
2005A115DWU 096003 24997.28
2005A115DWU 097003 -46718.25
2005A116DWU 000101 127129.38
2005A116DWU 035901 113579.90
2005A116DWU 041002 -7338.00
I can go int...more >>
DTSing to Oracle... Posted by Roz at 10/17/2006 7:06:02 AM Hello, all. I'm xfering data from a SQL 2000 table to an Oracle 10G
database. The table in question contains 41 million records, and is a faily
wide record. I've xfer'd this table from another SQL Server months ago, and
it ran within an hour...very fast indeed. However, my DTS xfer to Orac...more >>
SSIS connection password not saving Posted by lundd NO[at]SPAM fihrst.com at 10/17/2006 3:40:12 AM I have read several posts and articles regarding connection manager
password security in SSIS and how to go about this using configuration
files, changing ProtectionLevel and supplying package passwords, but I
believe my issue is different:
I've designed a package using a configuration file. T...more >>
Migrating DTS to Integration Services Posted by Jerry C at 10/16/2006 1:46:02 PM I am trying to migrate a DTS package from server 2000 to 2005. I is there a
How-to for this.
I am also getting a
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
when I try to expand the MSDB folder in Stored Packages.
Any h...more >>
How to migrate more than 200 DTS to other server Posted by Mike Torry at 10/16/2006 11:49:01 AM I have more that 200 DTS packages saved in "Local Packages" under SQL
Enterprise Manager. I know I can save them one by one to migrate to other
serevr.
Are there any easy way to migrate all 200 DTS ?
Thanks for help,
...more >>
UNC and Batch File Posted by Raja at 10/15/2006 3:41:01 PM Hi,
We are running SQL Server 2000 on Windows 2003 server.
I have a DTS which tries to run a batch file stored on a different server.
When I created this DTS I used UNC to point to the batch file. During the
design time (at the time of designing the DTS) the DTS can see the batch
file. (...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |